DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_WF_ITEMKEY_S

Line 806: SELECT TO_CHAR(PO_WF_ITEMKEY_S.NEXTVAL) INTO l_seq_for_item_key FROM sys.dual;

802: END IF;
803: END IF;
804: -- Mod Project
805: IF (ItemKey IS NULL) THEN
806: SELECT TO_CHAR(PO_WF_ITEMKEY_S.NEXTVAL) INTO l_seq_for_item_key FROM sys.dual;
807:
808: l_itemkey := TO_CHAR(DocumentID) || '-' || l_seq_for_item_key;
809: ELSE
810: l_itemkey := ItemKey;

Line 7091: SELECT TO_CHAR(PO_WF_ITEMKEY_S.NEXTVAL) INTO l_seq FROM sys.dual;

7087: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
7088: ELSE
7089: l_document_id := document_id;
7090: END IF;
7091: SELECT TO_CHAR(PO_WF_ITEMKEY_S.NEXTVAL) INTO l_seq FROM sys.dual;
7092:
7093: Err_ItemKey := TO_CHAR(l_document_id) || '-' || l_seq;
7094: x_progress := 'PO_REQAPPROVAL_INIT1.send_error_notif: 50' ||' Parent Itemtype: '|| ItemType ||' Parent Itemkey: '|| ItemKey ||' Error Itemtype: '|| Err_ItemType ||' Error Itemkey: '|| Err_ItemKey;
7095: IF (g_po_wf_debug = 'Y') THEN