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_PREPAY_PKG dependencies on AP_PREPAY_UTILS_PKG

Line 963: AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining

959: CURSOR C_INV_LEVEL_APPLY (cv_prepay_invoice_id IN NUMBER)
960: IS
961: SELECT ai.invoice_id,
962: ail.line_number,
963: AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining
964: (ail.invoice_id,
965: ail.line_number)
966: FROM ap_invoices_all ai,
967: ap_invoice_lines_all ail

Line 970: AND AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining

966: FROM ap_invoices_all ai,
967: ap_invoice_lines_all ail
968: WHERE ai.invoice_id = cv_prepay_invoice_id
969: AND ail.invoice_id = ai.invoice_id
970: AND AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining
971: (ail.invoice_id,
972: ail.line_number) > 0
973: AND ail.line_type_lookup_code = 'ITEM'
974: AND NVL(ail.discarded_flag,'N') <> 'Y'

Line 984: AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining

980: CURSOR C_VND_LEVEL_APPLY (cv_vendor_id IN NUMBER)
981: IS
982: SELECT ai.invoice_id,
983: ail.line_number,
984: AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining
985: (ail.invoice_id,
986: ail.line_number)
987: FROM ap_invoices ai,
988: ap_invoice_lines ail

Line 994: AND AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining

990: AND ai.invoice_type_lookup_code = 'PREPAYMENT'
991: AND ai.payment_status_flag = 'Y'
992: AND NVL(ai.earliest_settlement_date,SYSDATE+1) <= SYSDATE
993: AND ail.invoice_id = ai.invoice_id
994: AND AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining
995: (ail.invoice_id,
996: ail.line_number) > 0
997: AND ail.line_type_lookup_code = 'ITEM'
998: AND NVL(ail.discarded_flag,'N') <> 'Y'

Line 1016: l_is_line_locked := AP_PREPAY_UTILS_PKG.Is_Line_Locked (

1012:
1013: -- Lock the line if not locked and populate the application info
1014: -- into a PL/SQL table.
1015:
1016: l_is_line_locked := AP_PREPAY_UTILS_PKG.Is_Line_Locked (
1017: p_prepay_invoice_id,
1018: p_prepay_line_num,
1019: l_request_id);
1020:

Line 1023: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(

1019: l_request_id);
1020:
1021: IF l_is_line_locked = 'UNLOCKED' THEN
1022:
1023: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(
1024: p_prepay_invoice_id,
1025: p_prepay_line_num,
1026: l_request_id);
1027:

Line 1050: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(

1046: EXIT WHEN C_INV_LEVEL_APPLY%NOTFOUND;
1047:
1048: IF l_apply_amount_remaining <= l_cursor_amount_remaining THEN
1049:
1050: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(
1051: p_prepay_invoice_id,
1052: p_prepay_line_num,
1053: l_request_id);
1054:

Line 1063: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(

1059: p_prepay_appl_info(l_loop_counter).prepay_apply_amount := l_apply_amount_remaining;
1060:
1061: EXIT;
1062: ELSE
1063: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(
1064: p_prepay_invoice_id,
1065: p_prepay_line_num,
1066: l_request_id);
1067:

Line 1101: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(

1097: EXIT WHEN C_VND_LEVEL_APPLY%NOTFOUND;
1098:
1099: IF l_apply_amount_remaining <= l_cursor_amount_remaining THEN
1100:
1101: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(
1102: p_prepay_invoice_id,
1103: p_prepay_line_num,
1104: l_request_id);
1105:

Line 1114: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(

1110: p_prepay_appl_info(l_loop_counter).prepay_apply_amount := l_apply_amount_remaining;
1111:
1112: EXIT;
1113: ELSE
1114: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(
1115: p_prepay_invoice_id,
1116: p_prepay_line_num,
1117: l_request_id);
1118:

Line 1529: AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining(

1525: SELECT ail.amount,
1526: NVL(ail.base_amount,0),
1527: /*
1528: Decode(p_calling_mode,'PREPAYMENT APPLICATION',
1529: AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining(
1530: ail.invoice_id,
1531: ail.line_number),
1532: 'RECOUPMENT',
1533: AP_Prepay_Utils_Pkg.get_ln_prep_amt_remain_recoup(

Line 1533: AP_Prepay_Utils_Pkg.get_ln_prep_amt_remain_recoup(

1529: AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining(
1530: ail.invoice_id,
1531: ail.line_number),
1532: 'RECOUPMENT',
1533: AP_Prepay_Utils_Pkg.get_ln_prep_amt_remain_recoup(
1534: ail.invoice_id,
1535: ail.line_number)
1536: ),
1537: */

Line 1538: AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining(

1534: ail.invoice_id,
1535: ail.line_number)
1536: ),
1537: */
1538: AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining(
1539: ail.invoice_id,
1540: ail.line_number),
1541: ail.quantity_invoiced,
1542: ail.pa_quantity,

Line 1940: l_result:= AP_PREPAY_UTILS_PKG.Unlock_Line(

1936: p_error_message);
1937:
1938: IF l_dummy = FALSE THEN
1939:
1940: l_result:= AP_PREPAY_UTILS_PKG.Unlock_Line(
1941: p_prepay_invoice_id,
1942: p_prepay_line_num);
1943:
1944: RETURN (FALSE);

Line 1994: l_result:= AP_PREPAY_UTILS_PKG.Unlock_Line(

1990: WHEN NO_DATA_FOUND THEN
1991: -- If there is a no_data_found in this case the PREPAY
1992: -- line was not created. End the process and unlock the
1993: -- PREPAYMENT line
1994: l_result:= AP_PREPAY_UTILS_PKG.Unlock_Line(
1995: p_prepay_invoice_id,
1996: p_prepay_line_num);
1997:
1998: RETURN (FALSE);

Line 2019: AP_Prepay_Utils_PKG.get_ln_pp_amt_remaining_no_tax(

2015: --Bugfix: 5577707 added the ABS for l_inclusive_tax_amount.
2016: l_apply_amount_no_tax_incl := l_apply_amount - abs(l_inclusive_tax_amount);
2017:
2018: l_ppay_ln_amt_remaining_no_tax :=
2019: AP_Prepay_Utils_PKG.get_ln_pp_amt_remaining_no_tax(
2020: p_prepay_invoice_id,
2021: p_prepay_line_num);
2022:
2023: END IF;

Line 2427: l_result:= AP_PREPAY_UTILS_PKG.Unlock_Line(

2423: p_error_message);
2424:
2425: IF l_dummy = FALSE THEN
2426:
2427: l_result:= AP_PREPAY_UTILS_PKG.Unlock_Line(
2428: p_prepay_invoice_id,
2429: p_prepay_line_num);
2430:
2431: RETURN (FALSE);

Line 2578: l_result:= AP_PREPAY_UTILS_PKG.Unlock_Line(

2574: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2575: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2576: END IF;
2577:
2578: l_result:= AP_PREPAY_UTILS_PKG.Unlock_Line(
2579: p_prepay_invoice_id,
2580: p_prepay_line_num);
2581:
2582: RETURN (FALSE);

Line 2611: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(

2607: p_error_message);
2608:
2609: IF l_dummy = FALSE THEN
2610:
2611: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(
2612: p_prepay_invoice_id,
2613: p_prepay_line_num);
2614:
2615: RETURN (FALSE);

Line 2687: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(

2683: p_calling_mode,
2684: p_error_message);
2685:
2686: IF l_dummy = FALSE THEN
2687: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(
2688: p_prepay_invoice_id,
2689: p_prepay_line_num);
2690:
2691: RETURN (FALSE);

Line 2736: -- l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(

2732: -- l_current_calling_sequence,
2733: -- p_error_message);
2734:
2735: -- IF l_dummy = FALSE THEN
2736: -- l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(
2737: -- p_prepay_invoice_id,
2738: -- p_prepay_line_num);
2739: -- RETURN (FALSE);
2740: -- END IF;

Line 2752: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(

2748: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2749: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2750: END IF;
2751:
2752: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(
2753: p_prepay_invoice_id,
2754: p_prepay_line_num);
2755:
2756: -- ===========================================================

Line 2769: l_result:= AP_PREPAY_UTILS_PKG.Unlock_Line(

2765: RETURN (TRUE);
2766:
2767: EXCEPTION
2768: WHEN tax_exception THEN
2769: l_result:= AP_PREPAY_UTILS_PKG.Unlock_Line(
2770: p_prepay_invoice_id,
2771: p_prepay_line_num);
2772:
2773: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

Line 2807: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(

2803: END IF;
2804:
2805: END IF;
2806:
2807: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(
2808: p_prepay_invoice_id,
2809: p_prepay_line_num);
2810: RETURN (FALSE);
2811: END Apply_Prepay_Line;

Line 3207: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(

3203: END IF;
3204:
3205: END IF;
3206:
3207: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(
3208: p_prepay_invoice_id,
3209: p_prepay_line_num);
3210: RETURN (FALSE);
3211: END Insert_Prepay_Line;

Line 3769: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(

3765: END IF;
3766:
3767: END IF;
3768:
3769: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(
3770: p_prepay_invoice_id,
3771: p_prepay_line_num);
3772: RETURN (FALSE);
3773:

Line 3976: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(

3972: END IF;
3973:
3974: END IF;
3975:
3976: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(
3977: p_prepay_invoice_id,
3978: p_prepay_line_num);
3979: RETURN (FALSE);
3980:

Line 4253: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(

4249: END IF;
4250:
4251: END IF;
4252:
4253: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(
4254: p_prepay_invoice_id,
4255: p_prepay_line_num);
4256:
4257: RETURN (FALSE);

Line 4501: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(

4497: END IF;
4498:
4499: END IF;
4500:
4501: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(
4502: p_prepay_invoice_id,
4503: p_prepay_line_num);
4504:
4505: RETURN (FALSE);

Line 4817: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(

4813: END IF;
4814:
4815: END IF;
4816:
4817: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(
4818: p_prepay_invoice_id,
4819: p_prepay_line_num);
4820:
4821: RETURN (FALSE);

Line 4871: AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining

4867:
4868: CURSOR c_case_c_apply(cv_prepay_invoice_id NUMBER) IS
4869: SELECT ai.invoice_num,
4870: ail.line_number,
4871: AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining
4872: (ail.invoice_id,
4873: ail.line_number)
4874: FROM ap_invoices ai,
4875: ap_invoice_lines ail

Line 4878: AND AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining

4874: FROM ap_invoices ai,
4875: ap_invoice_lines ail
4876: WHERE ai.invoice_id = cv_prepay_invoice_id
4877: AND ail.invoice_id = ai.invoice_id
4878: AND AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining
4879: (ail.invoice_id,
4880: ail.line_number) > 0
4881: AND ail.line_type_lookup_code = 'ITEM'
4882: AND NVL(ail.discarded_flag,'N') <> 'Y'