eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WORKFLOW_PKG dependencies on AP_INVOICES_ALL

Line 74: l_item_sum ap_invoices_all.invoice_amount%TYPE;

70: p_invoice_id IN NUMBER,
71: p_calling_sequence IN VARCHAR2)
72:
73: IS
74: l_item_sum ap_invoices_all.invoice_amount%TYPE;
75: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
76: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
77: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
78: l_retained_sum ap_invoices_all.invoice_amount%TYPE;

Line 75: l_tax_sum ap_invoices_all.invoice_amount%TYPE;

71: p_calling_sequence IN VARCHAR2)
72:
73: IS
74: l_item_sum ap_invoices_all.invoice_amount%TYPE;
75: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
76: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
77: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
78: l_retained_sum ap_invoices_all.invoice_amount%TYPE;
79: l_curr_calling_sequence VARCHAR2(2000);

Line 76: l_misc_sum ap_invoices_all.invoice_amount%TYPE;

72:
73: IS
74: l_item_sum ap_invoices_all.invoice_amount%TYPE;
75: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
76: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
77: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
78: l_retained_sum ap_invoices_all.invoice_amount%TYPE;
79: l_curr_calling_sequence VARCHAR2(2000);
80: l_debug_info VARCHAR2(500);

Line 77: l_frt_sum ap_invoices_all.invoice_amount%TYPE;

73: IS
74: l_item_sum ap_invoices_all.invoice_amount%TYPE;
75: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
76: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
77: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
78: l_retained_sum ap_invoices_all.invoice_amount%TYPE;
79: l_curr_calling_sequence VARCHAR2(2000);
80: l_debug_info VARCHAR2(500);
81: l_api_name VARCHAR2(50);

Line 78: l_retained_sum ap_invoices_all.invoice_amount%TYPE;

74: l_item_sum ap_invoices_all.invoice_amount%TYPE;
75: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
76: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
77: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
78: l_retained_sum ap_invoices_all.invoice_amount%TYPE;
79: l_curr_calling_sequence VARCHAR2(2000);
80: l_debug_info VARCHAR2(500);
81: l_api_name VARCHAR2(50);
82: l_hold_count NUMBER;

Line 86: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;

82: l_hold_count NUMBER;
83: l_line_count NUMBER;
84: l_line_total NUMBER;
85: l_Sched_Hold_count NUMBER;
86: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;
87: l_invoice_date ap_invoices_all.invoice_date%TYPE;
88:
89:
90: BEGIN

Line 87: l_invoice_date ap_invoices_all.invoice_date%TYPE;

83: l_line_count NUMBER;
84: l_line_total NUMBER;
85: l_Sched_Hold_count NUMBER;
86: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;
87: l_invoice_date ap_invoices_all.invoice_date%TYPE;
88:
89:
90: BEGIN
91: -- Update the calling sequence

Line 126: update ap_invoices_all

122: END IF;
123: END;
124:
125:
126: update ap_invoices_all
127: set invoice_amount = l_item_sum + l_tax_sum + l_misc_sum + l_frt_sum + l_retained_sum,
128: amount_applicable_to_discount = l_item_sum + l_tax_sum + l_misc_sum + l_frt_sum + l_retained_sum,
129: net_of_retainage_flag = DECODE(l_retained_sum, 0, 'N', 'Y')
130: where invoice_id = p_invoice_id;

Line 996: from ap_invoices_all

992: cursor invoice is
993: select gl_date,
994: last_updated_by,
995: last_update_login
996: from ap_invoices_all
997: where invoice_id = l_invoice_id
998: and org_id = l_org_id;
999:
1000:

Line 1319: FROM ap_invoices_all

1315: END IF;
1316:
1317: SELECT invoice_amount
1318: INTO l_amount
1319: FROM ap_invoices_all
1320: WHERE invoice_id = l_invoice_id;
1321:
1322: l_debug_info := 'check AME if production rules should prevent approval';
1323: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1408: UPDATE AP_INVOICES_ALL

1404: G_MODULE_NAME||
1405: l_api_name,l_debug_info);
1406: END IF;
1407:
1408: UPDATE AP_INVOICES_ALL
1409: SET WFApproval_Status = 'NOT REQUIRED'
1410: WHERE Invoice_Id = l_invoice_id
1411: AND WFApproval_Status = 'INITIATED';
1412:

Line 1483: UPDATE AP_INVOICES_ALL

1479: END IF;
1480:
1481: insert_history_table(p_hist_rec => l_hist_rec);
1482:
1483: UPDATE AP_INVOICES_ALL
1484: SET WFApproval_Status = 'REJECTED'
1485: WHERE Invoice_Id = l_invoice_id
1486: AND WFApproval_Status = 'INITIATED';
1487:

Line 2236: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

2232:
2233: l_org_id NUMBER;
2234: l_role VARCHAR2(50);
2235: l_orig_id NUMBER;
2236: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
2237:
2238: CURSOR Group_Approvers IS
2239: SELECT distinct role_name
2240: FROM ap_apinv_approvers

Line 2399: FROM ap_invoices_all

2395: them as Rejected. */
2396:
2397: SELECT invoice_type_lookup_code
2398: INTO l_invoice_type_lookup_code
2399: FROM ap_invoices_all
2400: WHERE invoice_id = l_invoice_id;
2401:
2402: UPDATE AP_INVOICE_LINES_ALL
2403: SET WFApproval_Status = DECODE(l_invoice_type_lookup_code

Line 2601: ap_invoices_all AI,

2597: AI.description,
2598: NVL(AI.invoice_amount, 0) invoice_amount,
2599: AI.invoice_currency_code
2600: FROM
2601: ap_invoices_all AI,
2602: po_vendors PV,
2603: po_vendor_sites_all PVS
2604: WHERE
2605: AI.invoice_id = l_invoice_id AND

Line 2619: ap_invoices_all AI,

2615: AI.description,
2616: NVL(AI.invoice_amount, 0) invoice_amount,
2617: AI.invoice_currency_code
2618: FROM
2619: ap_invoices_all AI,
2620: hz_parties HZP,
2621: hz_party_sites HZPS
2622: WHERE
2623: AI.invoice_id = l_invoice_id AND

Line 2852: l_amount ap_invoices_all.invoice_amount%TYPE;

2848: resultout OUT NOCOPY VARCHAR2 ) IS
2849: l_invoice_id NUMBER(15);
2850: l_iteration NUMBER(15);
2851: l_comments VARCHAR2(240);
2852: l_amount ap_invoices_all.invoice_amount%TYPE;
2853: l_status VARCHAR2(50);
2854: l_org_id NUMBER(15);
2855: l_user_id NUMBER(15);
2856: l_login_id NUMBER(15);

Line 2978: l_debug_info := 'Before UPDATE AP_INVOICES_ALL';

2974: l_api_name,l_debug_info);
2975: END IF;
2976:
2977: insert_history_table(p_hist_rec => l_hist_rec);
2978: l_debug_info := 'Before UPDATE AP_INVOICES_ALL';
2979: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2980: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2981: l_api_name,l_debug_info);
2982: END IF;

Line 2984: UPDATE AP_INVOICES_ALL

2980: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2981: l_api_name,l_debug_info);
2982: END IF;
2983:
2984: UPDATE AP_INVOICES_ALL
2985: SET wfapproval_status = 'REJECTED'
2986: WHERE invoice_id = l_invoice_id;
2987:
2988: l_debug_info := 'End';

Line 3009: l_amount ap_invoices_all.invoice_amount%TYPE;

3005: funcmode IN VARCHAR2,
3006: resultout OUT NOCOPY VARCHAR2 ) IS
3007: l_invoice_id NUMBER(15);
3008: l_comments VARCHAR2(240);
3009: l_amount ap_invoices_all.invoice_amount%TYPE;
3010: l_status VARCHAR2(50);
3011: l_org_id NUMBER(15);
3012: l_user_id NUMBER(15);
3013: l_login_id NUMBER(15);

Line 3757: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

3753: l_line_amount ap_invoice_lines_all.amount%TYPE;
3754: l_parent_key VARCHAR2(150);
3755: l_notf_iteration NUMBER;
3756: l_curr_calling_sequence VARCHAR2(2000);
3757: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
3758:
3759: BEGIN
3760:
3761: l_curr_calling_sequence

Line 3872: FROM AP_INVOICES_ALL

3868: l_api_name,l_debug_info);
3869: END IF;
3870: SELECT invoice_type_lookup_code
3871: INTO l_invoice_type_lookup_code
3872: FROM AP_INVOICES_ALL
3873: WHERE invoice_id = l_invoice_id;
3874: IF l_invoice_type_lookup_code IN ('INVOICE REQUEST'
3875: ,'CREDIT MEMO REQUEST') THEN
3876: recreate_pay_scheds(l_invoice_id,l_curr_calling_sequence);

Line 3934: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

3930: l_line_amount ap_invoice_lines_all.amount%TYPE;
3931: l_parent_key VARCHAR2(150);
3932: l_notf_iteration NUMBER;
3933: l_curr_calling_sequence VARCHAR2(2000);
3934: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
3935:
3936: BEGIN
3937: l_debug_info := 'Start';
3938: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4026: FROM AP_INVOICES_ALL

4022: l_api_name,l_debug_info);
4023: END IF;
4024: SELECT invoice_type_lookup_code
4025: INTO l_invoice_type_lookup_code
4026: FROM AP_INVOICES_ALL
4027: WHERE invoice_id = l_invoice_id;
4028: IF l_invoice_type_lookup_code IN ('INVOICE REQUEST'
4029: ,'CREDIT MEMO REQUEST') THEN
4030: recreate_pay_scheds(l_invoice_id,l_curr_calling_sequence);

Line 4115: from ap_invoices_all

4111: cursor invoice is
4112: select gl_date,
4113: last_updated_by,
4114: last_update_login
4115: from ap_invoices_all
4116: where invoice_id = l_invoice_id
4117: and org_id = l_org_id;
4118: BEGIN
4119:

Line 4297: ap_invoices_all AI,

4293: nvl(p_ext_contact_id, AI.vendor_contact_id),
4294: NVL(AI.invoice_amount, 0),
4295: ahc.hold_instruction
4296: FROM ap_holds_all ah,
4297: ap_invoices_all AI,
4298: po_vendors PV,
4299: ap_hold_codes ahc
4300: WHERE ah.hold_id = p_hold_id
4301: AND AI.invoice_id = ah.invoice_id

Line 4305: l_invoice_num ap_invoices_all.invoice_num%TYPE;

4301: AND AI.invoice_id = ah.invoice_id
4302: AND AI.vendor_id = PV.vendor_id
4303: AND AH.hold_lookup_code = AHC.hold_lookup_code;
4304: l_vendor_name po_vendors.vendor_name%TYPE;
4305: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4306: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4307: l_invoice_description ap_invoices_all.description%TYPE;
4308: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4309: l_org_id ap_invoices_all.org_id%TYPE;

Line 4306: l_invoice_date ap_invoices_all.invoice_date%TYPE;

4302: AND AI.vendor_id = PV.vendor_id
4303: AND AH.hold_lookup_code = AHC.hold_lookup_code;
4304: l_vendor_name po_vendors.vendor_name%TYPE;
4305: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4306: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4307: l_invoice_description ap_invoices_all.description%TYPE;
4308: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4309: l_org_id ap_invoices_all.org_id%TYPE;
4310: l_name VARCHAR2(30);

Line 4307: l_invoice_description ap_invoices_all.description%TYPE;

4303: AND AH.hold_lookup_code = AHC.hold_lookup_code;
4304: l_vendor_name po_vendors.vendor_name%TYPE;
4305: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4306: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4307: l_invoice_description ap_invoices_all.description%TYPE;
4308: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4309: l_org_id ap_invoices_all.org_id%TYPE;
4310: l_name VARCHAR2(30);
4311: l_display_name VARCHAR2(150);

Line 4308: l_invoice_id ap_invoices_all.invoice_id%TYPE;

4304: l_vendor_name po_vendors.vendor_name%TYPE;
4305: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4306: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4307: l_invoice_description ap_invoices_all.description%TYPE;
4308: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4309: l_org_id ap_invoices_all.org_id%TYPE;
4310: l_name VARCHAR2(30);
4311: l_display_name VARCHAR2(150);
4312: l_role VARCHAR2(50);

Line 4309: l_org_id ap_invoices_all.org_id%TYPE;

4305: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4306: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4307: l_invoice_description ap_invoices_all.description%TYPE;
4308: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4309: l_org_id ap_invoices_all.org_id%TYPE;
4310: l_name VARCHAR2(30);
4311: l_display_name VARCHAR2(150);
4312: l_role VARCHAR2(50);
4313: l_role_display VARCHAR2(150);

Line 4323: l_total ap_invoices_all.invoice_amount%TYPE;

4319: l_notf_iteration NUMBER;
4320: l_ext_person_id NUMBER(15);
4321: l_ext_user_id NUMBER(15);
4322: l_hold_instr ap_hold_codes.hold_instruction%TYPE;
4323: l_total ap_invoices_all.invoice_amount%TYPE;
4324: BEGIN
4325: l_notf_iteration := 1; /* For Now Hold Approval has only one round of
4326: Approvers */
4327: SELECT AP_NEGOTIATION_HIST_S.nextval

Line 4567: ap_invoices_all AI,

4563: alk.displayed_field,
4564: NVL(AI.invoice_amount, 0),
4565: ahc.hold_instruction
4566: FROM ap_holds_all ah,
4567: ap_invoices_all AI,
4568: po_vendors PV,
4569: ap_lookup_codes alk,
4570: ap_hold_codes ahc
4571: WHERE ah.hold_id = p_hold_id

Line 4577: l_invoice_num ap_invoices_all.invoice_num%TYPE;

4573: AND AI.invoice_id = ah.invoice_id
4574: AND AI.vendor_id = PV.vendor_id
4575: AND AH.hold_lookup_code = AHC.hold_lookup_code;
4576: l_vendor_name po_vendors.vendor_name%TYPE;
4577: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4578: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4579: l_invoice_description ap_invoices_all.description%TYPE;
4580: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4581: l_hold_type ap_lookup_codes.displayed_field%TYPE;

Line 4578: l_invoice_date ap_invoices_all.invoice_date%TYPE;

4574: AND AI.vendor_id = PV.vendor_id
4575: AND AH.hold_lookup_code = AHC.hold_lookup_code;
4576: l_vendor_name po_vendors.vendor_name%TYPE;
4577: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4578: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4579: l_invoice_description ap_invoices_all.description%TYPE;
4580: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4581: l_hold_type ap_lookup_codes.displayed_field%TYPE;
4582: l_org_id ap_invoices_all.org_id%TYPE;

Line 4579: l_invoice_description ap_invoices_all.description%TYPE;

4575: AND AH.hold_lookup_code = AHC.hold_lookup_code;
4576: l_vendor_name po_vendors.vendor_name%TYPE;
4577: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4578: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4579: l_invoice_description ap_invoices_all.description%TYPE;
4580: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4581: l_hold_type ap_lookup_codes.displayed_field%TYPE;
4582: l_org_id ap_invoices_all.org_id%TYPE;
4583: l_itemkey VARCHAR2(50);

Line 4580: l_invoice_id ap_invoices_all.invoice_id%TYPE;

4576: l_vendor_name po_vendors.vendor_name%TYPE;
4577: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4578: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4579: l_invoice_description ap_invoices_all.description%TYPE;
4580: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4581: l_hold_type ap_lookup_codes.displayed_field%TYPE;
4582: l_org_id ap_invoices_all.org_id%TYPE;
4583: l_itemkey VARCHAR2(50);
4584: l_hold_instr ap_hold_codes.hold_instruction%TYPE;

Line 4582: l_org_id ap_invoices_all.org_id%TYPE;

4578: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4579: l_invoice_description ap_invoices_all.description%TYPE;
4580: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4581: l_hold_type ap_lookup_codes.displayed_field%TYPE;
4582: l_org_id ap_invoices_all.org_id%TYPE;
4583: l_itemkey VARCHAR2(50);
4584: l_hold_instr ap_hold_codes.hold_instruction%TYPE;
4585: l_total ap_invoices_all.invoice_amount%TYPE;
4586:

Line 4585: l_total ap_invoices_all.invoice_amount%TYPE;

4581: l_hold_type ap_lookup_codes.displayed_field%TYPE;
4582: l_org_id ap_invoices_all.org_id%TYPE;
4583: l_itemkey VARCHAR2(50);
4584: l_hold_instr ap_hold_codes.hold_instruction%TYPE;
4585: l_total ap_invoices_all.invoice_amount%TYPE;
4586:
4587: BEGIN
4588: /* For the main process itemkey has to be hold_id */
4589: l_itemkey := p_hold_id;

Line 4691: Cursor C_invoice (p_invoice_id IN ap_invoices_all.invoice_id%TYPE) IS

4687: l_ids ame_util.stringList;
4688: l_class ame_util.stringList;
4689: l_source ame_util.longStringList;
4690: l_ampersand varchar2(1);
4691: Cursor C_invoice (p_invoice_id IN ap_invoices_all.invoice_id%TYPE) IS
4692: SELECT invoice_type_lookup_code
4693: ,gl_date
4694: ,ap_utilities_pkg.get_gl_period_name(gl_date
4695: ,org_id)

Line 4696: FROM ap_invoices_all

4692: SELECT invoice_type_lookup_code
4693: ,gl_date
4694: ,ap_utilities_pkg.get_gl_period_name(gl_date
4695: ,org_id)
4696: FROM ap_invoices_all
4697: WHERE invoice_id = p_invoice_id;
4698: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
4699: l_gl_date ap_invoices_all.gl_date%TYPE;
4700: l_new_gl_date ap_invoices_all.gl_date%TYPE;

Line 4698: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

4694: ,ap_utilities_pkg.get_gl_period_name(gl_date
4695: ,org_id)
4696: FROM ap_invoices_all
4697: WHERE invoice_id = p_invoice_id;
4698: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
4699: l_gl_date ap_invoices_all.gl_date%TYPE;
4700: l_new_gl_date ap_invoices_all.gl_date%TYPE;
4701: l_period_name ap_invoice_lines_all.period_name%TYPE;
4702: l_new_period_name ap_invoice_lines_all.period_name%TYPE;

Line 4699: l_gl_date ap_invoices_all.gl_date%TYPE;

4695: ,org_id)
4696: FROM ap_invoices_all
4697: WHERE invoice_id = p_invoice_id;
4698: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
4699: l_gl_date ap_invoices_all.gl_date%TYPE;
4700: l_new_gl_date ap_invoices_all.gl_date%TYPE;
4701: l_period_name ap_invoice_lines_all.period_name%TYPE;
4702: l_new_period_name ap_invoice_lines_all.period_name%TYPE;
4703: l_terms_id ap_invoices_all.terms_id%TYPE;

Line 4700: l_new_gl_date ap_invoices_all.gl_date%TYPE;

4696: FROM ap_invoices_all
4697: WHERE invoice_id = p_invoice_id;
4698: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
4699: l_gl_date ap_invoices_all.gl_date%TYPE;
4700: l_new_gl_date ap_invoices_all.gl_date%TYPE;
4701: l_period_name ap_invoice_lines_all.period_name%TYPE;
4702: l_new_period_name ap_invoice_lines_all.period_name%TYPE;
4703: l_terms_id ap_invoices_all.terms_id%TYPE;
4704: l_terms_date ap_invoices_all.terms_date%TYPE;

Line 4703: l_terms_id ap_invoices_all.terms_id%TYPE;

4699: l_gl_date ap_invoices_all.gl_date%TYPE;
4700: l_new_gl_date ap_invoices_all.gl_date%TYPE;
4701: l_period_name ap_invoice_lines_all.period_name%TYPE;
4702: l_new_period_name ap_invoice_lines_all.period_name%TYPE;
4703: l_terms_id ap_invoices_all.terms_id%TYPE;
4704: l_terms_date ap_invoices_all.terms_date%TYPE;
4705: l_count_rejects number;
4706: l_inv_match_type VARCHAR2(80);
4707:

Line 4704: l_terms_date ap_invoices_all.terms_date%TYPE;

4700: l_new_gl_date ap_invoices_all.gl_date%TYPE;
4701: l_period_name ap_invoice_lines_all.period_name%TYPE;
4702: l_new_period_name ap_invoice_lines_all.period_name%TYPE;
4703: l_terms_id ap_invoices_all.terms_id%TYPE;
4704: l_terms_date ap_invoices_all.terms_date%TYPE;
4705: l_count_rejects number;
4706: l_inv_match_type VARCHAR2(80);
4707:
4708: BEGIN

Line 4782: UPDATE AP_INVOICES_ALL

4778: AND history_type = 'DOCUMENTAPPROVAL';
4779:
4780: IF l_count >0 THEN
4781: --update invoice header status
4782: UPDATE AP_INVOICES_ALL
4783: SET wfapproval_status = 'WFAPPROVED'
4784: WHERE invoice_id = l_invoice_id
4785: AND wfapproval_status <> 'MANUALLY APPROVED';
4786: ELSE

Line 4787: UPDATE AP_INVOICES_ALL

4783: SET wfapproval_status = 'WFAPPROVED'
4784: WHERE invoice_id = l_invoice_id
4785: AND wfapproval_status <> 'MANUALLY APPROVED';
4786: ELSE
4787: UPDATE AP_INVOICES_ALL
4788: SET wfapproval_status = decode(invoice_type_lookup_code,
4789: 'INVOICE REQUEST','REJECTED',
4790: 'CREDIT MEMO REQUEST','REJECTED',
4791: 'NOT REQUIRED')

Line 4827: UPDATE AP_INVOICES_ALL

4823: p_calling_sequence =>
4824: 'ap_workflow_pkg.get_header_approver');
4825:
4826:
4827: UPDATE AP_INVOICES_ALL
4828: SET invoice_type_lookup_code =
4829: DECODE(invoice_type_lookup_code
4830: ,'INVOICE REQUEST','STANDARD'
4831: ,'CREDIT MEMO REQUEST', 'CREDIT'

Line 4838: UPDATE AP_INVOICES_ALL

4834: terms_date = l_terms_date
4835: WHERE invoice_id = l_invoice_id;
4836: IF l_period_name <> l_new_period_name THEN
4837:
4838: UPDATE AP_INVOICES_ALL
4839: SET gl_date = l_new_gl_date
4840: WHERE invoice_id = l_invoice_id;
4841:
4842: UPDATE ap_invoice_lines_all

Line 4931: UPDATE ap_invoices_all

4927: SET wfapproval_status = 'REQUIRED'
4928: WHERE invoice_id = l_invoice_id
4929: AND wfapproval_status = 'INITIATED';
4930:
4931: UPDATE ap_invoices_all
4932: SET wfapproval_status = 'NEEDS WFREAPPROVAL'
4933: WHERE invoice_id = l_invoice_id;
4934:
4935: resultout := wf_engine.eng_completed||':'||'FINISH';

Line 5381: FROM ap_invoices_all AI,

5377: AI.invoice_id,
5378: AI.approval_iteration,
5379: AI.vendor_contact_id,
5380: NVL(AI.invoice_amount, 0)
5381: FROM ap_invoices_all AI,
5382: po_vendors PV
5383: WHERE AI.invoice_id = p_invoice_id
5384: AND AI.vendor_id = PV.vendor_id;
5385: l_api_name CONSTANT VARCHAR2(200) := 'create_lineapproval_neg_process';

Line 5387: l_invoice_num ap_invoices_all.invoice_num%TYPE;

5383: WHERE AI.invoice_id = p_invoice_id
5384: AND AI.vendor_id = PV.vendor_id;
5385: l_api_name CONSTANT VARCHAR2(200) := 'create_lineapproval_neg_process';
5386: l_vendor_name po_vendors.vendor_name%TYPE;
5387: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5388: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5389: l_invoice_description ap_invoices_all.description%TYPE;
5390: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5391: l_org_id ap_invoices_all.org_id%TYPE;

Line 5388: l_invoice_date ap_invoices_all.invoice_date%TYPE;

5384: AND AI.vendor_id = PV.vendor_id;
5385: l_api_name CONSTANT VARCHAR2(200) := 'create_lineapproval_neg_process';
5386: l_vendor_name po_vendors.vendor_name%TYPE;
5387: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5388: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5389: l_invoice_description ap_invoices_all.description%TYPE;
5390: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5391: l_org_id ap_invoices_all.org_id%TYPE;
5392: l_name VARCHAR2(30);

Line 5389: l_invoice_description ap_invoices_all.description%TYPE;

5385: l_api_name CONSTANT VARCHAR2(200) := 'create_lineapproval_neg_process';
5386: l_vendor_name po_vendors.vendor_name%TYPE;
5387: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5388: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5389: l_invoice_description ap_invoices_all.description%TYPE;
5390: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5391: l_org_id ap_invoices_all.org_id%TYPE;
5392: l_name VARCHAR2(30);
5393: l_display_name VARCHAR2(150);

Line 5390: l_invoice_id ap_invoices_all.invoice_id%TYPE;

5386: l_vendor_name po_vendors.vendor_name%TYPE;
5387: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5388: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5389: l_invoice_description ap_invoices_all.description%TYPE;
5390: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5391: l_org_id ap_invoices_all.org_id%TYPE;
5392: l_name VARCHAR2(30);
5393: l_display_name VARCHAR2(150);
5394: l_role VARCHAR2(50);

Line 5391: l_org_id ap_invoices_all.org_id%TYPE;

5387: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5388: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5389: l_invoice_description ap_invoices_all.description%TYPE;
5390: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5391: l_org_id ap_invoices_all.org_id%TYPE;
5392: l_name VARCHAR2(30);
5393: l_display_name VARCHAR2(150);
5394: l_role VARCHAR2(50);
5395: l_role_display VARCHAR2(150);

Line 5411: l_total ap_invoices_all.invoice_amount%TYPE;

5407: l_line_number ap_invoice_lines_all.line_number%TYPE;
5408: l_line_amount ap_invoice_lines_all.amount%TYPE;
5409: l_ext_person_id NUMBER(15);
5410: l_ext_user_id NUMBER(15);
5411: l_total ap_invoices_all.invoice_amount%TYPE;
5412:
5413: BEGIN
5414: l_debug_info := 'Start';
5415: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 5638: FROM ap_invoices_all AI,

5634: AI.description,
5635: AI.org_id,
5636: AI.invoice_id,
5637: NVL(AI.invoice_amount, 0)
5638: FROM ap_invoices_all AI,
5639: ap_suppliers PV
5640: WHERE AI.invoice_id = p_invoice_id
5641: AND AI.invoice_type_lookup_code <> 'PAYMENT REQUEST'
5642: AND AI.vendor_id = PV.vendor_id

Line 5651: FROM ap_invoices_all AI,

5647: AI.description,
5648: AI.org_id,
5649: AI.invoice_id,
5650: NVL(AI.invoice_amount, 0)
5651: FROM ap_invoices_all AI,
5652: hz_parties HZP
5653: WHERE AI.invoice_id = p_invoice_id
5654: AND AI.invoice_type_lookup_code = 'PAYMENT REQUEST'
5655: AND AI.party_id = HZP.party_id;

Line 5658: l_invoice_num ap_invoices_all.invoice_num%TYPE;

5654: AND AI.invoice_type_lookup_code = 'PAYMENT REQUEST'
5655: AND AI.party_id = HZP.party_id;
5656:
5657: l_vendor_name po_vendors.vendor_name%TYPE;
5658: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5659: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5660: l_invoice_description ap_invoices_all.description%TYPE;
5661: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5662: l_org_id ap_invoices_all.org_id%TYPE;

Line 5659: l_invoice_date ap_invoices_all.invoice_date%TYPE;

5655: AND AI.party_id = HZP.party_id;
5656:
5657: l_vendor_name po_vendors.vendor_name%TYPE;
5658: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5659: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5660: l_invoice_description ap_invoices_all.description%TYPE;
5661: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5662: l_org_id ap_invoices_all.org_id%TYPE;
5663: l_itemkey VARCHAR2(50);

Line 5660: l_invoice_description ap_invoices_all.description%TYPE;

5656:
5657: l_vendor_name po_vendors.vendor_name%TYPE;
5658: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5659: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5660: l_invoice_description ap_invoices_all.description%TYPE;
5661: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5662: l_org_id ap_invoices_all.org_id%TYPE;
5663: l_itemkey VARCHAR2(50);
5664: l_iteration AP_INVOICES_ALL.APPROVAL_ITERATION%TYPE;

Line 5661: l_invoice_id ap_invoices_all.invoice_id%TYPE;

5657: l_vendor_name po_vendors.vendor_name%TYPE;
5658: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5659: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5660: l_invoice_description ap_invoices_all.description%TYPE;
5661: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5662: l_org_id ap_invoices_all.org_id%TYPE;
5663: l_itemkey VARCHAR2(50);
5664: l_iteration AP_INVOICES_ALL.APPROVAL_ITERATION%TYPE;
5665: l_api_name CONSTANT VARCHAR2(200) := 'create_invapp_process';

Line 5662: l_org_id ap_invoices_all.org_id%TYPE;

5658: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5659: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5660: l_invoice_description ap_invoices_all.description%TYPE;
5661: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5662: l_org_id ap_invoices_all.org_id%TYPE;
5663: l_itemkey VARCHAR2(50);
5664: l_iteration AP_INVOICES_ALL.APPROVAL_ITERATION%TYPE;
5665: l_api_name CONSTANT VARCHAR2(200) := 'create_invapp_process';
5666: l_debug_info VARCHAR2(2000);

Line 5664: l_iteration AP_INVOICES_ALL.APPROVAL_ITERATION%TYPE;

5660: l_invoice_description ap_invoices_all.description%TYPE;
5661: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5662: l_org_id ap_invoices_all.org_id%TYPE;
5663: l_itemkey VARCHAR2(50);
5664: l_iteration AP_INVOICES_ALL.APPROVAL_ITERATION%TYPE;
5665: l_api_name CONSTANT VARCHAR2(200) := 'create_invapp_process';
5666: l_debug_info VARCHAR2(2000);
5667: l_total ap_invoices_all.invoice_amount%TYPE;
5668: l_calling_sequence VARCHAR2(2000);

Line 5667: l_total ap_invoices_all.invoice_amount%TYPE;

5663: l_itemkey VARCHAR2(50);
5664: l_iteration AP_INVOICES_ALL.APPROVAL_ITERATION%TYPE;
5665: l_api_name CONSTANT VARCHAR2(200) := 'create_invapp_process';
5666: l_debug_info VARCHAR2(2000);
5667: l_total ap_invoices_all.invoice_amount%TYPE;
5668: l_calling_sequence VARCHAR2(2000);
5669: l_num NUMBER;
5670:
5671:

Line 5679: l_debug_info := 'Before UPDATE AP_INVOICES_ALL';

5675: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5676: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5677: l_api_name,l_debug_info);
5678: END IF;
5679: l_debug_info := 'Before UPDATE AP_INVOICES_ALL';
5680: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5681: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5682: l_api_name,l_debug_info);
5683: END IF;

Line 5685: UPDATE AP_INVOICES_ALL

5681: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5682: l_api_name,l_debug_info);
5683: END IF;
5684: l_calling_sequence := l_api_name;
5685: UPDATE AP_INVOICES_ALL
5686: SET WFAPPROVAL_STATUS = 'INITIATED'
5687: WHERE invoice_id = p_invoice_id;
5688: /*
5689: UPDATE AP_INVOICE_LINES_ALL

Line 6287: FROM ap_invoices_all

6283: SELECT organization
6284: INTO l_return_val
6285: FROM PA_EXP_ORGS_IT
6286: WHERE organization_id=(SELECT expenditure_organization_id
6287: FROM ap_invoices_all
6288: WHERE invoice_id = p_invoice_id);
6289:
6290: ELSIF p_attribute_name= 'SUPPLIER_INVOICE_PROJECT_RELATED' THEN
6291:

Line 6783: FROM ap_invoices_all

6779: l_invoice_id := p_invoice_id;
6780: BEGIN
6781: SELECT NVL(wfapproval_status, 'NOT REQUIRED')
6782: INTO l_wfapproval_status
6783: FROM ap_invoices_all
6784: WHERE invoice_id = l_invoice_id;
6785: END;
6786:
6787:

Line 7115: UPDATE ap_invoices_all

7111: ,'REJECTED','NEEDS WFREAPPROVAL'
7112: ,'STOPPED');
7113:
7114: --Set the header status
7115: UPDATE ap_invoices_all
7116: SET wfapproval_status = 'NOT REQUIRED'
7117: WHERE wfapproval_status in ('INITIATED','REQUIRED'
7118: ,'REJECTED','NEEDS WFREAPPROVAL'
7119: ,'STOPPED');

Line 7473: l_invoice_id ap_invoices_all.invoice_id%TYPE;

7469: itemkey IN VARCHAR2,
7470: actid IN NUMBER,
7471: funcmode IN VARCHAR2,
7472: resultout OUT NOCOPY VARCHAR2 ) IS
7473: l_invoice_id ap_invoices_all.invoice_id%TYPE;
7474: l_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
7475: l_debug_info VARCHAR2(2000);
7476: l_api_name CONSTANT VARCHAR2(200) := 'is_payment_request';
7477: BEGIN

Line 7474: l_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;

7470: actid IN NUMBER,
7471: funcmode IN VARCHAR2,
7472: resultout OUT NOCOPY VARCHAR2 ) IS
7473: l_invoice_id ap_invoices_all.invoice_id%TYPE;
7474: l_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
7475: l_debug_info VARCHAR2(2000);
7476: l_api_name CONSTANT VARCHAR2(200) := 'is_payment_request';
7477: BEGIN
7478: l_invoice_id := WF_ENGINE.GETITEMATTRNumber

Line 7484: FROM ap_invoices_all ai

7480: itemkey,
7481: 'INVOICE_ID');
7482: SELECT ai.invoice_type_lookup_code
7483: INTO l_inv_type
7484: FROM ap_invoices_all ai
7485: WHERE invoice_id = l_invoice_id;
7486:
7487: IF l_inv_type = 'PAYMENT REQUEST' THEN
7488: resultout := wf_engine.eng_completed||':'||'Y';

Line 7538: l_amount ap_invoices_all.invoice_amount%TYPE;

7534: l_esc_approver AME_UTIL.approverRecord;
7535: l_rec_role VARCHAR2(50);
7536: l_comments VARCHAR2(240);
7537: l_hist_id NUMBER(15);
7538: l_amount ap_invoices_all.invoice_amount%TYPE;
7539: l_user_id NUMBER(15);
7540: l_login_id NUMBER(15);
7541: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
7542: l_notf_iteration NUMBER;

Line 7901: l_amount ap_invoices_all.invoice_amount%TYPE;

7897: l_esc_approver AME_UTIL.approverRecord;
7898: l_rec_role VARCHAR2(50);
7899: l_comments VARCHAR2(240);
7900: l_hist_id NUMBER(15);
7901: l_amount ap_invoices_all.invoice_amount%TYPE;
7902: l_user_id NUMBER(15);
7903: l_login_id NUMBER(15);
7904: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
7905: l_notf_iteration NUMBER;