Posts by Doyensys

Email Validation using PL/SQL Function

Email Validation Function using plsql function CREATE FUNCTION f_email_validate (pi_email_id IN OUT VARCHAR2)    RETURN BOOLEAN IS    lv_n_check_len      NUMBER;    lv_b_check_in_at    BOOLEAN;    lv_b_check_in_dot   BOOLEAN;    lv_v_extn           VARCHAR2 (10);…

Using Oracle Forms to load local files

using the below code In load file “button” using “when-button-pressed” trigger. DECLARE    l_userhome            VARCHAR2 (200)          := webutil_clientinfo.get_system_property (‘user.home’)             || ‘Desktop’;    l_filename            VARCHAR2 (200) := NULL;   …

Load JSON File to Oracle table

For Example : 1)  Sample Json:- {   “department”: {     “department_number”: 10,     “department_name”: “ACCOUNTING”,     “employees”: [       {         “employee_number”: 7782,         “employee_name”: “CLARK”       },      …

Punchout in Oracle iProcurement

Punchout in Oracle iProcurement   Punchout is an Oracle standard functionality to purchase an item directly from supplier’s website by a requester.In this feature, the supplier catalogue contains latest product…

Personalization at Adjustment/Sales order/Credit Memo application form

This component can be used, for requirement related to personalization where we want to restrict the user to create RMA/Adjustment/Credit memo if certain(user defined) conditions are not met. Personalization at Transaction/Adjustment…

Create AR Transaction/Invoice adjustment(API)

Scope: To apply the adjustment in AR Invoice. (eg. To make AR Invoice amount roundoff). Before RoundOff adjustment API. Applying Adjustment through API. —++———————————-Code—————–++————————- DECLARE up_adj_rec         …

Opening Modal Dialog page using JavaScript

In APEX, when there is a requirement for opening pages dynamically JavaScript must be used. Normal pages can be easily opened in JavaScript’s by mentioning the URL using window.location, but…

Hiding Hidden column cells in IR using CSS

Select List Pagination in APEX IG

One main disadvantage of APEX Interactive Grid is the pagination. IG default pagination doesn’t have the option as classic Select List Pagination, instead it has page by page selection with…

Refresh IG on Region Display Selector Activation

Interactive Grid region within the region display selector must be refreshed every time on click/activation of the region display selector. This can be achieved by using the below code there…