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_APPROVAL_PKG dependencies on AP_INVOICE_LINES

Line 438: FROM ap_invoice_lines_all

434: REFERENCE_KEY4,
435: REFERENCE_KEY5,
436: SHIP_TO_LOCATION_ID,
437: PAY_AWT_GROUP_ID --bug 7022001
438: FROM ap_invoice_lines_all
439: WHERE invoice_id = c_invoice_id
440: ORDER BY decode(line_type_lookup_code,'ITEM',1,2), line_number;
441:
442: PROCEDURE initialize_invoice_holds(

Line 1833: ap_invoice_lines instead of ap_invoic_distributions

1829:
1830: END Approve;
1831:
1832: /*bug6858309 - modified the function to look for
1833: ap_invoice_lines instead of ap_invoic_distributions
1834: as dists are not created for freshly created
1835: recurring invoice in R12*/
1836: FUNCTION validate_period (p_invoice_id IN NUMBER)
1837: RETURN BOOLEAN IS

Line 1841: FROM ap_invoice_lines_all

1837: RETURN BOOLEAN IS
1838:
1839: CURSOR get_gl_date IS
1840: SELECT distinct accounting_date acc_date
1841: FROM ap_invoice_lines_all
1842: WHERE invoice_id = p_invoice_id
1843: and NVL(generate_dists,'N') <> 'D';
1844:
1845: CURSOR get_inv_source IS

Line 1932: from ap_invoice_lines

1928:
1929: -- Select stmt added for bug 6684139
1930: SELECT count(*)
1931: into p_invoice_line_count
1932: from ap_invoice_lines
1933: where invoice_id = p_invoice_id;
1934:
1935: IF nvl(p_conc_flag, 'N') <> 'Y' THEN
1936:

Line 2080: FROM ap_invoice_lines_all L

2076: --bugfix:4745464
2077: BEGIN
2078: SELECT 'Y'
2079: INTO l_undistributed_line_exists
2080: FROM ap_invoice_lines_all L
2081: WHERE L.invoice_id = p_invoice_id
2082: AND L.amount <>
2083: (SELECT NVL(SUM(NVL(aid.amount,0)),0)
2084: FROM ap_invoice_distributions_all aid

Line 2244: FROM ap_invoice_lines AIL,

2240: IS
2241:
2242: CURSOR Alloc_Rule_Cur IS
2243: SELECT ALOC.rule_type
2244: FROM ap_invoice_lines AIL,
2245: ap_allocation_rules ALOC
2246: WHERE AIL.invoice_id = p_inv_line_rec.invoice_id
2247: AND AIL.line_number = p_inv_line_rec.line_number
2248: AND AIL.invoice_id = ALOC.invoice_id

Line 2395: FROM ap_invoice_lines AIL,

2391: IS
2392:
2393: CURSOR Alloc_Rule_Cur IS
2394: SELECT ALOC.rule_type
2395: FROM ap_invoice_lines AIL,
2396: ap_allocation_rules ALOC
2397: WHERE AIL.invoice_id = p_inv_line_rec.invoice_id
2398: AND AIL.line_number = p_inv_line_rec.line_number
2399: AND AIL.invoice_id = ALOC.invoice_id

Line 2418: l_reference_key1 ap_invoice_lines_all.reference_key1%type;

2414:
2415: --Bugfix:4673607
2416: l_registration_api VARCHAR2(1000);
2417: l_registration_view VARCHAR2(1000);
2418: l_reference_key1 ap_invoice_lines_all.reference_key1%type;
2419: l_reference_key2 ap_invoice_lines_all.reference_key2%type;
2420: l_reference_key3 ap_invoice_lines_all.reference_key3%type;
2421: l_reference_key4 ap_invoice_lines_all.reference_key4%type;
2422: l_reference_key5 ap_invoice_lines_all.reference_key5%type;

Line 2419: l_reference_key2 ap_invoice_lines_all.reference_key2%type;

2415: --Bugfix:4673607
2416: l_registration_api VARCHAR2(1000);
2417: l_registration_view VARCHAR2(1000);
2418: l_reference_key1 ap_invoice_lines_all.reference_key1%type;
2419: l_reference_key2 ap_invoice_lines_all.reference_key2%type;
2420: l_reference_key3 ap_invoice_lines_all.reference_key3%type;
2421: l_reference_key4 ap_invoice_lines_all.reference_key4%type;
2422: l_reference_key5 ap_invoice_lines_all.reference_key5%type;
2423: l_err varchar2(2000);

Line 2420: l_reference_key3 ap_invoice_lines_all.reference_key3%type;

2416: l_registration_api VARCHAR2(1000);
2417: l_registration_view VARCHAR2(1000);
2418: l_reference_key1 ap_invoice_lines_all.reference_key1%type;
2419: l_reference_key2 ap_invoice_lines_all.reference_key2%type;
2420: l_reference_key3 ap_invoice_lines_all.reference_key3%type;
2421: l_reference_key4 ap_invoice_lines_all.reference_key4%type;
2422: l_reference_key5 ap_invoice_lines_all.reference_key5%type;
2423: l_err varchar2(2000);
2424:

Line 2421: l_reference_key4 ap_invoice_lines_all.reference_key4%type;

2417: l_registration_view VARCHAR2(1000);
2418: l_reference_key1 ap_invoice_lines_all.reference_key1%type;
2419: l_reference_key2 ap_invoice_lines_all.reference_key2%type;
2420: l_reference_key3 ap_invoice_lines_all.reference_key3%type;
2421: l_reference_key4 ap_invoice_lines_all.reference_key4%type;
2422: l_reference_key5 ap_invoice_lines_all.reference_key5%type;
2423: l_err varchar2(2000);
2424:
2425: BEGIN

Line 2422: l_reference_key5 ap_invoice_lines_all.reference_key5%type;

2418: l_reference_key1 ap_invoice_lines_all.reference_key1%type;
2419: l_reference_key2 ap_invoice_lines_all.reference_key2%type;
2420: l_reference_key3 ap_invoice_lines_all.reference_key3%type;
2421: l_reference_key4 ap_invoice_lines_all.reference_key4%type;
2422: l_reference_key5 ap_invoice_lines_all.reference_key5%type;
2423: l_err varchar2(2000);
2424:
2425: BEGIN
2426:

Line 2470: l_success := AP_INVOICE_LINES_PKG.Insert_From_Dist_Set(

2466:
2467: l_debug_info := 'Execute_Dist_Generation_Check - insert from dist set';
2468: Print_Debug(l_debug_loc, l_debug_info);
2469:
2470: l_success := AP_INVOICE_LINES_PKG.Insert_From_Dist_Set(
2471: X_invoice_id => p_inv_line_rec.invoice_id,
2472: X_line_number => p_inv_line_rec.line_number,
2473: X_GL_Date => p_inv_line_rec.accounting_date,
2474: X_Period_Name => p_inv_line_rec.period_name,

Line 3324: FROM ap_invoice_lines_all AIL, ap_invoice_distributions_all D

3320: SELECT 'Distribution needs to be verified. '
3321: FROM DUAL
3322: WHERE EXISTS (
3323: SELECT 'Dist Total <> Invoice Line Amount'
3324: FROM ap_invoice_lines_all AIL, ap_invoice_distributions_all D
3325: -- WHERE AIL.invoice_id = D.invoice_id
3326: WHERE AIL.invoice_id = D.invoice_id(+)
3327: AND AIL.line_number = nvl(p_invoice_line_number, AIL.line_number) --bug6661773
3328: AND AIL.invoice_id = p_invoice_id

Line 3483: FROM ap_invoice_lines_all AIL, ap_invoices_all A

3479:
3480:
3481: CURSOR Line_Var_Cur IS
3482: SELECT 'Line Total <> Invoice Amount'
3483: FROM ap_invoice_lines_all AIL, ap_invoices_all A
3484: WHERE AIL.invoice_id = A.invoice_id
3485: AND AIL.invoice_id = p_invoice_id
3486: AND ((AIL.line_type_lookup_code <> 'TAX'
3487: and (AIL.line_type_lookup_code NOT IN ('AWT','PREPAY')

Line 3553: FROM ap_invoice_lines ail

3549: /* End of Bug 7271262 */
3550:
3551: SELECT count(*)
3552: INTO l_line_count
3553: FROM ap_invoice_lines ail
3554: WHERE ail.invoice_id = p_invoice_id
3555: AND (ail.line_type_lookup_code NOT IN ('PREPAY','AWT')
3556: OR nvl(invoice_includes_prepay_flag,'N') = 'Y');
3557:

Line 3645: l_rounded_line_num ap_invoice_lines.line_number%TYPE;

3641: p_exchange_rate IN NUMBER,
3642: p_need_to_round_flag IN VARCHAR2 DEFAULT 'N',
3643: p_calling_sequence IN VARCHAR2) IS
3644:
3645: l_rounded_line_num ap_invoice_lines.line_number%TYPE;
3646: l_rounded_amt NUMBER;
3647: l_round_amt_exist BOOLEAN := FALSE;
3648: l_key_value NUMBER;
3649:

Line 3669: UPDATE AP_INVOICE_LINES AIL

3665: l_debug_info := 'Update Invoice Lines Base Amount';
3666: Print_Debug(l_debug_loc, l_debug_info);
3667: -----------------------------------------------------
3668:
3669: UPDATE AP_INVOICE_LINES AIL
3670: SET AIL.base_amount = DECODE(p_base_currency_code, p_invoice_currency_code,
3671: NULL,
3672: ap_utilities_pkg.ap_round_currency(
3673: amount * p_exchange_rate,

Line 3737: FROM AP_INVOICE_LINES

3733: IF l_rounded_amt <> 0 THEN
3734: -- get the existing base amount for the selected line
3735: select base_amount
3736: INTO l_base_amt
3737: FROM AP_INVOICE_LINES
3738: WHERE invoice_id = p_invoice_id
3739: AND line_number = l_round_inv_line_numbers(i);
3740:
3741: -- get the calculated adjusted base amount and rounding amount

Line 3749: UPDATE AP_INVOICE_LINES

3745: p_rounding_amt => l_modified_line_rounding_amt,
3746: p_next_line_rounding_amt => l_rounded_amt);
3747:
3748: -- update the calculatd base amount, rounding amount
3749: UPDATE AP_INVOICE_LINES
3750: SET base_amount = l_base_amt,
3751: rounding_amt = ABS( NVL(l_modified_line_rounding_amt, 0) ),
3752: last_update_date = SYSDATE,
3753: last_updated_by = FND_GLOBAL.user_id,

Line 3825: l_round_dist_id_list AP_INVOICE_LINES_PKG.distribution_id_tab_type; --6892789

3821: l_debug_context VARCHAR2(2000);
3822:
3823: l_base_amt NUMBER; --6892789
3824: l_modified_dist_rounding_amt NUMBER; --6892789
3825: l_round_dist_id_list AP_INVOICE_LINES_PKG.distribution_id_tab_type; --6892789
3826:
3827: BEGIN
3828:
3829: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||

Line 3869: l_round_amt_exists := AP_INVOICE_LINES_PKG.round_base_amts(

3865: adjust dist base amount upto zero and adjust the remaing amount in another
3866: distribution having next max amount */
3867:
3868: -- get the distributions which can be adjusted
3869: l_round_amt_exists := AP_INVOICE_LINES_PKG.round_base_amts(
3870: x_invoice_id => p_invoice_id,
3871: x_line_number => p_invoice_line_number,
3872: x_reporting_ledger_id => NULL,
3873: x_round_dist_id_list => l_round_dist_id_list,

Line 4055: FROM ap_invoices_all AI, ap_invoice_lines_all AIL

4051: -- in the invoice. The prepaid amount will include taxes.
4052:
4053: CURSOR Prepay_Var_Cur IS
4054: SELECT AI.invoice_amount, (0 - sum(nvl(AIL.amount,0)))
4055: FROM ap_invoices_all AI, ap_invoice_lines_all AIL
4056: WHERE AI.invoice_id = p_invoice_id
4057: AND AIL.invoice_id = AI.invoice_id
4058: AND AIL.invoice_includes_prepay_flag = 'N'
4059: AND AIL.line_type_lookup_code IN ('PREPAY', 'TAX')

Line 4297: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail

4293: -- in the invoice
4294: CURSOR c_non_awt_dists_segs is
4295: SELECT ap_utilities_pkg.get_auto_offsets_segments(
4296: aid.dist_code_combination_id)
4297: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail
4298: WHERE ail.invoice_id = p_invoice_id
4299: AND ail.invoice_id = aid.invoice_id
4300: AND ail.line_number = aid.invoice_line_number
4301: AND ((aid.line_type_lookup_code not in ('AWT','PREPAY')

Line 5808: ap_invoice_lines ail

5804: aid.last_updated_by user_id,
5805: aid.last_update_login last_update_login,
5806: l_curr_calling_sequence calling_sequence
5807: FROM ap_invoice_distributions aid,
5808: ap_invoice_lines ail
5809: WHERE aid.invoice_id = p_invoice_id
5810: AND ail.invoice_id = aid.invoice_id
5811: AND ail.line_number = aid.invoice_line_number
5812: --bugfix:5609186

Line 5876: FROM ap_invoice_lines

5872: ------------------------------------------------------------
5873: BEGIN
5874: SELECT 'Y'
5875: INTO l_prepayment_app_exists
5876: FROM ap_invoice_lines
5877: WHERE invoice_id = p_invoice_id
5878: AND line_type_lookup_code = 'PREPAY'
5879: AND rownum < 2;
5880: EXCEPTION

Line 5932: FROM ap_invoice_lines ail

5928:
5929: IF (p_exclude_freight_from_disc = 'Y') THEN
5930: SELECT NVL(SUM(nvl(ail.amount,0)),0)
5931: INTO l_total_freight_amount
5932: FROM ap_invoice_lines ail
5933: WHERE ail.invoice_id = p_invoice_id
5934: AND ail.line_type_lookup_code = 'FREIGHT'
5935: AND nvl(ail.discarded_flag,'N') <> 'Y';
5936: ELSE

Line 6001: FROM ap_invoice_lines_all ail,ap_invoice_distributions_all aid

5997: --bugfix:5638734
5998: -- Get the exculusive tax amount for the prepay appln line.
5999: SELECT sum(aid.amount)
6000: INTO l_prepay_excl_tax_amt
6001: FROM ap_invoice_lines_all ail,ap_invoice_distributions_all aid
6002: WHERE ail.line_type_lookup_code='TAX'
6003: AND ail.invoice_id=p_invoice_id
6004: AND aid.invoice_id=ail.invoice_id
6005: AND aid.invoice_line_number=ail.line_number

Line 7013: UPDATE AP_INVOICE_LINES

7009: -------------------------------------------
7010:
7011: IF (nvl(p_generate_permanent,'N') = 'Y') then
7012: BEGIN
7013: UPDATE AP_INVOICE_LINES
7014: SET GENERATE_DISTS = 'D'
7015: WHERE invoice_id = p_invoice_line_rec.invoice_id
7016: AND line_number = p_invoice_line_rec.line_number;
7017: EXCEPTION

Line 7259: from ap_invoice_lines_all ail

7255: AND ai.validation_request_id IS NULL
7256: /*bug 7029877 Invoice saved but not submitted*/
7257: AND ai.approval_ready_flag <>'S'
7258: AND EXISTS (select ail.invoice_id
7259: from ap_invoice_lines_all ail
7260: where ail.invoice_id = ai.invoice_id) ;
7261:
7262: -- bug 6351170 -Added below if condition - Return if there are no invoices to process
7263: IF sql%rowcount = 0 THEN

Line 7474: ' FROM AP_INVOICE_LINES AIL '||

7470: ' )'||
7471: ' ) '||
7472: ' OR EXISTS '||
7473: ' (SELECT 1 '||
7474: ' FROM AP_INVOICE_LINES AIL '||
7475: ' WHERE AIL.INVOICE_ID = AI.INVOICE_ID '||
7476: ' AND AI.CANCELLED_DATE IS NULL '||
7477: ' AND NVL(AIL.DISCARDED_FLAG, ''N'') <> ''Y'' '||
7478: ' AND NVL(AIL.CANCELLED_FLAG, ''N'') <> ''Y'' '||

Line 8512: FROM ap_invoice_lines_all ail

8508: BEGIN
8509:
8510: SELECT 'Y'
8511: INTO l_not_exist_nond_line
8512: FROM ap_invoice_lines_all ail
8513: WHERE ail.invoice_id = p_invoice_rec.invoice_id
8514: AND nvl(ail.generate_dists, 'N') <> 'D'
8515: AND rownum < 2;
8516:

Line 8592: FROM ap_invoice_lines_all

8588: ----------------------------------------------------------------
8589:
8590: SELECT nvl(prorate_across_all_items,'N')
8591: INTO l_prorate_across_all_items
8592: FROM ap_invoice_lines_all
8593: WHERE invoice_id = t_inv_lines_table(i).invoice_id
8594: AND line_number = t_inv_lines_table(i).line_number;
8595:
8596: IF (l_prorate_across_all_items='Y') then

Line 8678: IF (ap_invoice_lines_utility_pkg.get_approval_status

8674: (P_Invoice_Id => t_inv_lines_table(i).invoice_id,
8675: P_Invoice_Line_Number => t_inv_lines_table(i).line_number);
8676:
8677: IF l_recouped_amount <> 0 THEN
8678: IF (ap_invoice_lines_utility_pkg.get_approval_status
8679: ( p_invoice_id => t_inv_lines_table(i).invoice_id
8680: ,p_line_number => t_inv_lines_table(i).line_number) = 'NEVER APPROVED') THEN
8681:
8682: ----------------------------------------------------------------