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 77: l_item_sum ap_invoices_all.invoice_amount%TYPE;

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

Line 78: l_tax_sum ap_invoices_all.invoice_amount%TYPE;

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

Line 79: l_misc_sum ap_invoices_all.invoice_amount%TYPE;

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

Line 80: l_frt_sum ap_invoices_all.invoice_amount%TYPE;

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

Line 81: l_retained_sum ap_invoices_all.invoice_amount%TYPE;

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

Line 89: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;

85: l_hold_count NUMBER;
86: l_line_count NUMBER;
87: l_line_total NUMBER;
88: l_Sched_Hold_count NUMBER;
89: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;
90: l_invoice_date ap_invoices_all.invoice_date%TYPE;
91:
92:
93: BEGIN

Line 90: l_invoice_date ap_invoices_all.invoice_date%TYPE;

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

Line 129: update ap_invoices_all

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

Line 1028: from ap_invoices_all

1024: cursor invoice is
1025: select gl_date,
1026: last_updated_by,
1027: last_update_login
1028: from ap_invoices_all
1029: where invoice_id = l_invoice_id
1030: and org_id = l_org_id;
1031:
1032:

Line 1351: FROM ap_invoices_all

1347: END IF;
1348:
1349: SELECT invoice_amount
1350: INTO l_amount
1351: FROM ap_invoices_all
1352: WHERE invoice_id = l_invoice_id;
1353:
1354: l_debug_info := 'check AME if production rules should prevent approval';
1355: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1440: UPDATE AP_INVOICES_ALL

1436: G_MODULE_NAME||
1437: l_api_name,l_debug_info);
1438: END IF;
1439:
1440: UPDATE AP_INVOICES_ALL
1441: SET WFApproval_Status = 'NOT REQUIRED'
1442: WHERE Invoice_Id = l_invoice_id
1443: AND WFApproval_Status = 'INITIATED';
1444:

Line 1515: UPDATE AP_INVOICES_ALL

1511: END IF;
1512:
1513: insert_history_table(p_hist_rec => l_hist_rec);
1514:
1515: UPDATE AP_INVOICES_ALL
1516: SET WFApproval_Status = 'REJECTED'
1517: WHERE Invoice_Id = l_invoice_id
1518: AND WFApproval_Status = 'INITIATED';
1519:

Line 2334: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

2330:
2331: l_org_id NUMBER;
2332: l_role VARCHAR2(50);
2333: l_orig_id NUMBER;
2334: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
2335:
2336: CURSOR Group_Approvers IS
2337: SELECT distinct role_name
2338: FROM ap_apinv_approvers

Line 2497: FROM ap_invoices_all

2493: them as Rejected. */
2494:
2495: SELECT invoice_type_lookup_code
2496: INTO l_invoice_type_lookup_code
2497: FROM ap_invoices_all
2498: WHERE invoice_id = l_invoice_id;
2499:
2500: UPDATE AP_INVOICE_LINES_ALL
2501: SET WFApproval_Status = DECODE(l_invoice_type_lookup_code

Line 2699: ap_invoices_all AI,

2695: AI.description,
2696: NVL(AI.invoice_amount, 0) invoice_amount,
2697: AI.invoice_currency_code
2698: FROM
2699: ap_invoices_all AI,
2700: po_vendors PV,
2701: po_vendor_sites_all PVS
2702: WHERE
2703: AI.invoice_id = l_invoice_id AND

Line 2717: ap_invoices_all AI,

2713: AI.description,
2714: NVL(AI.invoice_amount, 0) invoice_amount,
2715: AI.invoice_currency_code
2716: FROM
2717: ap_invoices_all AI,
2718: hz_parties HZP,
2719: hz_party_sites HZPS
2720: WHERE
2721: AI.invoice_id = l_invoice_id AND

Line 2951: l_amount ap_invoices_all.invoice_amount%TYPE;

2947: resultout OUT NOCOPY VARCHAR2 ) IS
2948: l_invoice_id NUMBER(15);
2949: l_iteration NUMBER(15);
2950: l_comments VARCHAR2(240);
2951: l_amount ap_invoices_all.invoice_amount%TYPE;
2952: l_status VARCHAR2(50);
2953: l_org_id NUMBER(15);
2954: l_user_id NUMBER(15);
2955: l_login_id NUMBER(15);

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

3073: l_api_name,l_debug_info);
3074: END IF;
3075:
3076: insert_history_table(p_hist_rec => l_hist_rec);
3077: l_debug_info := 'Before UPDATE AP_INVOICES_ALL';
3078: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3079: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3080: l_api_name,l_debug_info);
3081: END IF;

Line 3083: UPDATE AP_INVOICES_ALL

3079: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3080: l_api_name,l_debug_info);
3081: END IF;
3082:
3083: UPDATE AP_INVOICES_ALL
3084: SET wfapproval_status = 'REJECTED'
3085: WHERE invoice_id = l_invoice_id;
3086:
3087: l_debug_info := 'End';

Line 3108: l_amount ap_invoices_all.invoice_amount%TYPE;

3104: funcmode IN VARCHAR2,
3105: resultout OUT NOCOPY VARCHAR2 ) IS
3106: l_invoice_id NUMBER(15);
3107: l_comments VARCHAR2(240);
3108: l_amount ap_invoices_all.invoice_amount%TYPE;
3109: l_status VARCHAR2(50);
3110: l_org_id NUMBER(15);
3111: l_user_id NUMBER(15);
3112: l_login_id NUMBER(15);

Line 3884: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

3880: l_line_amount ap_invoice_lines_all.amount%TYPE;
3881: l_parent_key VARCHAR2(150);
3882: l_notf_iteration NUMBER;
3883: l_curr_calling_sequence VARCHAR2(2000);
3884: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
3885:
3886: BEGIN
3887:
3888: l_curr_calling_sequence

Line 3999: FROM AP_INVOICES_ALL

3995: l_api_name,l_debug_info);
3996: END IF;
3997: SELECT invoice_type_lookup_code
3998: INTO l_invoice_type_lookup_code
3999: FROM AP_INVOICES_ALL
4000: WHERE invoice_id = l_invoice_id;
4001: IF l_invoice_type_lookup_code IN ('INVOICE REQUEST'
4002: ,'CREDIT MEMO REQUEST') THEN
4003: recreate_pay_scheds(l_invoice_id,l_curr_calling_sequence);

Line 4061: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

4057: l_line_amount ap_invoice_lines_all.amount%TYPE;
4058: l_parent_key VARCHAR2(150);
4059: l_notf_iteration NUMBER;
4060: l_curr_calling_sequence VARCHAR2(2000);
4061: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
4062:
4063: BEGIN
4064: l_debug_info := 'Start';
4065: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4153: FROM AP_INVOICES_ALL

4149: l_api_name,l_debug_info);
4150: END IF;
4151: SELECT invoice_type_lookup_code
4152: INTO l_invoice_type_lookup_code
4153: FROM AP_INVOICES_ALL
4154: WHERE invoice_id = l_invoice_id;
4155: IF l_invoice_type_lookup_code IN ('INVOICE REQUEST'
4156: ,'CREDIT MEMO REQUEST') THEN
4157: recreate_pay_scheds(l_invoice_id,l_curr_calling_sequence);

Line 4242: from ap_invoices_all

4238: cursor invoice is
4239: select gl_date,
4240: last_updated_by,
4241: last_update_login
4242: from ap_invoices_all
4243: where invoice_id = l_invoice_id
4244: and org_id = l_org_id;
4245: BEGIN
4246:

Line 4424: ap_invoices_all AI,

4420: nvl(p_ext_contact_id, AI.vendor_contact_id),
4421: NVL(AI.invoice_amount, 0),
4422: ahc.hold_instruction
4423: FROM ap_holds_all ah,
4424: ap_invoices_all AI,
4425: po_vendors PV,
4426: ap_hold_codes ahc
4427: WHERE ah.hold_id = p_hold_id
4428: AND AI.invoice_id = ah.invoice_id

Line 4432: l_invoice_num ap_invoices_all.invoice_num%TYPE;

4428: AND AI.invoice_id = ah.invoice_id
4429: AND AI.vendor_id = PV.vendor_id
4430: AND AH.hold_lookup_code = AHC.hold_lookup_code;
4431: l_vendor_name po_vendors.vendor_name%TYPE;
4432: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4433: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4434: l_invoice_description ap_invoices_all.description%TYPE;
4435: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4436: l_org_id ap_invoices_all.org_id%TYPE;

Line 4433: l_invoice_date ap_invoices_all.invoice_date%TYPE;

4429: AND AI.vendor_id = PV.vendor_id
4430: AND AH.hold_lookup_code = AHC.hold_lookup_code;
4431: l_vendor_name po_vendors.vendor_name%TYPE;
4432: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4433: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4434: l_invoice_description ap_invoices_all.description%TYPE;
4435: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4436: l_org_id ap_invoices_all.org_id%TYPE;
4437: l_name wf_users.name%TYPE; --bug 8620671

Line 4434: l_invoice_description ap_invoices_all.description%TYPE;

4430: AND AH.hold_lookup_code = AHC.hold_lookup_code;
4431: l_vendor_name po_vendors.vendor_name%TYPE;
4432: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4433: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4434: l_invoice_description ap_invoices_all.description%TYPE;
4435: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4436: l_org_id ap_invoices_all.org_id%TYPE;
4437: l_name wf_users.name%TYPE; --bug 8620671
4438: l_display_name VARCHAR2(150);

Line 4435: l_invoice_id ap_invoices_all.invoice_id%TYPE;

4431: l_vendor_name po_vendors.vendor_name%TYPE;
4432: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4433: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4434: l_invoice_description ap_invoices_all.description%TYPE;
4435: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4436: l_org_id ap_invoices_all.org_id%TYPE;
4437: l_name wf_users.name%TYPE; --bug 8620671
4438: l_display_name VARCHAR2(150);
4439: l_role VARCHAR2(50);

Line 4436: l_org_id ap_invoices_all.org_id%TYPE;

4432: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4433: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4434: l_invoice_description ap_invoices_all.description%TYPE;
4435: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4436: l_org_id ap_invoices_all.org_id%TYPE;
4437: l_name wf_users.name%TYPE; --bug 8620671
4438: l_display_name VARCHAR2(150);
4439: l_role VARCHAR2(50);
4440: l_role_display VARCHAR2(150);

Line 4450: l_total ap_invoices_all.invoice_amount%TYPE;

4446: l_notf_iteration NUMBER;
4447: l_ext_person_id NUMBER(15);
4448: l_ext_user_id NUMBER(15);
4449: l_hold_instr ap_hold_codes.hold_instruction%TYPE;
4450: l_total ap_invoices_all.invoice_amount%TYPE;
4451: BEGIN
4452: l_notf_iteration := 1; /* For Now Hold Approval has only one round of
4453: Approvers */
4454: SELECT AP_NEGOTIATION_HIST_S.nextval

Line 4699: ap_invoices_all AI,

4695: alk.displayed_field,
4696: NVL(AI.invoice_amount, 0),
4697: ahc.hold_instruction
4698: FROM ap_holds_all ah,
4699: ap_invoices_all AI,
4700: po_vendors PV,
4701: ap_lookup_codes alk,
4702: ap_hold_codes ahc
4703: WHERE ah.hold_id = p_hold_id

Line 4709: l_invoice_num ap_invoices_all.invoice_num%TYPE;

4705: AND AI.invoice_id = ah.invoice_id
4706: AND AI.vendor_id = PV.vendor_id
4707: AND AH.hold_lookup_code = AHC.hold_lookup_code;
4708: l_vendor_name po_vendors.vendor_name%TYPE;
4709: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4710: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4711: l_invoice_description ap_invoices_all.description%TYPE;
4712: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4713: l_hold_type ap_lookup_codes.displayed_field%TYPE;

Line 4710: l_invoice_date ap_invoices_all.invoice_date%TYPE;

4706: AND AI.vendor_id = PV.vendor_id
4707: AND AH.hold_lookup_code = AHC.hold_lookup_code;
4708: l_vendor_name po_vendors.vendor_name%TYPE;
4709: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4710: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4711: l_invoice_description ap_invoices_all.description%TYPE;
4712: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4713: l_hold_type ap_lookup_codes.displayed_field%TYPE;
4714: l_org_id ap_invoices_all.org_id%TYPE;

Line 4711: l_invoice_description ap_invoices_all.description%TYPE;

4707: AND AH.hold_lookup_code = AHC.hold_lookup_code;
4708: l_vendor_name po_vendors.vendor_name%TYPE;
4709: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4710: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4711: l_invoice_description ap_invoices_all.description%TYPE;
4712: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4713: l_hold_type ap_lookup_codes.displayed_field%TYPE;
4714: l_org_id ap_invoices_all.org_id%TYPE;
4715: l_itemkey VARCHAR2(50);

