APPS.PO_AUTOCREATE_DOC dependencies on PO_WF_ITEMKEY_S

Line 443: select to_char(PO_WF_ITEMKEY_S.NEXTVAL)

439: END IF;
440:
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

Line 533: SELECT to_char(PO_WF_ITEMKEY_S.NEXTVAL)

529: END IF;
530:
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

Line 4526: select to_char(PO_WF_ITEMKEY_S.NEXTVAL)

4522: --
4523:
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

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,