APPS.PO_AUTOCREATE_DOC dependencies on PO_WF_ITEMKEY_S

Line 523: select to_char(PO_WF_ITEMKEY_S.NEXTVAL)

519: END IF;
520:
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

Line 578: select to_char(PO_WF_ITEMKEY_S.NEXTVAL)

574: END IF;
575:
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

Line 632: select to_char(PO_WF_ITEMKEY_S.NEXTVAL)

628: END IF;
629:
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

Line 722: SELECT to_char(PO_WF_ITEMKEY_S.NEXTVAL)

718: END IF;
719:
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

Line 4851: select to_char(PO_WF_ITEMKEY_S.NEXTVAL)

4847: --
4848:
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

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,