DBA Data[Home] [Help]

APPS.AP_WORKFLOW_PKG dependencies on AP_INVOICE_LINES_ALL

Line 114: FROM ap_invoice_lines_all

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

Line 331: from ap_invoice_lines_all ail

327: l_api_name,l_debug_info);
328: END IF;
329: select count(1)
330: into l_num
331: from ap_invoice_lines_all ail
332: where ail.invoice_id = l_invoice_id
333: and ail.org_id = l_org_id
334: and ail.line_type_lookup_code = 'ITEM'
335: and exists (

Line 1413: UPDATE AP_INVOICE_LINES_ALL

1409: SET WFApproval_Status = 'NOT REQUIRED'
1410: WHERE Invoice_Id = l_invoice_id
1411: AND WFApproval_Status = 'INITIATED';
1412:
1413: UPDATE AP_INVOICE_LINES_ALL
1414: SET WFApproval_Status = 'NOT REQUIRED'
1415: WHERE Invoice_Id = l_invoice_id
1416: AND WFApproval_Status = 'INITIATED';
1417:

Line 1488: UPDATE AP_INVOICE_LINES_ALL

1484: SET WFApproval_Status = 'REJECTED'
1485: WHERE Invoice_Id = l_invoice_id
1486: AND WFApproval_Status = 'INITIATED';
1487:
1488: UPDATE AP_INVOICE_LINES_ALL
1489: SET WFApproval_Status = 'REJECTED'
1490: WHERE Invoice_Id = l_invoice_id
1491: AND WFApproval_Status = 'INITIATED';
1492:

Line 1526: FROM ap_invoice_lines_all

1522: resultout OUT NOCOPY VARCHAR2 ) IS
1523:
1524: CURSOR matched_lines (l_invoice_id IN VARCHAR2) IS
1525: SELECT line_number, amount
1526: FROM ap_invoice_lines_all
1527: WHERE po_header_id is not null
1528: AND invoice_id = l_invoice_id
1529: AND wfapproval_status = 'INITIATED';
1530:

Line 1683: UPDATE AP_INVOICE_LINES_ALL

1679: l_api_name,l_debug_info);
1680: END IF;
1681:
1682: --Set transaction statuses
1683: UPDATE AP_INVOICE_LINES_ALL
1684: SET WFApproval_Status = 'NOT REQUIRED'
1685: WHERE Invoice_Id = l_invoice_id
1686: AND PO_Header_Id IS NOT NULL
1687: AND WFApproval_Status = 'INITIATED';

Line 1710: FROM ap_invoice_lines_all

1706: END IF;
1707:
1708: SELECT count(*)
1709: INTO l_lines_require_approval
1710: FROM ap_invoice_lines_all
1711: WHERE invoice_id = l_invoice_id
1712: AND WFApproval_Status = 'INITIATED';
1713:
1714: IF l_lines_require_approval > 0 THEN

Line 2402: UPDATE AP_INVOICE_LINES_ALL

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
2404: ,'INVOICE REQUEST','REJECTED'
2405: ,'CREDIT MEMO REQUEST','REJECTED'
2406: ,'NOT REQUIRED')

Line 2452: UPDATE AP_INVOICE_LINES_ALL

2448: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2449: l_api_name,l_debug_info);
2450: END IF;
2451:
2452: UPDATE AP_INVOICE_LINES_ALL
2453: SET WFApproval_Status = 'WFAPPROVED'
2454: WHERE Invoice_Id = l_invoice_id
2455: AND WFApproval_Status = 'INITIATED'
2456: AND Line_Number IN (SELECT DISTINCT Line_Number

Line 2468: UPDATE AP_INVOICE_LINES_ALL

2464: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2465: l_api_name,l_debug_info);
2466: END IF;
2467:
2468: UPDATE AP_INVOICE_LINES_ALL
2469: SET WFApproval_Status = 'NOT REQUIRED'
2470: WHERE Invoice_Id = l_invoice_id
2471: AND WFApproval_Status = 'INITIATED';
2472:

Line 3200: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al

3196: --but I want to avoid another select on the table
3197: CURSOR Items_Cur(itemkey IN VARCHAR2) IS
3198: SELECT invap.Item_Class, invap.Item_Id, invap.Role_Name,
3199: invap.Invoice_Key, al.line_number, al.amount
3200: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al
3201: WHERE invap.Notification_Key = itemkey
3202: AND al.line_number = invap.line_number
3203: AND al.invoice_id = invap.invoice_id;
3204:

Line 3229: l_line_number ap_invoice_lines_all.line_number%TYPE;

3225: l_line_total NUMBER;
3226: l_iteration NUMBER(15);
3227: l_comments VARCHAR2(240);
3228: l_org_id NUMBER(15);
3229: l_line_number ap_invoice_lines_all.line_number%TYPE;
3230: l_line_amount ap_invoice_lines_all.amount%TYPE;
3231: l_notf_iteration NUMBER;
3232:
3233:

Line 3230: l_line_amount ap_invoice_lines_all.amount%TYPE;

3226: l_iteration NUMBER(15);
3227: l_comments VARCHAR2(240);
3228: l_org_id NUMBER(15);
3229: l_line_number ap_invoice_lines_all.line_number%TYPE;
3230: l_line_amount ap_invoice_lines_all.amount%TYPE;
3231: l_notf_iteration NUMBER;
3232:
3233:
3234:

Line 3428: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al

3424: --but I want to avoid another select on the table
3425: CURSOR Items_Cur(itemkey IN VARCHAR2) IS
3426: SELECT invap.Item_Class, invap.Item_Id, invap.Role_Name,
3427: invap.Invoice_Key, al.line_number, al.amount
3428: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al
3429: WHERE invap.Notification_Key = itemkey
3430: AND al.line_number = invap.line_number
3431: AND al.invoice_id = invap.invoice_id;
3432:

Line 3457: l_line_number ap_invoice_lines_all.line_number%TYPE;

3453: l_line_total NUMBER;
3454: l_iteration NUMBER(15);
3455: l_comments VARCHAR2(240);
3456: l_org_id NUMBER(15);
3457: l_line_number ap_invoice_lines_all.line_number%TYPE;
3458: l_line_amount ap_invoice_lines_all.amount%TYPE;
3459: l_notf_iteration NUMBER;
3460:
3461:

Line 3458: l_line_amount ap_invoice_lines_all.amount%TYPE;

3454: l_iteration NUMBER(15);
3455: l_comments VARCHAR2(240);
3456: l_org_id NUMBER(15);
3457: l_line_number ap_invoice_lines_all.line_number%TYPE;
3458: l_line_amount ap_invoice_lines_all.amount%TYPE;
3459: l_notf_iteration NUMBER;
3460:
3461:
3462:

Line 3752: l_line_number ap_invoice_lines_all.line_number%TYPE;

3748: l_line_total NUMBER;
3749: l_iteration NUMBER(15);
3750: l_comments VARCHAR2(240);
3751: l_org_id NUMBER(15);
3752: l_line_number ap_invoice_lines_all.line_number%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);

Line 3753: l_line_amount ap_invoice_lines_all.amount%TYPE;

3749: l_iteration NUMBER(15);
3750: l_comments VARCHAR2(240);
3751: l_org_id NUMBER(15);
3752: l_line_number ap_invoice_lines_all.line_number%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;

Line 3929: l_line_number ap_invoice_lines_all.line_number%TYPE;

3925: l_line_total NUMBER;
3926: l_iteration NUMBER(15);
3927: l_comments VARCHAR2(240);
3928: l_org_id NUMBER(15);
3929: l_line_number ap_invoice_lines_all.line_number%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);

Line 3930: l_line_amount ap_invoice_lines_all.amount%TYPE;

3926: l_iteration NUMBER(15);
3927: l_comments VARCHAR2(240);
3928: l_org_id NUMBER(15);
3929: l_line_number ap_invoice_lines_all.line_number%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;

Line 4065: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al

4061: --but I want to avoid another select on the table
4062: CURSOR Items_Cur(itemkey IN VARCHAR2) IS
4063: SELECT invap.Item_Class, invap.Item_Id, invap.Role_Name,
4064: invap.Invoice_Key, al.line_number, al.amount
4065: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al
4066: WHERE invap.child_process_item_key = itemkey
4067: AND al.line_number = invap.line_number
4068: AND al.invoice_id = invap.invoice_id;
4069: l_api_name CONSTANT VARCHAR2(200) := 'aprvl_process_cancel_inv_sup';

Line 4091: l_line_number ap_invoice_lines_all.line_number%TYPE;

4087: l_line_total NUMBER;
4088: l_iteration NUMBER(15);
4089: l_comments VARCHAR2(240);
4090: l_org_id NUMBER(15);
4091: l_line_number ap_invoice_lines_all.line_number%TYPE;
4092: l_line_amount ap_invoice_lines_all.amount%TYPE;
4093: l_parent_key VARCHAR2(150);
4094: l_result BOOLEAN;
4095: l_last_updated_by number;

Line 4092: l_line_amount ap_invoice_lines_all.amount%TYPE;

4088: l_iteration NUMBER(15);
4089: l_comments VARCHAR2(240);
4090: l_org_id NUMBER(15);
4091: l_line_number ap_invoice_lines_all.line_number%TYPE;
4092: l_line_amount ap_invoice_lines_all.amount%TYPE;
4093: l_parent_key VARCHAR2(150);
4094: l_result BOOLEAN;
4095: l_last_updated_by number;
4096: l_last_update_login number;

Line 4701: l_period_name ap_invoice_lines_all.period_name%TYPE;

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

Line 4702: l_new_period_name ap_invoice_lines_all.period_name%TYPE;

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

Line 4719: FROM ap_invoice_lines_all

4715: l_count_rejects := 0;
4716:
4717: SELECT count(*)
4718: into l_count_rejects
4719: FROM ap_invoice_lines_all
4720: WHERE invoice_id = l_invoice_id
4721: AND wfapproval_status = 'REJECTED';
4722:
4723: IF l_count_rejects = 0 THEN

Line 4799: UPDATE AP_INVOICE_LINES_ALL

4795: l_inv_match_type := WF_ENGINE.GetItemAttrText('APINVAPR',
4796: itemkey,
4797: 'INV_MATCH_TYPE');
4798: IF l_inv_match_type = 'UNMATCHED' THEN
4799: UPDATE AP_INVOICE_LINES_ALL
4800: SET wfapproval_status = 'NOT REQUIRED'
4801: WHERE invoice_id = l_invoice_id
4802: AND wfapproval_status <> 'MANUALLY APPROVED';
4803: END IF;

Line 4842: UPDATE ap_invoice_lines_all

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
4843: SET accounting_date = l_new_gl_date
4844: ,period_name = l_new_period_name
4845: WHERE invoice_id = l_invoice_id;
4846:

Line 4926: UPDATE AP_INVOICE_LINES_ALL

4922:
4923: ELSE /* For IF l_count_rejects = 0, so there are rejections */
4924: /* Should never go through following update since all lines
4925: should be either Rejected or approved by this time */
4926: UPDATE AP_INVOICE_LINES_ALL
4927: SET wfapproval_status = 'REQUIRED'
4928: WHERE invoice_id = l_invoice_id
4929: AND wfapproval_status = 'INITIATED';
4930:

Line 5124: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al

5120: --Define cursor for lines affected by notification
5121: CURSOR Items_Cur(itemkey IN VARCHAR2) IS
5122: SELECT invap.Item_Class, invap.Item_Id, invap.Role_Name,
5123: invap.Invoice_Key, al.line_number, al.amount
5124: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al
5125: WHERE invap.Notification_Key = itemkey
5126: AND al.line_number = invap.line_number
5127: AND al.invoice_id = invap.invoice_id;
5128:

Line 5146: l_line_number ap_invoice_lines_all.line_number%TYPE;

5142: l_debug_info VARCHAR2(2000);
5143: l_iteration NUMBER;
5144: l_item_class VARCHAR2(50);
5145: l_item_id NUMBER;
5146: l_line_number ap_invoice_lines_all.line_number%TYPE;
5147: l_line_amount ap_invoice_lines_all.amount%TYPE;
5148: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
5149: l_comments VARCHAR2(240);
5150: l_esc_flag VARCHAR2(1);

Line 5147: l_line_amount ap_invoice_lines_all.amount%TYPE;

5143: l_iteration NUMBER;
5144: l_item_class VARCHAR2(50);
5145: l_item_id NUMBER;
5146: l_line_number ap_invoice_lines_all.line_number%TYPE;
5147: l_line_amount ap_invoice_lines_all.amount%TYPE;
5148: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
5149: l_comments VARCHAR2(240);
5150: l_esc_flag VARCHAR2(1);
5151: l_invoice_key VARCHAR2(50);

Line 5407: l_line_number ap_invoice_lines_all.line_number%TYPE;

5403: l_role_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
5404: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
5405: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
5406: l_debug_info VARCHAR2(2000);
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;

Line 5408: l_line_amount ap_invoice_lines_all.amount%TYPE;

5404: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
5405: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
5406: l_debug_info VARCHAR2(2000);
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:

Line 5689: UPDATE AP_INVOICE_LINES_ALL

5685: UPDATE AP_INVOICES_ALL
5686: SET WFAPPROVAL_STATUS = 'INITIATED'
5687: WHERE invoice_id = p_invoice_id;
5688: /*
5689: UPDATE AP_INVOICE_LINES_ALL
5690: SET WFAPPROVAL_STATUS = 'INITIATED'
5691: where invoice_id = p_invoice_id;
5692: */
5693:

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

5766: l_itemkey);
5767: /* Set wfapproval status at the line level so that AME doesnt return
5768: any Line levcel approvers for the matched case even if the rules
5769: have been so set up. */
5770: l_debug_info := 'Before UPDATE AP_INVOICE_LINES_ALL';
5771: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5772: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5773: l_api_name,l_debug_info);
5774: END IF;

Line 5777: FROM ap_invoice_lines_all

5773: l_api_name,l_debug_info);
5774: END IF;
5775: SELECT COUNT(*)
5776: INTO l_num
5777: FROM ap_invoice_lines_all
5778: WHERE po_header_id IS NOT NULL
5779: AND invoice_id = l_invoice_id;
5780:
5781: IF l_num > 0 THEN

Line 5786: UPDATE AP_INVOICE_LINES_ALL

5782: WF_ENGINE.SetItemAttrText('APINVAPR',
5783: l_itemkey,
5784: 'INV_MATCH_TYPE',
5785: 'MATCHED');
5786: UPDATE AP_INVOICE_LINES_ALL
5787: SET WFAPPROVAL_STATUS = 'INITIATED'
5788: where invoice_id = p_invoice_id;
5789: ELSE
5790: WF_ENGINE.SetItemAttrText('APINVAPR',

Line 5794: UPDATE AP_INVOICE_LINES_ALL

5790: WF_ENGINE.SetItemAttrText('APINVAPR',
5791: l_itemkey,
5792: 'INV_MATCH_TYPE',
5793: 'UNMATCHED');
5794: UPDATE AP_INVOICE_LINES_ALL
5795: SET WFAPPROVAL_STATUS = 'NOT REQUIRED'
5796: where invoice_id = p_invoice_id;
5797: END IF;
5798:

Line 6004: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al

6000: --but I want to avoid another select on the table
6001: CURSOR Items_Cur IS
6002: SELECT invap.Item_Class, invap.Item_Id, invap.Role_Name,
6003: invap.Invoice_Key, al.line_number, al.amount
6004: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al
6005: WHERE invap.child_process_item_key = p_itemkey
6006: AND invap.line_number = p_line_number
6007: AND invap.invoice_id = p_invoice_id
6008: AND al.line_number = invap.line_number

Line 6036: l_line_number ap_invoice_lines_all.line_number%TYPE;

6032: l_line_total NUMBER;
6033: l_iteration NUMBER(15);
6034: l_comments VARCHAR2(240);
6035: l_org_id NUMBER(15);
6036: l_line_number ap_invoice_lines_all.line_number%TYPE;
6037: l_line_amount ap_invoice_lines_all.amount%TYPE;
6038: l_notf_iteration NUMBER;
6039: l_response ap_inv_aprvl_hist_all.response%TYPE;
6040: l_sent NUMBER;

Line 6037: l_line_amount ap_invoice_lines_all.amount%TYPE;

6033: l_iteration NUMBER(15);
6034: l_comments VARCHAR2(240);
6035: l_org_id NUMBER(15);
6036: l_line_number ap_invoice_lines_all.line_number%TYPE;
6037: l_line_amount ap_invoice_lines_all.amount%TYPE;
6038: l_notf_iteration NUMBER;
6039: l_response ap_inv_aprvl_hist_all.response%TYPE;
6040: l_sent NUMBER;
6041: BEGIN

Line 6190: UPDATE AP_INVOICE_LINES_ALL

6186: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
6187: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
6188:
6189: IF l_response = 'REJECTED' THEN
6190: UPDATE AP_INVOICE_LINES_ALL
6191: SET wfapproval_status = 'REJECTED'
6192: ,Last_Update_Date = sysdate
6193: ,Last_Updated_By = l_user_id
6194: ,Last_Update_Login = l_login_id

Line 6311: FROM ap_invoice_lines_all

6307:
6308: SELECT sum(decode(po_header_id, null, 0, 1)),
6309: count(line_number)
6310: INTO l_sum_matched, l_item_count
6311: FROM ap_invoice_lines_all
6312: WHERE invoice_id = p_invoice_id
6313: AND line_type_lookup_code = 'ITEM';
6314:
6315: IF l_sum_matched >0

Line 6326: FROM ap_invoice_lines_all

6322:
6323: SELECT sum(decode(tax_already_calculated_flag, 'Y',
6324: 1, 0)), count(line_number)
6325: INTO l_sum_calc, l_line_count
6326: FROM ap_invoice_lines_all
6327: WHERE invoice_id = p_invoice_id
6328: AND line_type_lookup_code not in ('TAX','AWT');
6329:
6330: IF l_sum_calc >0 and l_sum_matched = l_line_count THEN

Line 6381: FROM ap_invoice_lines_all

6377:
6378: IF p_attribute_name = 'SUPPLIER_INVOICE_LINE_MATCHED' THEN
6379: SELECT decode(po_header_id, null, 'N', 'Y')
6380: INTO l_return_val
6381: FROM ap_invoice_lines_all
6382: WHERE invoice_id = p_invoice_id
6383: AND line_number = p_sub_class_id;
6384:
6385: END IF;

Line 6678: p_invoice_id IN ap_invoice_lines_all.invoice_id%TYPE

6674: END IF;
6675: END;
6676:
6677: FUNCTION IS_INV_NEGOTIATED(
6678: p_invoice_id IN ap_invoice_lines_all.invoice_id%TYPE
6679: ,p_org_id IN ap_invoice_lines_all.org_id%TYPE)
6680: RETURN BOOLEAN IS
6681: l_num_lines_under_neg NUMBER;
6682: l_num_holds_under_neg NUMBER;

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

6675: END;
6676:
6677: FUNCTION IS_INV_NEGOTIATED(
6678: p_invoice_id IN ap_invoice_lines_all.invoice_id%TYPE
6679: ,p_org_id IN ap_invoice_lines_all.org_id%TYPE)
6680: RETURN BOOLEAN IS
6681: l_num_lines_under_neg NUMBER;
6682: l_num_holds_under_neg NUMBER;
6683: l_debug_info VARCHAR2(2000);

Line 6720: FROM ap_invoice_lines_all ail, ap_apinv_approvers aaa

6716: END IF;
6717:
6718: SELECT COUNT(*)
6719: INTO l_num_lines_under_neg
6720: FROM ap_invoice_lines_all ail, ap_apinv_approvers aaa
6721: WHERE ail.invoice_id = p_invoice_id
6722: AND ail.org_id = p_org_id
6723: AND aaa.invoice_id = ail.invoice_id
6724: AND aaa.line_number = ail.line_number

Line 7108: UPDATE ap_invoice_lines_all

7104: DELETE FROM AP_APINV_APPROVERS;
7105:
7106:
7107: --Set the lines status
7108: UPDATE ap_invoice_lines_all
7109: SET wfapproval_status = 'NOT REQUIRED'
7110: WHERE wfapproval_status in ('INITIATED','REQUIRED'
7111: ,'REJECTED','NEEDS WFREAPPROVAL'
7112: ,'STOPPED');

Line 7294: update ap_invoice_lines_all ail

7290: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7291: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7292: l_api_name,l_debug_info);
7293: END IF;
7294: update ap_invoice_lines_all ail
7295: set generate_dists = decode(ail.generate_dists, 'Y', 'D', ail.generate_dists)
7296: where ail.invoice_id = l_invoice_id
7297: and exists( select 1 from ap_invoice_distributions_all aid
7298: where aid.invoice_id = l_invoice_id

Line 7906: l_line_number ap_invoice_lines_all.line_number%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;
7906: l_line_number ap_invoice_lines_all.line_number%TYPE;
7907: l_line_amount ap_invoice_lines_all.amount%TYPE;
7908: l_role_name varchar2(50);
7909: l_esc_flag varchar2(1);
7910: l_esc_role varchar2(50);

Line 7907: l_line_amount ap_invoice_lines_all.amount%TYPE;

7903: l_login_id NUMBER(15);
7904: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
7905: l_notf_iteration NUMBER;
7906: l_line_number ap_invoice_lines_all.line_number%TYPE;
7907: l_line_amount ap_invoice_lines_all.amount%TYPE;
7908: l_role_name varchar2(50);
7909: l_esc_flag varchar2(1);
7910: l_esc_role varchar2(50);
7911:

Line 7927: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al

7923:
7924:
7925: CURSOR Items_Cur(itemkey IN VARCHAR2) IS
7926: SELECT al.line_number, al.amount
7927: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al
7928: WHERE invap.Notification_Key = itemkey
7929: AND al.line_number = invap.line_number
7930: AND al.invoice_id = invap.invoice_id;
7931: BEGIN