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_PAY_INVOICE_PKG dependencies on AP_PAYMENT_SCHEDULES

Line 200: * -- Step 2 : case for all : Update AP_PAYMENT_SCHEDULES

196: --
197: if (P_PAYMENT_MODE = 'PAY') then
198:
199: /*--------------------------------------------------------------------------
200: * -- Step 2 : case for all : Update AP_PAYMENT_SCHEDULES
201: * Call ap_pay_update_payment_schedules :
202: *
203: *--------------------------------------------------------------------------*/
204: ap_pay_invoice_pkg.ap_pay_update_payment_schedule(

Line 459: FROM ap_payment_schedules PS, ap_invoices AI

455: AI_exchange_rate,
456: AI_exchange_date,
457: AI_exchange_rate_type,
458: c_inv_currency_code
459: FROM ap_payment_schedules PS, ap_invoices AI
460: WHERE PS.invoice_id = P_invoice_id
461: AND PS.payment_num = P_payment_num
462: AND AI.invoice_id = P_invoice_id;
463:

Line 570: FROM ap_payment_schedules ps

566: nvl(PS.third_disc_amt_available,0)),
567: ps.gross_amount
568: INTO PS_disc_amt_available,
569: PS_gross_amount
570: FROM ap_payment_schedules ps
571: WHERE invoice_id = P_invoice_id
572: AND payment_num = P_payment_num;
573:
574: --

Line 1043: debug_info := 'Update ap_payment_schedules (pay)';

1039: if (P_PAYMENT_MODE = 'PAY') then
1040:
1041: if (P_REPLACE_FLAG = 'N') then
1042:
1043: debug_info := 'Update ap_payment_schedules (pay)';
1044:
1045: UPDATE ap_payment_schedules
1046: SET amount_remaining = amount_remaining - P_amount -
1047: NVL(P_discount_taken, 0),

Line 1045: UPDATE ap_payment_schedules

1041: if (P_REPLACE_FLAG = 'N') then
1042:
1043: debug_info := 'Update ap_payment_schedules (pay)';
1044:
1045: UPDATE ap_payment_schedules
1046: SET amount_remaining = amount_remaining - P_amount -
1047: NVL(P_discount_taken, 0),
1048: discount_amount_remaining = 0,
1049: payment_status_flag = DECODE(amount_remaining -

Line 1062: debug_info := 'Update ap_payment_schedules (reissue)';

1058: AND payment_num = P_payment_num;
1059:
1060: elsif (P_REPLACE_FLAG = 'Y') then
1061:
1062: debug_info := 'Update ap_payment_schedules (reissue)';
1063:
1064: UPDATE ap_payment_schedules
1065: SET last_update_date = P_last_update_date,
1066: last_updated_by = P_last_updated_by

Line 1064: UPDATE ap_payment_schedules

1060: elsif (P_REPLACE_FLAG = 'Y') then
1061:
1062: debug_info := 'Update ap_payment_schedules (reissue)';
1063:
1064: UPDATE ap_payment_schedules
1065: SET last_update_date = P_last_update_date,
1066: last_updated_by = P_last_updated_by
1067: WHERE invoice_id = P_invoice_id
1068: AND payment_num = P_payment_num;

Line 1076: debug_info := 'Update ap_payment_schedules (reverse, non-prepayment)';

1072: elsif (P_PAYMENT_MODE = 'REV') then
1073:
1074: if (P_REPLACE_FLAG = 'N') then
1075:
1076: debug_info := 'Update ap_payment_schedules (reverse, non-prepayment)';
1077:
1078: UPDATE ap_payment_schedules APS
1079: SET (amount_remaining
1080: , discount_amount_remaining

Line 1078: UPDATE ap_payment_schedules APS

1074: if (P_REPLACE_FLAG = 'N') then
1075:
1076: debug_info := 'Update ap_payment_schedules (reverse, non-prepayment)';
1077:
1078: UPDATE ap_payment_schedules APS
1079: SET (amount_remaining
1080: , discount_amount_remaining
1081: , payment_status_flag
1082: , last_update_date

Line 1116: debug_info := 'Update ap_payment_schedules (reverse, prepayment)';

1112: --Split the UPDATE into two. First for non-prepayment as above
1113: --and next for PREPAYMENT as below
1114: --
1115:
1116: debug_info := 'Update ap_payment_schedules (reverse, prepayment)';
1117:
1118: UPDATE ap_payment_schedules APS
1119: SET (amount_remaining
1120: , payment_status_flag

Line 1118: UPDATE ap_payment_schedules APS

1114: --
1115:
1116: debug_info := 'Update ap_payment_schedules (reverse, prepayment)';
1117:
1118: UPDATE ap_payment_schedules APS
1119: SET (amount_remaining
1120: , payment_status_flag
1121: , last_update_date
1122: , last_updated_by)

Line 1140: debug_info := 'Update ap_payment_schedules (replace)';

1136: AND AI.invoice_type_lookup_code = 'PREPAYMENT');
1137:
1138: elsif (P_REPLACE_FLAG = 'Y') then
1139:
1140: debug_info := 'Update ap_payment_schedules (replace)';
1141:
1142: UPDATE ap_payment_schedules
1143: SET last_update_date = P_last_update_date,
1144: last_updated_by = P_last_updated_by

Line 1142: UPDATE ap_payment_schedules

1138: elsif (P_REPLACE_FLAG = 'Y') then
1139:
1140: debug_info := 'Update ap_payment_schedules (replace)';
1141:
1142: UPDATE ap_payment_schedules
1143: SET last_update_date = P_last_update_date,
1144: last_updated_by = P_last_updated_by
1145: WHERE invoice_id = P_invoice_id
1146: AND payment_num = P_payment_num;

Line 1206: It is used to update the ap_invoices table and ap_payment_schedules

1202:
1203:
1204: /****************************************************************
1205: The procedure was created due to bugs 467167, 661795 .
1206: It is used to update the ap_invoices table and ap_payment_schedules
1207: table when reversing an invoice payment. It is called from the
1208: payment workbench.
1209: ******************************************************************/
1210:

Line 1243: -- Update ap_payment_schedules

1239: -- statment for ap_pyment_schedules has been moved from here to after the update
1240: -- statment for ap_pyment_schedules in this procedure.
1241:
1242:
1243: -- Update ap_payment_schedules
1244: --
1245: UPDATE ap_payment_schedules
1246: SET amount_remaining = amount_remaining + P_amount +
1247: nvl(P_discount,0),

Line 1245: UPDATE ap_payment_schedules

1241:
1242:
1243: -- Update ap_payment_schedules
1244: --
1245: UPDATE ap_payment_schedules
1246: SET amount_remaining = amount_remaining + P_amount +
1247: nvl(P_discount,0),
1248: discount_amount_remaining = 0,
1249: payment_status_flag = DECODE(amount_remaining +

Line 1261: -- in AP_INVOICES after ap_payment_schedules is updates. This will cause

1257: WHERE invoice_id = P_invoice_id
1258: AND payment_num = P_payment_line_number;
1259:
1260: -- Bug 1544895 - Moved the following update statement so that it inserts values
1261: -- in AP_INVOICES after ap_payment_schedules is updates. This will cause
1262: -- the payment_status_flag in AP_INVOICES to have the correct value.
1263:
1264: -- Update ap_invoices
1265: