APPS.FV_DUE_DATE_CALCULATION dependencies on AP_PAYMENT_SCHEDULES

Line 28: ap_payment_schedules aps

24: ap_terms apt,
25: ap_terms_lines apl,
26: fv_terms_types fvt,
27: --ap_invoice_distributions aid,
28: ap_payment_schedules aps
29: WHERE api.cancelled_amount IS NULL
30: AND api.invoice_type_lookup_code <> 'INTEREST'
31: AND ap_invoices_pkg.get_approval_status(
32: api.invoice_id,

Line 52: FROM ap_payment_schedules aps2

48: AND terms_type = 'PROMPT PAY'
49: --AND api.invoice_id = aid.invoice_id
50: --AND aid.match_status_flag = 'A'
51: AND 1 = ( SELECT COUNT(*)
52: FROM ap_payment_schedules aps2
53: WHERE aps2.invoice_id = api.invoice_id
54: AND checkrun_id IS NULL) -- modified for bug 5454497
55: AND 1 = ( SELECT COUNT(*)
56: FROM ap_terms_lines

Line 248: v_second_disc_date ap_payment_schedules.second_discount_date%TYPE;

244: v_exists_2_dis_date date;
245: v_exists_3_dis_date date;
246: l_module_name VARCHAR2(200);
247: l_save_date DATE;
248: v_second_disc_date ap_payment_schedules.second_discount_date%TYPE;
249: v_third_disc_date ap_payment_schedules.third_discount_date%TYPE;
250: v_discount_days_2 ap_terms_lines.discount_days_2%TYPE;
251: v_discount_days_3 ap_terms_lines.discount_days_3%TYPE;
252: v_new_second_disc_date date;

Line 249: v_third_disc_date ap_payment_schedules.third_discount_date%TYPE;

245: v_exists_3_dis_date date;
246: l_module_name VARCHAR2(200);
247: l_save_date DATE;
248: v_second_disc_date ap_payment_schedules.second_discount_date%TYPE;
249: v_third_disc_date ap_payment_schedules.third_discount_date%TYPE;
250: v_discount_days_2 ap_terms_lines.discount_days_2%TYPE;
251: v_discount_days_3 ap_terms_lines.discount_days_3%TYPE;
252: v_new_second_disc_date date;
253: v_new_third_disc_date date;

Line 313: /* Get the original Due date from ap_payment_schedules */

309: v_third_disc_date,
310: v_goods_rec_date,
311: v_invoice_date;
312: EXIT WHEN c1_main_select%NOTFOUND;
313: /* Get the original Due date from ap_payment_schedules */
314:
315: --fnd_file.put_line(FND_FILE.LOG,'v_goods_rec_date = '||v_goods_rec_date);
316: SELECT due_date
317: INTO v_org_due_date

Line 318: FROM ap_payment_schedules

314:
315: --fnd_file.put_line(FND_FILE.LOG,'v_goods_rec_date = '||v_goods_rec_date);
316: SELECT due_date
317: INTO v_org_due_date
318: FROM ap_payment_schedules
319: WHERE invoice_id = v_invoice_id;
320:
321: v_total_due_date := v_org_due_date;
322: v_total_quantity := 0;

Line 918: UPDATE ap_payment_schedules

914: IF( v_due_date_flag = 'Y' OR v_disc_date_flag = 'Y') THEN
915: IF (x_run_mode = 'F') THEN
916: x_err_code := 6;
917:
918: UPDATE ap_payment_schedules
919: SET due_date = DECODE(v_due_date_flag,'Y', v_total_due_date,
920: due_date), discount_date = DECODE(v_disc_date_flag,
921: 'Y',v_new_discount_date,discount_date),
922: second_discount_date = decode(v_2_disc_date_flag,'Y',

Line 1036: errbuf := 'Update failed in ap_payment_schedules';

1032: ELSIF(x_err_code = 2) THEN
1033: errbuf := 'Receipt acceptance days is not defined in
1034: FINANCIAL_SYSTEM_PARAMETERS' ;
1035: ELSIF(x_err_code = 5) THEN
1036: errbuf := 'Update failed in ap_payment_schedules';
1037: ELSIF(x_err_code = 3) THEN
1038: errbuf := 'Constructive acceptence days is not defined in
1039: FV_TERMS_LINES';
1040: ELSIF(x_err_code = 6) THEN