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.JAI_AP_TDS_OLD_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 163: FROM ap_payment_schedules_all

159:
160: CURSOR cur_prnt_pay_priority -- 4333449
161: IS
162: SELECT payment_priority
163: FROM ap_payment_schedules_all
164: WHERE invoice_id = p_invoice_id;
165:
166: CURSOR cur_prnt_exchange_rate -- 4333449
167: IS

Line 216: ln_prnt_pay_priority ap_payment_schedules_all.payment_priority%TYPE; -- 4333449

212: v_out_original_prepay_amount number;
213: v_out_pay_curr_inv_amount number;
214: v_return_value boolean;
215: ln_invoice_id NUMBER; --4333449
216: ln_prnt_pay_priority ap_payment_schedules_all.payment_priority%TYPE; -- 4333449
217: ln_prnt_exchange_rate ap_invoices_all.exchange_rate%TYPE; --4333449
218: lv_invoice_num ap_invoices_interface.invoice_num%type; --rchandan for bug#4428980
219: lv_description ap_invoices_interface.description%type;--rchandan for bug#4428980
220: lv_lookup_type_code ap_invoices_interface.invoice_type_lookup_code%type;--rchandan for bug#4428980

Line 285: An update statement is written on ap_payment_schedules_all to update amount_remaining and gross_amount fields

281: 6. 26-MAR-2003 Vijay Shankar for Bug# 2869481, FileVersion# 615.4
282: when an invoice is cancelled, then related TDS invoices also gets cancelled. upon cancelling the tds invoice,
283: ap_invoice_payments_all should get updated
284: with amount_remaining as 0 which is not happening previously and fixed with this bug.
285: An update statement is written on ap_payment_schedules_all to update amount_remaining and gross_amount fields
286:
287: 7. 27-apr-2003 Aparajita for bug#2906202. Version#616.1
288: The negative distribution line in the TDS invoice, has the period name of the original distribution line it was reversing.
289: Added the check to populate the period name of the current accounting period.

Line 452: UPDATE ap_payment_schedules_all

448: AND vendor_id = vendor_rec.vendor_id
449: AND NVL(org_id, 0) = NVL(cancelled_invoices_rec.org_id, 0);
450:
451: -- cbabu for Bug# 2869481
452: UPDATE ap_payment_schedules_all
453: SET gross_amount = 0,
454: amount_remaining = 0
455: -- , inv_curr_gross_amount = 0
456: -- base applications is not updating this field when a standard invoice is cancelled. so not updating this field in our code also

Line 1108: FROM ap_payment_schedules_all

1104:
1105: CURSOR cur_prnt_pay_priority -- Ravi
1106: IS
1107: SELECT payment_priority
1108: FROM ap_payment_schedules_all
1109: WHERE invoice_id = p_invoice_id;
1110:
1111: CURSOR cur_prnt_exchange_rate -- Ravi
1112: IS

Line 1178: ln_prnt_pay_priority ap_payment_schedules_all.payment_priority%TYPE;

1174:
1175: v_prepay_dist_date ap_invoice_distributions_all.accounting_date%TYPE; -- bug 3112711 kpvs
1176:
1177: v_insertion_amount_tds_si NUMBER := 0; -- bug#3469847
1178: ln_prnt_pay_priority ap_payment_schedules_all.payment_priority%TYPE;
1179: ln_prnt_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1180: ln_tax_rate JAI_AP_TDS_INVOICES.tds_tax_rate%type;
1181: ln_tax_amount JAI_AP_TDS_INVOICES.tds_amount%type;
1182: ln_taxable_amount JAI_AP_TDS_INVOICES.invoice_amount%type;

Line 2047: FROM ap_payment_schedules_all

2043:
2044: CURSOR cur_prnt_pay_priority -- 4333449
2045: IS
2046: SELECT payment_priority
2047: FROM ap_payment_schedules_all
2048: WHERE invoice_id = p_invoice_id;
2049:
2050: CURSOR cur_prnt_exchange_rate -- 4333449
2051: IS

Line 2072: ln_prnt_pay_priority ap_payment_schedules_all.payment_priority%TYPE; -- 4333449

2068: -- following added by Aparajita on 07/07/2002 for bug 2439034
2069: v_ap_tds_cm_num ap_invoices_all.invoice_num%TYPE;
2070: v_ap_sup_inv_num ap_invoices_all.invoice_num%TYPE;
2071: v_prepay_dist_date ap_invoice_distributions_all.accounting_date%TYPE; -- bug 3112711 kpvs
2072: ln_prnt_pay_priority ap_payment_schedules_all.payment_priority%TYPE; -- 4333449
2073: ln_prnt_exchange_rate ap_invoices_all.exchange_rate%TYPE; --4333449
2074: ln_tax_rate JAI_AP_TDS_INVOICES.tds_tax_rate%type; -- 4333449
2075: ln_tax_amount JAI_AP_TDS_INVOICES.tds_amount%type; -- 4333449
2076: ln_taxable_amount JAI_AP_TDS_INVOICES.invoice_amount%type; -- 4333449