APPS.PORCPTWF dependencies on WF_ITEMS

Line 354: -- Call WF purge API to remove any existing Confirm Receipts WF items

350:
351: x_WF_ItemKey := ' ';
352: x_WF_ItemKey_save := ' ';
353:
354: -- Call WF purge API to remove any existing Confirm Receipts WF items
355: -- which are completed with an END_DATE less than or equal to
356: -- SYSDATE (default). This is to ensure that the Selection
357: -- process can start the workflow process for the same item key value.
358: --

Line 359: -- The WF purge API will not remove any WF items which are still

355: -- which are completed with an END_DATE less than or equal to
356: -- SYSDATE (default). This is to ensure that the Selection
357: -- process can start the workflow process for the same item key value.
358: --
359: -- The WF purge API will not remove any WF items which are still
360: -- opened with END_DATE = NULL;
361:
362:
363: WF_PURGE.total ('PORCPT');

Line 486: FROM wf_items

482: -- Requirement - We should not send the notification if
483: -- there are any active processes for the po_header_id and
484: -- requester_id combination.
485: SELECT count(1) into x_item_key_count
486: FROM wf_items
487: WHERE item_type = 'PORCPT'
488: AND item_key like x_po_header_id||';'|| x_requester_id||';%'
489: AND END_DATE is null;
490:

Line 738: -- Call WF purge API to remove any existing Confirm Receipts WF items

734:
735: x_WF_ItemKey := ' ';
736: x_WF_ItemKey_save := ' ';
737:
738: -- Call WF purge API to remove any existing Confirm Receipts WF items
739: -- which are completed with an END_DATE less than or equal to
740: -- SYSDATE (default). This is to ensure that the Selection
741: -- process can start the workflow process for the same item key value.
742: --

Line 743: -- The WF purge API will not remove any WF items which are still

739: -- which are completed with an END_DATE less than or equal to
740: -- SYSDATE (default). This is to ensure that the Selection
741: -- process can start the workflow process for the same item key value.
742: --
743: -- The WF purge API will not remove any WF items which are still
744: -- opened with END_DATE = NULL;
745:
746:
747: WF_PURGE.total ('PORCPT');

Line 849: FROM wf_items

845:
846: -- Check if there is any active workflow process running
847: -- for the so_header_id and requester_id combination
848: SELECT count(1) into x_item_key_count
849: FROM wf_items
850: WHERE item_type = 'PORCPT'
851: AND item_key like x_header_id||';'|| x_requester_id||';%'
852: AND END_DATE is null;
853:

Line 2275: -- Call WF purge API to remove any existing Confirm Receipts WF items

2271:
2272: x_WF_ItemKey := ' ';
2273: x_WF_ItemKey_save := ' ';
2274:
2275: -- Call WF purge API to remove any existing Confirm Receipts WF items
2276: -- which are completed with an END_DATE less than or equal to
2277: -- SYSDATE (default). This is to ensure that the Selection
2278: -- process can start the workflow process for the same item key value.
2279: --

Line 2280: -- The WF purge API will not remove any WF items which are still

2276: -- which are completed with an END_DATE less than or equal to
2277: -- SYSDATE (default). This is to ensure that the Selection
2278: -- process can start the workflow process for the same item key value.
2279: --
2280: -- The WF purge API will not remove any WF items which are still
2281: -- opened with END_DATE = NULL;
2282:
2283:
2284: WF_PURGE.total ('PORCPT');

Line 3355: l_item_type wf_items.item_type%TYPE;

3351: display_type in varchar2,
3352: document in out NOCOPY varchar2,
3353: document_type in out NOCOPY varchar2) IS
3354:
3355: l_item_type wf_items.item_type%TYPE;
3356: l_item_key wf_items.item_key%TYPE;
3357:
3358: l_document VARCHAR2(32000) := '';
3359: l_document_1 VARCHAR2(32000) := '';

Line 3356: l_item_key wf_items.item_key%TYPE;

3352: document in out NOCOPY varchar2,
3353: document_type in out NOCOPY varchar2) IS
3354:
3355: l_item_type wf_items.item_type%TYPE;
3356: l_item_key wf_items.item_key%TYPE;
3357:
3358: l_document VARCHAR2(32000) := '';
3359: l_document_1 VARCHAR2(32000) := '';
3360: l_document_2 VARCHAR2(32000) := '';