APPS.POR_UTIL_PKG dependencies on DUAL

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

450: --to remove dependency on POR_REQ_NUMBER_S sequence
451:
452: cursorID := dbms_sql.open_cursor;
453:
454: --select POR_REQ_NUMBER_S.nextval into l_req_num from sys.dual;
455: sqlString := 'select POR_REQ_NUMBER_S.nextval from sys.dual';
456: dbms_sql.parse(cursorID, sqlString, dbms_sql.NATIVE);
457: dbms_sql.define_column(cursorID, 1, l_req_num);
458: result := dbms_sql.execute_and_fetch(cursorID,false);

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

451:
452: cursorID := dbms_sql.open_cursor;
453:
454: --select POR_REQ_NUMBER_S.nextval into l_req_num from sys.dual;
455: sqlString := 'select POR_REQ_NUMBER_S.nextval from sys.dual';
456: dbms_sql.parse(cursorID, sqlString, dbms_sql.NATIVE);
457: dbms_sql.define_column(cursorID, 1, l_req_num);
458: result := dbms_sql.execute_and_fetch(cursorID,false);
459: dbms_sql.column_value(cursorID, 1, l_req_num);

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

460:
461: WHILE (req_number_invalid(l_req_num) AND l_counter <= l_no_of_trials ) LOOP
462: result := dbms_sql.execute_and_fetch(cursorID,false);
463: dbms_sql.column_value(cursorID, 1, l_req_num);
464: --select POR_REQ_NUMBER_S.nextval into l_req_num from sys.dual;
465: l_counter := l_counter + 1;
466: END LOOP;
467:
468: dbms_sql.close_cursor(cursorID);

Line 1591: FROM sys.dual;

1587:
1588: SELECT
1589: to_char(req_Header_Id) || '-' || to_char(PO_WF_ITEMKEY_S.nextval)
1590: INTO p_item_key
1591: FROM sys.dual;
1592:
1593: SELECT
1594: wf_approval_itemtype,
1595: wf_approval_process

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

2029: IF result =1 THEN
2030: result := validate_flex_enabled;
2031: END IF;
2032:
2033: -- validate individual segments based on passed validation date
2034: IF result = 1 THEN
2035: gl_global.set_aff_validation('XX',null);
2036: res := fnd_flex_keyval.validate_segs('CHECK_SEGMENTS','SQLGL','GL#',X_chartOfAccountsId,X_concatSegs,'V',NVL(X_validationDate, sysdate));
2037: IF res = FALSE THEN

Line 3804: SELECT 'Y' INTO l_are_udas_already_present FROM dual WHERE EXISTS

3800: l_progress := '010';
3801: l_log_msg := 'Starting create_req_line_from_po_line';
3802:
3803: BEGIN
3804: SELECT 'Y' INTO l_are_udas_already_present FROM dual WHERE EXISTS
3805: (SELECT extension_id FROM po_req_lines_ext_b
3806: WHERE REQUISITION_LINE_ID = p_req_line_id);
3807: EXCEPTION
3808: WHEN no_data_found THEN

Line 5955: select to_char (PO_WF_ITEMKEY_S.NEXTVAL) into l_seq_for_item_key from sys.dual;

5951: l_notification_id NUMBER;
5952: l_segment1 VARCHAR2(30);
5953:
5954: BEGIN
5955: select to_char (PO_WF_ITEMKEY_S.NEXTVAL) into l_seq_for_item_key from sys.dual;
5956: l_itemkey := to_char(p_document_id) || '-' || l_seq_for_item_key;
5957: l_itemtype := 'REQAPPRV';
5958: l_progress := 'POR_UTIL_PKG.Start_Email_WF_Process: at beginning of Start_Email_WF_Process';
5959: