APPS.AP_WORKFLOW_PKG dependencies on WF_ITEMS

Line 6152: FROM wf_items

6148:
6149: BEGIN
6150: SELECT end_date
6151: INTO l_end_date
6152: FROM wf_items
6153: WHERE item_type = 'APINVAPR'
6154: AND item_key = l_invoice_key;
6155:
6156: l_wf_exist := TRUE;

Line 7360: FROM wf_items

7356: --cursor commented for bug 14492241 and added new
7357: /* CURSOR key_cur IS
7358: SELECT item_key, item_type,root_activity,
7359: SUBSTR(item_key,1,INSTR(item_key,'_')-1) invoice_id
7360: FROM wf_items
7361: WHERE item_type IN ('APINVAPR','APINVNEG')
7362: AND end_date is NULL -- Bug No 10172485
7363: ORDER BY decode(root_activity,'APPROVAL_MAIN','3'
7364: ,'APPROVAL_INVOICE_LINES','2'

Line 7372: FROM wf_items wf,

7368: --bug 14492241 added
7369: CURSOR key_cur IS
7370: SELECT item_key, item_type,root_activity,
7371: ai.invoice_id
7372: FROM wf_items wf,
7373: ap_invoices_all ai
7374: WHERE wf.item_type IN ('APINVAPR','APINVNEG')
7375: AND wf.end_date is NULL -- Bug No 10172485
7376: and ai.invoice_id||'_'||ai.approval_iteration = wf.item_key

Line 7383: l_item_key wf_items.item_key%TYPE;

7379: ,'APPROVAL_INVOICE_LINES','2'
7380: ,'APPROVAL_NEGOTIATION', '1') asc;
7381:
7382: l_api_name CONSTANT VARCHAR2(200) := 'Terminate_Approval';
7383: l_item_key wf_items.item_key%TYPE;
7384: l_item_type wf_items.item_type%TYPE;
7385: l_process wf_items.root_activity%TYPE;
7386: l_invoice_id NUMBER;
7387: l_debug_info VARCHAR2(2000);

Line 7384: l_item_type wf_items.item_type%TYPE;

7380: ,'APPROVAL_NEGOTIATION', '1') asc;
7381:
7382: l_api_name CONSTANT VARCHAR2(200) := 'Terminate_Approval';
7383: l_item_key wf_items.item_key%TYPE;
7384: l_item_type wf_items.item_type%TYPE;
7385: l_process wf_items.root_activity%TYPE;
7386: l_invoice_id NUMBER;
7387: l_debug_info VARCHAR2(2000);
7388: l_calling_sequence VARCHAR2(2000);

Line 7385: l_process wf_items.root_activity%TYPE;

7381:
7382: l_api_name CONSTANT VARCHAR2(200) := 'Terminate_Approval';
7383: l_item_key wf_items.item_key%TYPE;
7384: l_item_type wf_items.item_type%TYPE;
7385: l_process wf_items.root_activity%TYPE;
7386: l_invoice_id NUMBER;
7387: l_debug_info VARCHAR2(2000);
7388: l_calling_sequence VARCHAR2(2000);
7389: