APPS.PO_AUTOCREATE_DOC dependencies on DUAL

Line 404: from sys.dual;

400: */
401:
402: select to_char(PO_WF_GROUP_S.NEXTVAL)
403: into x_group_id
404: from sys.dual;
405:
406:
407: /* Store the group_id so grouping (later) only considers
408: * records with this group_id.

Line 445: from sys.dual;

441: /* Get the unique sequence to make sure item key will be unique */
442:
443: select to_char(PO_WF_ITEMKEY_S.NEXTVAL)
444: into x_seq_for_item_key
445: from sys.dual;
446:
447: /* The item key is the req_line_id concatenated with the
448: * unique id from a seq.
449: */

Line 497: FROM sys.dual;

493: --which in this case are all the lines belonging to the one req.
494:
495: SELECT to_char(PO_WF_GROUP_S.NEXTVAL)
496: INTO x_group_id
497: FROM sys.dual;
498:
499: -- Store the group_id so grouping (later) only considers
500: -- records with this group_id.
501: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => itemtype,

Line 535: FROM sys.dual;

531: --Get the unique sequence to make sure item key will be unique
532:
533: SELECT to_char(PO_WF_ITEMKEY_S.NEXTVAL)
534: INTO x_seq_for_item_key
535: FROM sys.dual;
536:
537: --The item key is the req_line_id concatenated with the
538: --unique id from a seq.
539:

Line 3818: from sys.dual;

3814: /* Get the interface_header_id from the sequence */
3815:
3816: select po_headers_interface_s.nextval
3817: into x_interface_header_id
3818: from sys.dual;
3819:
3820: /* Set the batch id which can be the same as
3821: * the interface_header_id since we create only one
3822: * po at a time from workflow

Line 4331: from sys.dual;

4327:
4328:
4329: select po_lines_interface_s.nextval
4330: into x_interface_line_id
4331: from sys.dual;
4332:
4333: /* GA FPI start */
4334:
4335: if x_source_doc_id is not null and

Line 4528: from sys.dual;

4524: /* Get the unique sequence to make sure item key will be unique */
4525:
4526: select to_char(PO_WF_ITEMKEY_S.NEXTVAL)
4527: into x_seq_for_item_key
4528: from sys.dual;
4529:
4530: /* The item key is the interface_header_id concatenated with the
4531: * unique id from a seq.
4532: */

Line 6067: select to_char(PO_WF_ITEMKEY_S.NEXTVAL) into l_seq from sys.dual;

6063: -- Create wf process.
6064:
6065: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 040';
6066:
6067: select to_char(PO_WF_ITEMKEY_S.NEXTVAL) into l_seq from sys.dual;
6068: ItemKey := to_char(p_req_header_id) || '-' || l_seq;
6069:
6070: wf_engine.CreateProcess( ItemType => ItemType,
6071: ItemKey => ItemKey,