Line 4712: l_invoice_id ap_invoices_all.invoice_id%TYPE;

4708: l_vendor_name po_vendors.vendor_name%TYPE;
4709: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4710: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4711: l_invoice_description ap_invoices_all.description%TYPE;
4712: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4713: l_hold_type ap_lookup_codes.displayed_field%TYPE;
4714: l_org_id ap_invoices_all.org_id%TYPE;
4715: l_itemkey VARCHAR2(50);
4716: l_hold_instr ap_hold_codes.hold_instruction%TYPE;

Line 4714: l_org_id ap_invoices_all.org_id%TYPE;

4710: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4711: l_invoice_description ap_invoices_all.description%TYPE;
4712: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4713: l_hold_type ap_lookup_codes.displayed_field%TYPE;
4714: l_org_id ap_invoices_all.org_id%TYPE;
4715: l_itemkey VARCHAR2(50);
4716: l_hold_instr ap_hold_codes.hold_instruction%TYPE;
4717: l_total ap_invoices_all.invoice_amount%TYPE;
4718:

Line 4717: l_total ap_invoices_all.invoice_amount%TYPE;

4713: l_hold_type ap_lookup_codes.displayed_field%TYPE;
4714: l_org_id ap_invoices_all.org_id%TYPE;
4715: l_itemkey VARCHAR2(50);
4716: l_hold_instr ap_hold_codes.hold_instruction%TYPE;
4717: l_total ap_invoices_all.invoice_amount%TYPE;
4718:
4719: BEGIN
4720: /* For the main process itemkey has to be hold_id */
4721: l_itemkey := p_hold_id;

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

4822: l_ids ame_util.stringList;
4823: l_class ame_util.stringList;
4824: l_source ame_util.longStringList;
4825: l_ampersand varchar2(1);
4826: Cursor C_invoice (p_invoice_id IN ap_invoices_all.invoice_id%TYPE) IS
4827: SELECT invoice_type_lookup_code
4828: ,gl_date
4829: ,ap_utilities_pkg.get_gl_period_name(gl_date
4830: ,org_id)

Line 4831: FROM ap_invoices_all

4827: SELECT invoice_type_lookup_code
4828: ,gl_date
4829: ,ap_utilities_pkg.get_gl_period_name(gl_date
4830: ,org_id)
4831: FROM ap_invoices_all
4832: WHERE invoice_id = p_invoice_id;
4833: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
4834: l_gl_date ap_invoices_all.gl_date%TYPE;
4835: l_new_gl_date ap_invoices_all.gl_date%TYPE;

Line 4833: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

4829: ,ap_utilities_pkg.get_gl_period_name(gl_date
4830: ,org_id)
4831: FROM ap_invoices_all
4832: WHERE invoice_id = p_invoice_id;
4833: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
4834: l_gl_date ap_invoices_all.gl_date%TYPE;
4835: l_new_gl_date ap_invoices_all.gl_date%TYPE;
4836: l_period_name ap_invoice_lines_all.period_name%TYPE;
4837: l_new_period_name ap_invoice_lines_all.period_name%TYPE;

Line 4834: l_gl_date ap_invoices_all.gl_date%TYPE;

4830: ,org_id)
4831: FROM ap_invoices_all
4832: WHERE invoice_id = p_invoice_id;
4833: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
4834: l_gl_date ap_invoices_all.gl_date%TYPE;
4835: l_new_gl_date ap_invoices_all.gl_date%TYPE;
4836: l_period_name ap_invoice_lines_all.period_name%TYPE;
4837: l_new_period_name ap_invoice_lines_all.period_name%TYPE;
4838: l_terms_id ap_invoices_all.terms_id%TYPE;

Line 4835: l_new_gl_date ap_invoices_all.gl_date%TYPE;

4831: FROM ap_invoices_all
4832: WHERE invoice_id = p_invoice_id;
4833: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
4834: l_gl_date ap_invoices_all.gl_date%TYPE;
4835: l_new_gl_date ap_invoices_all.gl_date%TYPE;
4836: l_period_name ap_invoice_lines_all.period_name%TYPE;
4837: l_new_period_name ap_invoice_lines_all.period_name%TYPE;
4838: l_terms_id ap_invoices_all.terms_id%TYPE;
4839: l_terms_date ap_invoices_all.terms_date%TYPE;

Line 4838: l_terms_id ap_invoices_all.terms_id%TYPE;

4834: l_gl_date ap_invoices_all.gl_date%TYPE;
4835: l_new_gl_date ap_invoices_all.gl_date%TYPE;
4836: l_period_name ap_invoice_lines_all.period_name%TYPE;
4837: l_new_period_name ap_invoice_lines_all.period_name%TYPE;
4838: l_terms_id ap_invoices_all.terms_id%TYPE;
4839: l_terms_date ap_invoices_all.terms_date%TYPE;
4840: l_count_rejects number;
4841: l_inv_match_type VARCHAR2(80);
4842:

Line 4839: l_terms_date ap_invoices_all.terms_date%TYPE;

4835: l_new_gl_date ap_invoices_all.gl_date%TYPE;
4836: l_period_name ap_invoice_lines_all.period_name%TYPE;
4837: l_new_period_name ap_invoice_lines_all.period_name%TYPE;
4838: l_terms_id ap_invoices_all.terms_id%TYPE;
4839: l_terms_date ap_invoices_all.terms_date%TYPE;
4840: l_count_rejects number;
4841: l_inv_match_type VARCHAR2(80);
4842:
4843: BEGIN

Line 4917: UPDATE AP_INVOICES_ALL

4913: AND history_type = 'DOCUMENTAPPROVAL';
4914:
4915: IF l_count >0 THEN
4916: --update invoice header status
4917: UPDATE AP_INVOICES_ALL
4918: SET wfapproval_status = 'WFAPPROVED'
4919: WHERE invoice_id = l_invoice_id
4920: AND wfapproval_status <> 'MANUALLY APPROVED';
4921: ELSE

Line 4922: UPDATE AP_INVOICES_ALL

4918: SET wfapproval_status = 'WFAPPROVED'
4919: WHERE invoice_id = l_invoice_id
4920: AND wfapproval_status <> 'MANUALLY APPROVED';
4921: ELSE
4922: UPDATE AP_INVOICES_ALL
4923: SET wfapproval_status = decode(invoice_type_lookup_code,
4924: 'INVOICE REQUEST','REJECTED',
4925: 'CREDIT MEMO REQUEST','REJECTED',
4926: 'NOT REQUIRED')

Line 4962: UPDATE AP_INVOICES_ALL

