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_INVOICE_LINES_ALL

Line 117: FROM ap_invoice_lines_all

113: SUM(DECODE(line_type_lookup_code,'MISCELLANEOUS',NVL(amount, 0) - NVL(included_tax_amount, 0),0)) MISC_SUM,
114: SUM(DECODE(line_type_lookup_code,'FREIGHT',NVL(amount, 0) - NVL(included_tax_amount, 0),0)) FREIGHT_SUM,
115: sum(decode(line_type_lookup_code, 'ITEM', NVL(retained_amount, 0), 0)) RETAINAGE_SUM
116: INTO l_item_sum, l_tax_sum, l_misc_sum, l_frt_sum, l_retained_sum
117: FROM ap_invoice_lines_all
118: WHERE invoice_id = p_invoice_id;
119:
120: EXCEPTION
121: WHEN NO_DATA_FOUND THEN

Line 339: from ap_invoice_lines_all ail

335: l_api_name,l_debug_info);
336: END IF;
337: select count(1)
338: into l_num
339: from ap_invoice_lines_all ail
340: where ail.invoice_id = l_invoice_id
341: and ail.org_id = l_org_id
342: and ail.line_type_lookup_code = 'ITEM'
343: and exists (

Line 1445: UPDATE AP_INVOICE_LINES_ALL

1441: SET WFApproval_Status = 'NOT REQUIRED'
1442: WHERE Invoice_Id = l_invoice_id
1443: AND WFApproval_Status = 'INITIATED';
1444:
1445: UPDATE AP_INVOICE_LINES_ALL
1446: SET WFApproval_Status = 'NOT REQUIRED'
1447: WHERE Invoice_Id = l_invoice_id
1448: AND WFApproval_Status = 'INITIATED';
1449:

Line 1520: UPDATE AP_INVOICE_LINES_ALL

1516: SET WFApproval_Status = 'REJECTED'
1517: WHERE Invoice_Id = l_invoice_id
1518: AND WFApproval_Status = 'INITIATED';
1519:
1520: UPDATE AP_INVOICE_LINES_ALL
1521: SET WFApproval_Status = 'REJECTED'
1522: WHERE Invoice_Id = l_invoice_id
1523: AND WFApproval_Status = 'INITIATED';
1524:

Line 1558: FROM ap_invoice_lines_all

1554: resultout OUT NOCOPY VARCHAR2 ) IS
1555:
1556: CURSOR matched_lines (l_invoice_id IN VARCHAR2) IS
1557: SELECT line_number, amount
1558: FROM ap_invoice_lines_all
1559: WHERE po_header_id is not null
1560: AND invoice_id = l_invoice_id
1561: AND wfapproval_status = 'INITIATED';
1562:

Line 1715: UPDATE AP_INVOICE_LINES_ALL

1711: l_api_name,l_debug_info);
1712: END IF;
1713:
1714: --Set transaction statuses
1715: UPDATE AP_INVOICE_LINES_ALL
1716: SET WFApproval_Status = 'NOT REQUIRED'
1717: WHERE Invoice_Id = l_invoice_id
1718: AND PO_Header_Id IS NOT NULL
1719: AND WFApproval_Status = 'INITIATED';

Line 1742: FROM ap_invoice_lines_all

1738: END IF;
1739:
1740: SELECT count(*)
1741: INTO l_lines_require_approval
1742: FROM ap_invoice_lines_all
1743: WHERE invoice_id = l_invoice_id
1744: AND WFApproval_Status = 'INITIATED';
1745:
1746: IF l_lines_require_approval > 0 THEN

Line 2500: UPDATE AP_INVOICE_LINES_ALL

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
2502: ,'INVOICE REQUEST','REJECTED'
2503: ,'CREDIT MEMO REQUEST','REJECTED'
2504: ,'NOT REQUIRED')

Line 2550: UPDATE AP_INVOICE_LINES_ALL

2546: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2547: l_api_name,l_debug_info);
2548: END IF;
2549:
2550: UPDATE AP_INVOICE_LINES_ALL
2551: SET WFApproval_Status = 'WFAPPROVED'
2552: WHERE Invoice_Id = l_invoice_id
2553: AND WFApproval_Status = 'INITIATED'
2554: AND Line_Number IN (SELECT DISTINCT Line_Number

Line 2566: UPDATE AP_INVOICE_LINES_ALL

2562: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2563: l_api_name,l_debug_info);
2564: END IF;
2565:
2566: UPDATE AP_INVOICE_LINES_ALL
2567: SET WFApproval_Status = 'NOT REQUIRED'
2568: WHERE Invoice_Id = l_invoice_id
2569: AND WFApproval_Status = 'INITIATED';
2570:

