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 488: FROM wf_items

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

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

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

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

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

Line 851: FROM wf_items

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

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

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

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

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

Line 3400: l_item_type wf_items.item_type%TYPE;

3396: display_type in varchar2,
3397: document in out NOCOPY varchar2,
3398: document_type in out NOCOPY varchar2) IS
3399:
3400: l_item_type wf_items.item_type%TYPE;
3401: l_item_key wf_items.item_key%TYPE;
3402:
3403: l_document VARCHAR2(32000) := '';
3404: l_document_1 VARCHAR2(32000) := '';

Line 3401: l_item_key wf_items.item_key%TYPE;

3397: document in out NOCOPY varchar2,
3398: document_type in out NOCOPY varchar2) IS
3399:
3400: l_item_type wf_items.item_type%TYPE;
3401: l_item_key wf_items.item_key%TYPE;
3402:
3403: l_document VARCHAR2(32000) := '';
3404: l_document_1 VARCHAR2(32000) := '';
3405: l_document_2 VARCHAR2(32000) := '';