4958: p_calling_sequence =>
4959: 'ap_workflow_pkg.get_header_approver');
4960:
4961:
4962: UPDATE AP_INVOICES_ALL
4963: SET invoice_type_lookup_code =
4964: DECODE(invoice_type_lookup_code
4965: ,'INVOICE REQUEST','STANDARD'
4966: ,'CREDIT MEMO REQUEST', 'CREDIT'

Line 4973: UPDATE AP_INVOICES_ALL

4969: terms_date = l_terms_date
4970: WHERE invoice_id = l_invoice_id;
4971: IF l_period_name <> l_new_period_name THEN
4972:
4973: UPDATE AP_INVOICES_ALL
4974: SET gl_date = l_new_gl_date
4975: WHERE invoice_id = l_invoice_id;
4976:
4977: UPDATE ap_invoice_lines_all

Line 5091: UPDATE ap_invoices_all

5087: SET wfapproval_status = 'REQUIRED'
5088: WHERE invoice_id = l_invoice_id
5089: AND wfapproval_status = 'INITIATED';
5090:
5091: UPDATE ap_invoices_all
5092: SET wfapproval_status = 'NEEDS WFREAPPROVAL'
5093: WHERE invoice_id = l_invoice_id;
5094:
5095: resultout := wf_engine.eng_completed||':'||'FINISH';

Line 5622: FROM ap_invoices_all AI,

5618: AI.invoice_id,
5619: AI.approval_iteration,
5620: AI.vendor_contact_id,
5621: NVL(AI.invoice_amount, 0)
5622: FROM ap_invoices_all AI,
5623: po_vendors PV
5624: WHERE AI.invoice_id = p_invoice_id
5625: AND AI.vendor_id = PV.vendor_id;
5626: l_api_name CONSTANT VARCHAR2(200) := 'create_lineapproval_neg_process';

Line 5628: l_invoice_num ap_invoices_all.invoice_num%TYPE;

5624: WHERE AI.invoice_id = p_invoice_id
5625: AND AI.vendor_id = PV.vendor_id;
5626: l_api_name CONSTANT VARCHAR2(200) := 'create_lineapproval_neg_process';
5627: l_vendor_name po_vendors.vendor_name%TYPE;
5628: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5629: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5630: l_invoice_description ap_invoices_all.description%TYPE;
5631: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5632: l_org_id ap_invoices_all.org_id%TYPE;

Line 5629: l_invoice_date ap_invoices_all.invoice_date%TYPE;

5625: AND AI.vendor_id = PV.vendor_id;
5626: l_api_name CONSTANT VARCHAR2(200) := 'create_lineapproval_neg_process';
5627: l_vendor_name po_vendors.vendor_name%TYPE;
5628: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5629: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5630: l_invoice_description ap_invoices_all.description%TYPE;
5631: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5632: l_org_id ap_invoices_all.org_id%TYPE;
5633: l_name wf_users.name%TYPE; --bug 8620671

Line 5630: l_invoice_description ap_invoices_all.description%TYPE;

5626: l_api_name CONSTANT VARCHAR2(200) := 'create_lineapproval_neg_process';
5627: l_vendor_name po_vendors.vendor_name%TYPE;
5628: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5629: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5630: l_invoice_description ap_invoices_all.description%TYPE;
5631: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5632: l_org_id ap_invoices_all.org_id%TYPE;
5633: l_name wf_users.name%TYPE; --bug 8620671
5634: l_display_name VARCHAR2(150);

Line 5631: l_invoice_id ap_invoices_all.invoice_id%TYPE;

5627: l_vendor_name po_vendors.vendor_name%TYPE;
5628: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5629: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5630: l_invoice_description ap_invoices_all.description%TYPE;
5631: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5632: l_org_id ap_invoices_all.org_id%TYPE;
5633: l_name wf_users.name%TYPE; --bug 8620671
5634: l_display_name VARCHAR2(150);
5635: l_role VARCHAR2(50);

Line 5632: l_org_id ap_invoices_all.org_id%TYPE;

5628: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5629: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5630: l_invoice_description ap_invoices_all.description%TYPE;
5631: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5632: l_org_id ap_invoices_all.org_id%TYPE;
5633: l_name wf_users.name%TYPE; --bug 8620671
5634: l_display_name VARCHAR2(150);
5635: l_role VARCHAR2(50);
5636: l_role_display VARCHAR2(150);

Line 5652: l_total ap_invoices_all.invoice_amount%TYPE;

5648: l_line_number ap_invoice_lines_all.line_number%TYPE;
5649: l_line_amount ap_invoice_lines_all.amount%TYPE;
5650: l_ext_person_id NUMBER(15);
5651: l_ext_user_id NUMBER(15);
5652: l_total ap_invoices_all.invoice_amount%TYPE;
5653:
5654: BEGIN
5655: l_debug_info := 'Start';
5656: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 5879: FROM ap_invoices_all AI,

5875: AI.description,
5876: AI.org_id,
5877: AI.invoice_id,
5878: NVL(AI.invoice_amount, 0)
5879: FROM ap_invoices_all AI,
5880: ap_suppliers PV
5881: WHERE AI.invoice_id = p_invoice_id
5882: AND AI.invoice_type_lookup_code <> 'PAYMENT REQUEST'
5883: AND AI.vendor_id = PV.vendor_id

Line 5892: FROM ap_invoices_all AI,

5888: AI.description,
5889: AI.org_id,
5890: AI.invoice_id,
5891: NVL(AI.invoice_amount, 0)
5892: FROM ap_invoices_all AI,
5893: hz_parties HZP
5894: WHERE AI.invoice_id = p_invoice_id
5895: AND AI.invoice_type_lookup_code = 'PAYMENT REQUEST'
5896: AND AI.party_id = HZP.party_id;

Line 5899: l_invoice_num ap_invoices_all.invoice_num%TYPE;

5895: AND AI.invoice_type_lookup_code = 'PAYMENT REQUEST'
5896: AND AI.party_id = HZP.party_id;
5897:
5898: l_vendor_name po_vendors.vendor_name%TYPE;
5899: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5900: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5901: l_invoice_description ap_invoices_all.description%TYPE;
5902: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5903: l_org_id ap_invoices_all.org_id%TYPE;

Line 5900: l_invoice_date ap_invoices_all.invoice_date%TYPE;

5896: AND AI.party_id = HZP.party_id;
5897:
5898: l_vendor_name po_vendors.vendor_name%TYPE;
5899: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5900: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5901: l_invoice_description ap_invoices_all.description%TYPE;
5902: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5903: l_org_id ap_invoices_all.org_id%TYPE;
5904: l_itemkey VARCHAR2(50);

Line 5901: l_invoice_description ap_invoices_all.description%TYPE;

5897:
5898: l_vendor_name po_vendors.vendor_name%TYPE;
5899: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5900: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5901: l_invoice_description ap_invoices_all.description%TYPE;
5902: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5903: l_org_id ap_invoices_all.org_id%TYPE;
5904: l_itemkey VARCHAR2(50);
5905: l_iteration AP_INVOICES_ALL.APPROVAL_ITERATION%TYPE;

Line 5902: l_invoice_id ap_invoices_all.invoice_id%TYPE;

5898: l_vendor_name po_vendors.vendor_name%TYPE;
5899: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5900: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5901: l_invoice_description ap_invoices_all.description%TYPE;
5902: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5903: l_org_id ap_invoices_all.org_id%TYPE;
5904: l_itemkey VARCHAR2(50);
5905: l_iteration AP_INVOICES_ALL.APPROVAL_ITERATION%TYPE;
5906: l_api_name CONSTANT VARCHAR2(200) := 'create_invapp_process';

Line 5903: l_org_id ap_invoices_all.org_id%TYPE;

5899: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5900: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5901: l_invoice_description ap_invoices_all.description%TYPE;
5902: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5903: l_org_id ap_invoices_all.org_id%TYPE;
5904: l_itemkey VARCHAR2(50);
5905: l_iteration AP_INVOICES_ALL.APPROVAL_ITERATION%TYPE;
5906: l_api_name CONSTANT VARCHAR2(200) := 'create_invapp_process';
5907: l_debug_info VARCHAR2(2000);

Line 5905: l_iteration AP_INVOICES_ALL.APPROVAL_ITERATION%TYPE;

5901: l_invoice_description ap_invoices_all.description%TYPE;
5902: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5903: l_org_id ap_invoices_all.org_id%TYPE;
5904: l_itemkey VARCHAR2(50);
5905: l_iteration AP_INVOICES_ALL.APPROVAL_ITERATION%TYPE;
5906: l_api_name CONSTANT VARCHAR2(200) := 'create_invapp_process';
5907: l_debug_info VARCHAR2(2000);
5908: l_total ap_invoices_all.invoice_amount%TYPE;
5909: l_calling_sequence VARCHAR2(2000);

Line 5908: l_total ap_invoices_all.invoice_amount%TYPE;

5904: l_itemkey VARCHAR2(50);
5905: l_iteration AP_INVOICES_ALL.APPROVAL_ITERATION%TYPE;
5906: l_api_name CONSTANT VARCHAR2(200) := 'create_invapp_process';
5907: l_debug_info VARCHAR2(2000);
5908: l_total ap_invoices_all.invoice_amount%TYPE;
5909: l_calling_sequence VARCHAR2(2000);
5910: l_num NUMBER;
5911:
5912:

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

5916: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5917: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5918: l_api_name,l_debug_info);
5919: END IF;
5920: l_debug_info := 'Before UPDATE AP_INVOICES_ALL';
5921: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5922: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5923: l_api_name,l_debug_info);
5924: END IF;

Line 5926: UPDATE AP_INVOICES_ALL

5922: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5923: l_api_name,l_debug_info);
5924: END IF;
5925: l_calling_sequence := l_api_name;
5926: UPDATE AP_INVOICES_ALL
5927: SET WFAPPROVAL_STATUS = 'INITIATED'
5928: WHERE invoice_id = p_invoice_id;
5929: /*
5930: UPDATE AP_INVOICE_LINES_ALL

Line 6554: FROM ap_invoices_all

6550: SELECT organization
6551: INTO l_return_val
6552: FROM PA_EXP_ORGS_IT
6553: WHERE organization_id=(SELECT expenditure_organization_id
6554: FROM ap_invoices_all
6555: WHERE invoice_id = p_invoice_id);
6556:
6557: ELSIF p_attribute_name= 'SUPPLIER_INVOICE_PROJECT_RELATED' THEN
6558:

Line 7092: FROM ap_invoices_all

7088: l_invoice_id := p_invoice_id;
7089: BEGIN
7090: SELECT NVL(wfapproval_status, 'NOT REQUIRED')
7091: INTO l_wfapproval_status
7092: FROM ap_invoices_all
7093: WHERE invoice_id = l_invoice_id;
7094: END;
7095:
7096:

Line 7373: ap_invoices_all ai

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
7377: and ai.org_id=p_org_id

Line 7432: (select invoice_id from ap_invoices_all ai

7428:
7429: --Clear all iaw processing records
7430:
7431: DELETE FROM AP_APINV_APPROVERS WHERE invoice_id in
7432: (select invoice_id from ap_invoices_all ai
7433: where ai.org_id=p_org_id
7434: and wfapproval_status in ('INITIATED','REQUIRED'
7435: ,'REJECTED','NEEDS WFREAPPROVAL'
7436: ,'STOPPED')

Line 7449: UPDATE ap_invoices_all

7445: ,'REJECTED','NEEDS WFREAPPROVAL'
7446: ,'STOPPED');
7447:
7448: --Set the header status
7449: UPDATE ap_invoices_all
7450: SET wfapproval_status = 'NOT REQUIRED'
7451: WHERE wfapproval_status in ('INITIATED','REQUIRED'
7452: ,'REJECTED','NEEDS WFREAPPROVAL'
7453: ,'STOPPED');

Line 7461: from ap_invoices_all ai

7457: UPDATE ap_invoice_lines_all ail
7458: SET ail.wfapproval_status = 'NOT REQUIRED'
7459: WHERE ail.invoice_id in
7460: ( select /*+unnest*/ invoice_id
7461: from ap_invoices_all ai
7462: where ai.org_id=p_org_id
7463: and ai.wfapproval_status in ('INITIATED','REQUIRED'
7464: ,'REJECTED','NEEDS WFREAPPROVAL','STOPPED')
7465: )

Line 7471: UPDATE ap_invoices_all

7467: ,'REJECTED','NEEDS WFREAPPROVAL'
7468: ,'STOPPED');
7469:
7470: --Set the header status
7471: UPDATE ap_invoices_all
7472: SET wfapproval_status = 'NOT REQUIRED'
7473: WHERE org_id = p_org_id
7474: AND wfapproval_status in ('INITIATED','REQUIRED'
7475: ,'REJECTED','NEEDS WFREAPPROVAL'

Line 7839: l_invoice_id ap_invoices_all.invoice_id%TYPE;

7835: itemkey IN VARCHAR2,
7836: actid IN NUMBER,
7837: funcmode IN VARCHAR2,
7838: resultout OUT NOCOPY VARCHAR2 ) IS
7839: l_invoice_id ap_invoices_all.invoice_id%TYPE;
7840: l_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
7841: l_debug_info VARCHAR2(2000);
7842: l_api_name CONSTANT VARCHAR2(200) := 'is_payment_request';
7843: BEGIN

Line 7840: l_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;

7836: actid IN NUMBER,
7837: funcmode IN VARCHAR2,
7838: resultout OUT NOCOPY VARCHAR2 ) IS
7839: l_invoice_id ap_invoices_all.invoice_id%TYPE;
7840: l_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
7841: l_debug_info VARCHAR2(2000);
7842: l_api_name CONSTANT VARCHAR2(200) := 'is_payment_request';
7843: BEGIN
7844: l_invoice_id := WF_ENGINE.GETITEMATTRNumber

Line 7850: FROM ap_invoices_all ai

7846: itemkey,
7847: 'INVOICE_ID');
7848: SELECT ai.invoice_type_lookup_code
7849: INTO l_inv_type
7850: FROM ap_invoices_all ai
7851: WHERE invoice_id = l_invoice_id;
7852:
7853: IF l_inv_type = 'PAYMENT REQUEST' THEN
7854: resultout := wf_engine.eng_completed||':'||'Y';

Line 7904: l_amount ap_invoices_all.invoice_amount%TYPE;

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

Line 8280: l_amount ap_invoices_all.invoice_amount%TYPE;

8276: l_esc_approver AME_UTIL.approverRecord;
8277: l_rec_role VARCHAR2(50);
8278: l_comments VARCHAR2(240);
8279: l_hist_id NUMBER(15);
8280: l_amount ap_invoices_all.invoice_amount%TYPE;
8281: l_user_id NUMBER(15);
8282: l_login_id NUMBER(15);
8283: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
8284: l_notf_iteration NUMBER;