Line 3301: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al

3297: --but I want to avoid another select on the table
3298: CURSOR Items_Cur(itemkey IN VARCHAR2) IS
3299: SELECT invap.Item_Class, invap.Item_Id, invap.Role_Name,
3300: invap.Invoice_Key, al.line_number, al.amount
3301: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al
3302: WHERE invap.Notification_Key = itemkey
3303: AND al.line_number = invap.line_number
3304: AND al.invoice_id = invap.invoice_id;
3305:

Line 3330: l_line_number ap_invoice_lines_all.line_number%TYPE;

3326: l_line_total NUMBER;
3327: l_iteration NUMBER(15);
3328: l_comments VARCHAR2(240);
3329: l_org_id NUMBER(15);
3330: l_line_number ap_invoice_lines_all.line_number%TYPE;
3331: l_line_amount ap_invoice_lines_all.amount%TYPE;
3332: l_notf_iteration NUMBER;
3333:
3334:

Line 3331: l_line_amount ap_invoice_lines_all.amount%TYPE;

3327: l_iteration NUMBER(15);
3328: l_comments VARCHAR2(240);
3329: l_org_id NUMBER(15);
3330: l_line_number ap_invoice_lines_all.line_number%TYPE;
3331: l_line_amount ap_invoice_lines_all.amount%TYPE;
3332: l_notf_iteration NUMBER;
3333:
3334:
3335:

Line 3470: UPDATE AP_INVOICE_LINES_ALL -- Bug 9388962

3466:
3467:
3468: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3469: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3470: UPDATE AP_INVOICE_LINES_ALL -- Bug 9388962
3471: SET wfapproval_status = 'REJECTED'
3472: ,Last_Update_Date = sysdate
3473: ,Last_Updated_By = l_user_id
3474: ,Last_Update_Login = l_login_id

Line 3535: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al

3531: --but I want to avoid another select on the table
3532: CURSOR Items_Cur(itemkey IN VARCHAR2) IS
3533: SELECT invap.Item_Class, invap.Item_Id, invap.Role_Name,
3534: invap.Invoice_Key, al.line_number, al.amount
3535: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al
3536: WHERE invap.Notification_Key = itemkey
3537: AND al.line_number = invap.line_number
3538: AND al.invoice_id = invap.invoice_id;
3539:

Line 3564: l_line_number ap_invoice_lines_all.line_number%TYPE;

3560: l_line_total NUMBER;
3561: l_iteration NUMBER(15);
3562: l_comments VARCHAR2(240);
3563: l_org_id NUMBER(15);
3564: l_line_number ap_invoice_lines_all.line_number%TYPE;
3565: l_line_amount ap_invoice_lines_all.amount%TYPE;
3566: l_notf_iteration NUMBER;
3567:
3568:

Line 3565: l_line_amount ap_invoice_lines_all.amount%TYPE;

3561: l_iteration NUMBER(15);
3562: l_comments VARCHAR2(240);
3563: l_org_id NUMBER(15);
3564: l_line_number ap_invoice_lines_all.line_number%TYPE;
3565: l_line_amount ap_invoice_lines_all.amount%TYPE;
3566: l_notf_iteration NUMBER;
3567:
3568:
3569:

Line 3879: l_line_number ap_invoice_lines_all.line_number%TYPE;

3875: l_line_total NUMBER;
3876: l_iteration NUMBER(15);
3877: l_comments VARCHAR2(240);
3878: l_org_id NUMBER(15);
3879: l_line_number ap_invoice_lines_all.line_number%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);

Line 3880: l_line_amount ap_invoice_lines_all.amount%TYPE;

3876: l_iteration NUMBER(15);
3877: l_comments VARCHAR2(240);
3878: l_org_id NUMBER(15);
3879: l_line_number ap_invoice_lines_all.line_number%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;

Line 4056: l_line_number ap_invoice_lines_all.line_number%TYPE;

4052: l_line_total NUMBER;
4053: l_iteration NUMBER(15);
4054: l_comments VARCHAR2(240);
4055: l_org_id NUMBER(15);
4056: l_line_number ap_invoice_lines_all.line_number%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);

Line 4057: l_line_amount ap_invoice_lines_all.amount%TYPE;

4053: l_iteration NUMBER(15);
4054: l_comments VARCHAR2(240);
4055: l_org_id NUMBER(15);
4056: l_line_number ap_invoice_lines_all.line_number%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;

Line 4192: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al

4188: --but I want to avoid another select on the table
4189: CURSOR Items_Cur(itemkey IN VARCHAR2) IS
4190: SELECT invap.Item_Class, invap.Item_Id, invap.Role_Name,
4191: invap.Invoice_Key, al.line_number, al.amount
4192: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al
4193: WHERE invap.child_process_item_key = itemkey
4194: AND al.line_number = invap.line_number
4195: AND al.invoice_id = invap.invoice_id;
4196: l_api_name CONSTANT VARCHAR2(200) := 'aprvl_process_cancel_inv_sup';

Line 4218: l_line_number ap_invoice_lines_all.line_number%TYPE;

4214: l_line_total NUMBER;
4215: l_iteration NUMBER(15);
4216: l_comments VARCHAR2(240);
4217: l_org_id NUMBER(15);
4218: l_line_number ap_invoice_lines_all.line_number%TYPE;
4219: l_line_amount ap_invoice_lines_all.amount%TYPE;
4220: l_parent_key VARCHAR2(150);
4221: l_result BOOLEAN;
4222: l_last_updated_by number;

Line 4219: l_line_amount ap_invoice_lines_all.amount%TYPE;

4215: l_iteration NUMBER(15);
4216: l_comments VARCHAR2(240);
4217: l_org_id NUMBER(15);
4218: l_line_number ap_invoice_lines_all.line_number%TYPE;
4219: l_line_amount ap_invoice_lines_all.amount%TYPE;
4220: l_parent_key VARCHAR2(150);
4221: l_result BOOLEAN;
4222: l_last_updated_by number;
4223: l_last_update_login number;

Line 4836: l_period_name ap_invoice_lines_all.period_name%TYPE;

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;
4840: l_count_rejects number;

Line 4837: l_new_period_name ap_invoice_lines_all.period_name%TYPE;

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;
4840: l_count_rejects number;
4841: l_inv_match_type VARCHAR2(80);

Line 4854: FROM ap_invoice_lines_all

4850: l_count_rejects := 0;
4851:
4852: SELECT count(*)
4853: into l_count_rejects
4854: FROM ap_invoice_lines_all
4855: WHERE invoice_id = l_invoice_id
4856: AND wfapproval_status = 'REJECTED';
4857:
4858: IF l_count_rejects = 0 THEN

Line 4934: UPDATE AP_INVOICE_LINES_ALL

4930: l_inv_match_type := WF_ENGINE.GetItemAttrText('APINVAPR',
4931: itemkey,
4932: 'INV_MATCH_TYPE');
4933: IF l_inv_match_type = 'UNMATCHED' THEN
4934: UPDATE AP_INVOICE_LINES_ALL
4935: SET wfapproval_status = 'NOT REQUIRED'
4936: WHERE invoice_id = l_invoice_id
4937: AND wfapproval_status <> 'MANUALLY APPROVED';
4938: END IF;

Line 4977: UPDATE ap_invoice_lines_all

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
4978: SET accounting_date = l_new_gl_date
4979: ,period_name = l_new_period_name
4980: WHERE invoice_id = l_invoice_id;
4981:

Line 5086: UPDATE AP_INVOICE_LINES_ALL

5082:
5083: ELSE /* For IF l_count_rejects = 0, so there are rejections */
5084: /* Should never go through following update since all lines
5085: should be either Rejected or approved by this time */
5086: UPDATE AP_INVOICE_LINES_ALL
5087: SET wfapproval_status = 'REQUIRED'
5088: WHERE invoice_id = l_invoice_id
5089: AND wfapproval_status = 'INITIATED';
5090:

Line 5312: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al

5308: --Define cursor for lines affected by notification
5309: CURSOR Items_Cur(itemkey IN VARCHAR2) IS
5310: SELECT invap.Item_Class, invap.Item_Id, invap.Role_Name,
5311: invap.Invoice_Key, al.line_number, al.amount
5312: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al
5313: WHERE invap.Notification_Key = itemkey
5314: AND al.line_number = invap.line_number
5315: AND al.invoice_id = invap.invoice_id;
5316:

