APPS.AP_WORKFLOW_PKG dependencies on WF_ITEMS

Line 5885: FROM wf_items

5881:
5882: BEGIN
5883: SELECT end_date
5884: INTO l_end_date
5885: FROM wf_items
5886: WHERE item_type = 'APINVAPR'
5887: AND item_key = l_invoice_key;
5888:
5889: l_wf_exist := TRUE;

Line 7048: FROM wf_items

7044: the parent. */
7045: CURSOR key_cur IS
7046: SELECT item_key, item_type,root_activity,
7047: SUBSTR(item_key,1,INSTR(item_key,'_')-1) invoice_id
7048: FROM wf_items
7049: WHERE item_type IN ('APINVAPR','APINVNEG')
7050: AND end_date is NOT NULL
7051: ORDER BY decode(root_activity,'APPROVAL_MAIN','3'
7052: ,'APPROVAL_INVOICE_LINES','2'

Line 7056: l_item_key wf_items.item_key%TYPE;

7052: ,'APPROVAL_INVOICE_LINES','2'
7053: ,'APPROVAL_NEGOTIATION', '1') asc;
7054:
7055: l_api_name CONSTANT VARCHAR2(200) := 'Terminate_Approval';
7056: l_item_key wf_items.item_key%TYPE;
7057: l_item_type wf_items.item_type%TYPE;
7058: l_process wf_items.root_activity%TYPE;
7059: l_invoice_id NUMBER;
7060: l_debug_info VARCHAR2(2000);

Line 7057: l_item_type wf_items.item_type%TYPE;

7053: ,'APPROVAL_NEGOTIATION', '1') asc;
7054:
7055: l_api_name CONSTANT VARCHAR2(200) := 'Terminate_Approval';
7056: l_item_key wf_items.item_key%TYPE;
7057: l_item_type wf_items.item_type%TYPE;
7058: l_process wf_items.root_activity%TYPE;
7059: l_invoice_id NUMBER;
7060: l_debug_info VARCHAR2(2000);
7061: l_calling_sequence VARCHAR2(2000);

Line 7058: l_process wf_items.root_activity%TYPE;

7054:
7055: l_api_name CONSTANT VARCHAR2(200) := 'Terminate_Approval';
7056: l_item_key wf_items.item_key%TYPE;
7057: l_item_type wf_items.item_type%TYPE;
7058: l_process wf_items.root_activity%TYPE;
7059: l_invoice_id NUMBER;
7060: l_debug_info VARCHAR2(2000);
7061: l_calling_sequence VARCHAR2(2000);
7062: