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 974: AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining

970: CURSOR C_INV_LEVEL_APPLY (cv_prepay_invoice_id IN NUMBER)
971: IS
972: SELECT ai.invoice_id,
973: ail.line_number,
974: AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining
975: (ail.invoice_id,
976: ail.line_number)
977: FROM ap_invoices_all ai,
978: ap_invoice_lines_all ail

Line 981: AND AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining

977: FROM ap_invoices_all ai,
978: ap_invoice_lines_all ail
979: WHERE ai.invoice_id = cv_prepay_invoice_id
980: AND ail.invoice_id = ai.invoice_id
981: AND AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining
982: (ail.invoice_id,
983: ail.line_number) > 0
984: AND ail.line_type_lookup_code = 'ITEM'
985: AND NVL(ail.discarded_flag,'N') <> 'Y'

Line 998: AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining

994: -- Bug 6394865
995: IS
996: SELECT ai.invoice_id,
997: ail.line_number,
998: AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining
999: (ail.invoice_id,
1000: ail.line_number)
1001: FROM ap_invoices ai,
1002: ap_invoice_lines ail

Line 1008: AND AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining

1004: AND ai.invoice_type_lookup_code = 'PREPAYMENT'
1005: AND ai.payment_status_flag = 'Y'
1006: AND NVL(ai.earliest_settlement_date,SYSDATE+1) <= SYSDATE
1007: AND ail.invoice_id = ai.invoice_id
1008: AND AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining
1009: (ail.invoice_id,
1010: ail.line_number) > 0
1011: AND ail.line_type_lookup_code = 'ITEM'
1012: AND NVL(ail.discarded_flag,'N') <> 'Y'