Line 5334: l_line_number ap_invoice_lines_all.line_number%TYPE;

5330: l_debug_info VARCHAR2(2000);
5331: l_iteration NUMBER;
5332: l_item_class VARCHAR2(50);
5333: l_item_id NUMBER;
5334: l_line_number ap_invoice_lines_all.line_number%TYPE;
5335: l_line_amount ap_invoice_lines_all.amount%TYPE;
5336: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
5337: l_comments VARCHAR2(240);
5338: l_esc_flag VARCHAR2(1);

Line 5335: l_line_amount ap_invoice_lines_all.amount%TYPE;

5331: l_iteration NUMBER;
5332: l_item_class VARCHAR2(50);
5333: l_item_id NUMBER;
5334: l_line_number ap_invoice_lines_all.line_number%TYPE;
5335: l_line_amount ap_invoice_lines_all.amount%TYPE;
5336: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
5337: l_comments VARCHAR2(240);
5338: l_esc_flag VARCHAR2(1);
5339: l_invoice_key VARCHAR2(50);

Line 5648: l_line_number ap_invoice_lines_all.line_number%TYPE;

5644: l_role_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
5645: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
5646: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
5647: l_debug_info VARCHAR2(2000);
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;

Line 5649: l_line_amount ap_invoice_lines_all.amount%TYPE;

5645: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
5646: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
5647: l_debug_info VARCHAR2(2000);
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:

Line 5930: UPDATE AP_INVOICE_LINES_ALL

5926: UPDATE AP_INVOICES_ALL
5927: SET WFAPPROVAL_STATUS = 'INITIATED'
5928: WHERE invoice_id = p_invoice_id;
5929: /*
5930: UPDATE AP_INVOICE_LINES_ALL
5931: SET WFAPPROVAL_STATUS = 'INITIATED'
5932: where invoice_id = p_invoice_id;
5933: */
5934:

Line 6013: l_debug_info := 'Before UPDATE AP_INVOICE_LINES_ALL';

6009:
6010: /* Set wfapproval status at the line level so that AME doesnt return
6011: any Line levcel approvers for the matched case even if the rules
6012: have been so set up. */
6013: l_debug_info := 'Before UPDATE AP_INVOICE_LINES_ALL';
6014: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6015: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6016: l_api_name,l_debug_info);
6017: END IF;

Line 6021: FROM ap_invoice_lines_all

6017: END IF;
6018:
6019: SELECT COUNT(*)
6020: INTO l_num
6021: FROM ap_invoice_lines_all
6022: WHERE po_header_id IS NOT NULL
6023: AND invoice_id = l_invoice_id
6024: and nvl(discarded_flag,'N')='N' /*bug 14748974 */
6025: ;

Line 6035: UPDATE AP_INVOICE_LINES_ALL

6031: 'MATCHED');
6032:
6033: --bug 14748974 changed to add approval status for po matched lines only
6034:
6035: UPDATE AP_INVOICE_LINES_ALL
6036: SET WFAPPROVAL_STATUS = 'INITIATED'
6037: where invoice_id = p_invoice_id
6038: and po_header_id IS NOT NULL
6039: and nvl(discarded_flag,'N')='N';

Line 6041: UPDATE AP_INVOICE_LINES_ALL

6037: where invoice_id = p_invoice_id
6038: and po_header_id IS NOT NULL
6039: and nvl(discarded_flag,'N')='N';
6040:
6041: UPDATE AP_INVOICE_LINES_ALL
6042: SET WFAPPROVAL_STATUS = 'NOT REQUIRED'
6043: where invoice_id = p_invoice_id
6044: and (po_header_id IS NULL or
6045: (po_header_id IS NOT NULL and nvl(discarded_flag,'N')='Y'));

Line 6053: UPDATE AP_INVOICE_LINES_ALL

6049: WF_ENGINE.SetItemAttrText('APINVAPR',
6050: l_itemkey,
6051: 'INV_MATCH_TYPE',
6052: 'UNMATCHED');
6053: UPDATE AP_INVOICE_LINES_ALL
6054: SET WFAPPROVAL_STATUS = 'NOT REQUIRED'
6055: where invoice_id = p_invoice_id;
6056: END IF;
6057:

Line 6271: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al

6267: --but I want to avoid another select on the table
6268: CURSOR Items_Cur IS
6269: SELECT invap.Item_Class, invap.Item_Id, invap.Role_Name,
6270: invap.Invoice_Key, al.line_number, al.amount
6271: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al
6272: WHERE invap.child_process_item_key = p_itemkey
6273: AND invap.line_number = p_line_number
6274: AND invap.invoice_id = p_invoice_id
6275: AND al.line_number = invap.line_number

Line 6303: l_line_number ap_invoice_lines_all.line_number%TYPE;

6299: l_line_total NUMBER;
6300: l_iteration NUMBER(15);
6301: l_comments VARCHAR2(240);
6302: l_org_id NUMBER(15);
6303: l_line_number ap_invoice_lines_all.line_number%TYPE;
6304: l_line_amount ap_invoice_lines_all.amount%TYPE;
6305: l_notf_iteration NUMBER;
6306: l_response ap_inv_aprvl_hist_all.response%TYPE;
6307: l_sent NUMBER;

Line 6304: l_line_amount ap_invoice_lines_all.amount%TYPE;

6300: l_iteration NUMBER(15);
6301: l_comments VARCHAR2(240);
6302: l_org_id NUMBER(15);
6303: l_line_number ap_invoice_lines_all.line_number%TYPE;
6304: l_line_amount ap_invoice_lines_all.amount%TYPE;
6305: l_notf_iteration NUMBER;
6306: l_response ap_inv_aprvl_hist_all.response%TYPE;
6307: l_sent NUMBER;
6308: BEGIN

Line 6457: UPDATE AP_INVOICE_LINES_ALL

6453: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
6454: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
6455:
6456: IF l_response = 'REJECTED' THEN
6457: UPDATE AP_INVOICE_LINES_ALL
6458: SET wfapproval_status = 'REJECTED'
6459: ,Last_Update_Date = sysdate
6460: ,Last_Updated_By = l_user_id
6461: ,Last_Update_Login = l_login_id

Line 6578: FROM ap_invoice_lines_all

6574:
6575: SELECT sum(decode(po_header_id, null, 0, 1)),
6576: count(line_number)
6577: INTO l_sum_matched, l_item_count
6578: FROM ap_invoice_lines_all
6579: WHERE invoice_id = p_invoice_id
6580: AND line_type_lookup_code = 'ITEM'
6581: and nvl(discarded_flag,'N')='N'; --bug 12846778
6582:

Line 6594: FROM ap_invoice_lines_all

6590:
6591: SELECT sum(decode(tax_already_calculated_flag, 'Y',
6592: 1, 0)), count(line_number)
6593: INTO l_sum_calc, l_line_count
6594: FROM ap_invoice_lines_all
6595: WHERE invoice_id = p_invoice_id
6596: AND line_type_lookup_code not in ('TAX','AWT');
6597:
6598: IF l_sum_calc >0 and l_sum_matched = l_line_count THEN

Line 6649: FROM ap_invoice_lines_all

6645:
6646: IF p_attribute_name = 'SUPPLIER_INVOICE_LINE_MATCHED' THEN
6647: SELECT decode(po_header_id, null, 'N', 'Y')
6648: INTO l_return_val
6649: FROM ap_invoice_lines_all
6650: WHERE invoice_id = p_invoice_id
6651: AND line_number = p_sub_class_id;
6652:
6653: END IF;

Line 6987: p_invoice_id IN ap_invoice_lines_all.invoice_id%TYPE

6983: END IF;
6984: END;
6985:
6986: FUNCTION IS_INV_NEGOTIATED(
6987: p_invoice_id IN ap_invoice_lines_all.invoice_id%TYPE
6988: ,p_org_id IN ap_invoice_lines_all.org_id%TYPE)
6989: RETURN BOOLEAN IS
6990: l_num_lines_under_neg NUMBER;
6991: l_num_holds_under_neg NUMBER;

Line 6988: ,p_org_id IN ap_invoice_lines_all.org_id%TYPE)

6984: END;
6985:
6986: FUNCTION IS_INV_NEGOTIATED(
6987: p_invoice_id IN ap_invoice_lines_all.invoice_id%TYPE
6988: ,p_org_id IN ap_invoice_lines_all.org_id%TYPE)
6989: RETURN BOOLEAN IS
6990: l_num_lines_under_neg NUMBER;
6991: l_num_holds_under_neg NUMBER;
6992: l_debug_info VARCHAR2(2000);

Line 7029: FROM ap_invoice_lines_all ail, ap_apinv_approvers aaa

7025: END IF;
7026:
7027: SELECT COUNT(*)
7028: INTO l_num_lines_under_neg
7029: FROM ap_invoice_lines_all ail, ap_apinv_approvers aaa
7030: WHERE ail.invoice_id = p_invoice_id
7031: AND ail.org_id = p_org_id
7032: AND aaa.invoice_id = ail.invoice_id
7033: AND aaa.line_number = ail.line_number

Line 7442: UPDATE ap_invoice_lines_all

7438:
7439:
7440: /* --bug 14492241 commented the below and added new for performance
7441: --Set the lines status
7442: UPDATE ap_invoice_lines_all
7443: SET wfapproval_status = 'NOT REQUIRED'
7444: WHERE wfapproval_status in ('INITIATED','REQUIRED'
7445: ,'REJECTED','NEEDS WFREAPPROVAL'
7446: ,'STOPPED');

Line 7457: UPDATE ap_invoice_lines_all ail

7453: ,'STOPPED');
7454: */
7455:
7456: --Set the lines status
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

Line 7656: update ap_invoice_lines_all ail

7652: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7653: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7654: l_api_name,l_debug_info);
7655: END IF;
7656: update ap_invoice_lines_all ail
7657: set generate_dists = decode(ail.generate_dists, 'Y', 'D', ail.generate_dists)
7658: where ail.invoice_id = l_invoice_id
7659: and exists( select 1 from ap_invoice_distributions_all aid
7660: where aid.invoice_id = l_invoice_id

Line 8285: l_line_number ap_invoice_lines_all.line_number%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;
8285: l_line_number ap_invoice_lines_all.line_number%TYPE;
8286: l_line_amount ap_invoice_lines_all.amount%TYPE;
8287: l_role_name varchar2(50);
8288: l_esc_flag varchar2(1);
8289: l_esc_role varchar2(50);

Line 8286: l_line_amount ap_invoice_lines_all.amount%TYPE;

8282: l_login_id NUMBER(15);
8283: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
8284: l_notf_iteration NUMBER;
8285: l_line_number ap_invoice_lines_all.line_number%TYPE;
8286: l_line_amount ap_invoice_lines_all.amount%TYPE;
8287: l_role_name varchar2(50);
8288: l_esc_flag varchar2(1);
8289: l_esc_role varchar2(50);
8290:

Line 8306: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al

8302:
8303:
8304: CURSOR Items_Cur(itemkey IN VARCHAR2) IS
8305: SELECT al.line_number, al.amount
8306: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al
8307: WHERE invap.Notification_Key = itemkey
8308: AND al.line_number = invap.line_number
8309: AND al.invoice_id = invap.invoice_id;
8310: BEGIN

Line 8834: l_line_number ap_invoice_lines_all.line_number%TYPE;

8830: l_approver_name VARCHAR2(50);
8831: l_disp_not_receiver VARCHAR2(50);
8832: l_iteration NUMBER;
8833: l_notf_iteration NUMBER;
8834: l_line_number ap_invoice_lines_all.line_number%TYPE;
8835: l_line_amount ap_invoice_lines_all.amount%TYPE;
8836: l_invoice_key VARCHAR2(50);
8837: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
8838: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;

Line 8835: l_line_amount ap_invoice_lines_all.amount%TYPE;

8831: l_disp_not_receiver VARCHAR2(50);
8832: l_iteration NUMBER;
8833: l_notf_iteration NUMBER;
8834: l_line_number ap_invoice_lines_all.line_number%TYPE;
8835: l_line_amount ap_invoice_lines_all.amount%TYPE;
8836: l_invoice_key VARCHAR2(50);
8837: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
8838: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
8839: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;

Line 8851: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al

8847: --Cursor Declaration
8848: CURSOR Items_Cur(itemkey IN VARCHAR2) IS
8849: SELECT invap.Item_Class, invap.Item_Id, invap.Role_Name,
8850: invap.Invoice_Key, al.line_number, al.amount
8851: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al
8852: WHERE invap.Notification_Key = itemkey
8853: AND al.line_number = invap.line_number
8854: AND al.invoice_id = invap.invoice_id;
8855: