APPS.PO_AUTOCREATE_DOC dependencies on DUAL

Line 480: from sys.dual;

476: */
477:
478: select to_char(PO_WF_GROUP_S.NEXTVAL)
479: into x_group_id
480: from sys.dual;
481:
482:
483: /* Store the group_id so grouping (later) only considers
484: * records with this group_id.

Line 525: from sys.dual;

521: /* Get the unique sequence to make sure item key will be unique */
522:
523: select to_char(PO_WF_ITEMKEY_S.NEXTVAL)
524: into x_seq_for_item_key
525: from sys.dual;
526:
527: /* The item key is the req_line_id concatenated with the
528: * unique id from a seq.
529: */

Line 580: from sys.dual;

576: /* Get the unique sequence to make sure item key will be unique */
577:
578: select to_char(PO_WF_ITEMKEY_S.NEXTVAL)
579: into x_seq_for_item_key
580: from sys.dual;
581:
582: /* The item key is the req_line_id concatenated with the
583: * unique id from a seq.
584: */

Line 634: from sys.dual;

630: /* Get the unique sequence to make sure item key will be unique */
631:
632: select to_char(PO_WF_ITEMKEY_S.NEXTVAL)
633: into x_seq_for_item_key
634: from sys.dual;
635:
636: /* The item key is the req_line_id concatenated with the
637: * unique id from a seq.
638: */

Line 686: FROM sys.dual;

682: --which in this case are all the lines belonging to the one req.
683:
684: SELECT to_char(PO_WF_GROUP_S.NEXTVAL)
685: INTO x_group_id
686: FROM sys.dual;
687:
688: -- Store the group_id so grouping (later) only considers
689: -- records with this group_id.
690: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => itemtype,

Line 724: FROM sys.dual;

720: --Get the unique sequence to make sure item key will be unique
721:
722: SELECT to_char(PO_WF_ITEMKEY_S.NEXTVAL)
723: INTO x_seq_for_item_key
724: FROM sys.dual;
725:
726: --The item key is the req_line_id concatenated with the
727: --unique id from a seq.
728:

Line 4143: from sys.dual;

4139: /* Get the interface_header_id from the sequence */
4140:
4141: select po_headers_interface_s.nextval
4142: into x_interface_header_id
4143: from sys.dual;
4144:
4145: /* Set the batch id which can be the same as
4146: * the interface_header_id since we create only one
4147: * po at a time from workflow

Line 4656: from sys.dual;

4652:
4653:
4654: select po_lines_interface_s.nextval
4655: into x_interface_line_id
4656: from sys.dual;
4657:
4658: /* GA FPI start */
4659:
4660: if x_source_doc_id is not null and

Line 4853: from sys.dual;

4849: /* Get the unique sequence to make sure item key will be unique */
4850:
4851: select to_char(PO_WF_ITEMKEY_S.NEXTVAL)
4852: into x_seq_for_item_key
4853: from sys.dual;
4854:
4855: /* The item key is the interface_header_id concatenated with the
4856: * unique id from a seq.
4857: */

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

6490: -- Create wf process.
6491:
6492: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 040';
6493:
6494: select to_char(PO_WF_ITEMKEY_S.NEXTVAL) into l_seq from sys.dual;
6495: ItemKey := to_char(p_req_header_id) || '-' || l_seq;
6496:
6497: wf_engine.CreateProcess( ItemType => ItemType,
6498: ItemKey => ItemKey,