Line 1032: l_is_line_locked := AP_PREPAY_UTILS_PKG.Is_Line_Locked (

1028:
1029: -- Lock the line if not locked and populate the application info
1030: -- into a PL/SQL table.
1031:
1032: l_is_line_locked := AP_PREPAY_UTILS_PKG.Is_Line_Locked (
1033: p_prepay_invoice_id,
1034: p_prepay_line_num,
1035: l_request_id);
1036:

Line 1039: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(

1035: l_request_id);
1036:
1037: IF l_is_line_locked = 'UNLOCKED' THEN
1038:
1039: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(
1040: p_prepay_invoice_id,
1041: p_prepay_line_num,
1042: l_request_id);
1043:

Line 1066: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(

1062: EXIT WHEN C_INV_LEVEL_APPLY%NOTFOUND;
1063:
1064: IF l_apply_amount_remaining <= l_cursor_amount_remaining THEN
1065:
1066: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(
1067: p_prepay_invoice_id,
1068: p_prepay_line_num,
1069: l_request_id);
1070:

Line 1079: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(

1075: p_prepay_appl_info(l_loop_counter).prepay_apply_amount := l_apply_amount_remaining;
1076:
1077: EXIT;
1078: ELSE
1079: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(
1080: p_prepay_invoice_id,
1081: p_prepay_line_num,
1082: l_request_id);
1083:

Line 1122: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(

1118: EXIT WHEN C_VND_LEVEL_APPLY%NOTFOUND;
1119:
1120: IF l_apply_amount_remaining <= l_cursor_amount_remaining THEN
1121:
1122: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(
1123: p_prepay_invoice_id,
1124: p_prepay_line_num,
1125: l_request_id);
1126:

Line 1135: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(

1131: p_prepay_appl_info(l_loop_counter).prepay_apply_amount := l_apply_amount_remaining;
1132:
1133: EXIT;
1134: ELSE
1135: l_lock_result := AP_PREPAY_UTILS_PKG.Lock_Line(
1136: p_prepay_invoice_id,
1137: p_prepay_line_num,
1138: l_request_id);
1139:

Line 1555: AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining(

1551: SELECT ail.amount,
1552: NVL(ail.base_amount,0),
1553: /*
1554: Decode(p_calling_mode,'PREPAYMENT APPLICATION',
1555: AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining(
1556: ail.invoice_id,
1557: ail.line_number),
1558: 'RECOUPMENT',
1559: AP_Prepay_Utils_Pkg.get_ln_prep_amt_remain_recoup(

Line 1559: AP_Prepay_Utils_Pkg.get_ln_prep_amt_remain_recoup(

1555: AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining(
1556: ail.invoice_id,
1557: ail.line_number),
1558: 'RECOUPMENT',
1559: AP_Prepay_Utils_Pkg.get_ln_prep_amt_remain_recoup(
1560: ail.invoice_id,
1561: ail.line_number)
1562: ),
1563: */

Line 1564: AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining(

1560: ail.invoice_id,
1561: ail.line_number)
1562: ),
1563: */
1564: AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining(
1565: ail.invoice_id,
1566: ail.line_number),
1567: ail.quantity_invoiced,
1568: ail.pa_quantity,

Line 2020: l_result:= AP_PREPAY_UTILS_PKG.Unlock_Line(

2016: p_error_message);
2017:
2018: IF l_dummy = FALSE THEN
2019:
2020: l_result:= AP_PREPAY_UTILS_PKG.Unlock_Line(
2021: p_prepay_invoice_id,
2022: p_prepay_line_num);
2023:
2024: RETURN (FALSE);

Line 2074: l_result:= AP_PREPAY_UTILS_PKG.Unlock_Line(

2070: WHEN NO_DATA_FOUND THEN
2071: -- If there is a no_data_found in this case the PREPAY
2072: -- line was not created. End the process and unlock the
2073: -- PREPAYMENT line
2074: l_result:= AP_PREPAY_UTILS_PKG.Unlock_Line(
2075: p_prepay_invoice_id,
2076: p_prepay_line_num);
2077:
2078: RETURN (FALSE);

Line 2100: AP_Prepay_Utils_PKG.get_ln_pp_amt_remaining_no_tax(

2096: --Bugfix: 5577707 added the ABS for l_inclusive_tax_amount.
2097: l_apply_amount_no_tax_incl := l_apply_amount - abs(l_inclusive_tax_amount);
2098:
2099: l_ppay_ln_amt_remaining_no_tax :=
2100: AP_Prepay_Utils_PKG.get_ln_pp_amt_remaining_no_tax(
2101: p_prepay_invoice_id,
2102: p_prepay_line_num);
2103:
2104: END IF;

Line 2673: l_result:= AP_PREPAY_UTILS_PKG.Unlock_Line(

2669: p_error_message);
2670:
2671: IF l_dummy = FALSE THEN
2672:
2673: l_result:= AP_PREPAY_UTILS_PKG.Unlock_Line(
2674: p_prepay_invoice_id,
2675: p_prepay_line_num);
2676:
2677: RETURN (FALSE);

Line 2841: l_result:= AP_PREPAY_UTILS_PKG.Unlock_Line(

2837: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2838: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2839: END IF;
2840:
2841: l_result:= AP_PREPAY_UTILS_PKG.Unlock_Line(
2842: p_prepay_invoice_id,
2843: p_prepay_line_num);
2844:
2845: RETURN (FALSE);

Line 2874: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(

2870: p_error_message);
2871:
2872: IF l_dummy = FALSE THEN
2873:
2874: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(
2875: p_prepay_invoice_id,
2876: p_prepay_line_num);
2877:
2878: RETURN (FALSE);

Line 2971: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(

2967: p_calling_mode,
2968: p_error_message);
2969:
2970: IF l_dummy = FALSE THEN
2971: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(
2972: p_prepay_invoice_id,
2973: p_prepay_line_num);
2974:
2975: RETURN (FALSE);

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

3016: -- l_current_calling_sequence,
3017: -- p_error_message);
3018:
3019: -- IF l_dummy = FALSE THEN
3020: -- l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(
3021: -- p_prepay_invoice_id,
3022: -- p_prepay_line_num);
3023: -- RETURN (FALSE);
3024: -- END IF;

Line 3036: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(

3032: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3033: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3034: END IF;
3035:
3036: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(
3037: p_prepay_invoice_id,
3038: p_prepay_line_num);
3039:
3040: -- ===========================================================

Line 3053: l_result:= AP_PREPAY_UTILS_PKG.Unlock_Line(

3049: RETURN (TRUE);
3050:
3051: EXCEPTION
3052: WHEN tax_exception THEN
3053: l_result:= AP_PREPAY_UTILS_PKG.Unlock_Line(
3054: p_prepay_invoice_id,
3055: p_prepay_line_num);
3056:
3057: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

Line 3091: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(

3087: END IF;
3088:
3089: END IF;
3090:
3091: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(
3092: p_prepay_invoice_id,
3093: p_prepay_line_num);
3094: RETURN (FALSE);
3095: END Apply_Prepay_Line;

Line 3493: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(

3489: END IF;
3490:
3491: END IF;
3492:
3493: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(
3494: p_prepay_invoice_id,
3495: p_prepay_line_num);
3496: RETURN (FALSE);
3497: END Insert_Prepay_Line;

Line 4053: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(

4049: END IF;
4050:
4051: END IF;
4052:
4053: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(
4054: p_prepay_invoice_id,
4055: p_prepay_line_num);
4056: RETURN (FALSE);
4057:

Line 4142: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(

4138: END IF;
4139:
4140: END IF;
4141:
4142: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(
4143: p_prepay_invoice_id,
4144: p_prepay_line_num);
4145: RETURN (FALSE);
4146:

Line 4419: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(

4415: END IF;
4416:
4417: END IF;
4418:
4419: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(
4420: p_prepay_invoice_id,
4421: p_prepay_line_num);
4422:
4423: RETURN (FALSE);

Line 4719: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(

4715: END IF;
4716:
4717: END IF;
4718:
4719: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(
4720: p_prepay_invoice_id,
4721: p_prepay_line_num);
4722:
4723: RETURN (FALSE);

Line 5051: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(

5047: END IF;
5048:
5049: END IF;
5050:
5051: l_result := AP_PREPAY_UTILS_PKG.Unlock_Line(
5052: p_prepay_invoice_id,
5053: p_prepay_line_num);
5054:
5055: RETURN (FALSE);

Line 5105: AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining

5101:
5102: CURSOR c_case_c_apply(cv_prepay_invoice_id NUMBER) IS
5103: SELECT ai.invoice_num,
5104: ail.line_number,
5105: AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining
5106: (ail.invoice_id,
5107: ail.line_number)
5108: FROM ap_invoices ai,
5109: ap_invoice_lines ail

Line 5112: AND AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining

5108: FROM ap_invoices ai,
5109: ap_invoice_lines ail
5110: WHERE ai.invoice_id = cv_prepay_invoice_id
5111: AND ail.invoice_id = ai.invoice_id
5112: AND AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining
5113: (ail.invoice_id,
5114: ail.line_number) > 0
5115: AND ail.line_type_lookup_code = 'ITEM'
5116: AND NVL(ail.discarded_flag,'N') <> 'Y'