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 247: v_second_disc_date ap_payment_schedules.second_discount_date%TYPE;

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

Line 248: v_third_disc_date ap_payment_schedules.third_discount_date%TYPE;

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

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

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

Line 317: FROM ap_payment_schedules

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

Line 906: UPDATE ap_payment_schedules

902: IF( v_due_date_flag = 'Y' OR v_disc_date_flag = 'Y') THEN
903: IF (x_run_mode = 'F') THEN
904: x_err_code := 6;
905:
906: UPDATE ap_payment_schedules
907: SET due_date = DECODE(v_due_date_flag,'Y', v_total_due_date,
908: due_date), discount_date = DECODE(v_disc_date_flag,
909: 'Y',v_new_discount_date,discount_date),
910: second_discount_date = decode(v_2_disc_date_flag,'Y',

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

1014: ELSIF(x_err_code = 2) THEN
1015: errbuf := 'Receipt acceptance days is not defined in
1016: FINANCIAL_SYSTEM_PARAMETERS' ;
1017: ELSIF(x_err_code = 5) THEN
1018: errbuf := 'Update failed in ap_payment_schedules';
1019: ELSIF(x_err_code = 3) THEN
1020: errbuf := 'Constructive acceptence days is not defined in
1021: FV_TERMS_LINES';
1022: ELSIF(x_err_code = 6) THEN