APPS.POR_UTIL_PKG dependencies on DUAL

Line 422: --select POR_REQ_NUMBER_S.nextval into l_req_num from sys.dual;

418: --to remove dependency on POR_REQ_NUMBER_S sequence
419:
420: cursorID := dbms_sql.open_cursor;
421:
422: --select POR_REQ_NUMBER_S.nextval into l_req_num from sys.dual;
423: sqlString := 'select POR_REQ_NUMBER_S.nextval from sys.dual';
424: dbms_sql.parse(cursorID, sqlString, dbms_sql.NATIVE);
425: dbms_sql.define_column(cursorID, 1, l_req_num);
426: result := dbms_sql.execute_and_fetch(cursorID,false);

Line 423: sqlString := 'select POR_REQ_NUMBER_S.nextval from sys.dual';

419:
420: cursorID := dbms_sql.open_cursor;
421:
422: --select POR_REQ_NUMBER_S.nextval into l_req_num from sys.dual;
423: sqlString := 'select POR_REQ_NUMBER_S.nextval from sys.dual';
424: dbms_sql.parse(cursorID, sqlString, dbms_sql.NATIVE);
425: dbms_sql.define_column(cursorID, 1, l_req_num);
426: result := dbms_sql.execute_and_fetch(cursorID,false);
427: dbms_sql.column_value(cursorID, 1, l_req_num);

Line 432: --select POR_REQ_NUMBER_S.nextval into l_req_num from sys.dual;

428:
429: WHILE (req_number_invalid(l_req_num) AND l_counter <= l_no_of_trials ) LOOP
430: result := dbms_sql.execute_and_fetch(cursorID,false);
431: dbms_sql.column_value(cursorID, 1, l_req_num);
432: --select POR_REQ_NUMBER_S.nextval into l_req_num from sys.dual;
433: l_counter := l_counter + 1;
434: END LOOP;
435:
436: dbms_sql.close_cursor(cursorID);

Line 1443: FROM sys.dual;

1439:
1440: SELECT
1441: to_char(req_Header_Id) || '-' || to_char(PO_WF_ITEMKEY_S.nextval)
1442: INTO p_item_key
1443: FROM sys.dual;
1444:
1445: SELECT
1446: wf_approval_itemtype,
1447: wf_approval_process

Line 1884: -- validate individual segments based on passed validation date

1880: IF result =1 THEN
1881: result := validate_flex_enabled;
1882: END IF;
1883:
1884: -- validate individual segments based on passed validation date
1885: IF result = 1 THEN
1886: res := fnd_flex_keyval.validate_segs('CHECK_SEGMENTS','SQLGL','GL#',X_chartOfAccountsId,X_concatSegs,'V',NVL(X_validationDate, sysdate));
1887: IF res = FALSE THEN
1888: result := -1;