APPS.FV_DUE_DATE_CALCULATION dependencies on FV_INV_SELECTED_DUEDATE

Line 60: FROM fv_inv_selected_duedate fiv

56: FROM ap_terms_lines
57: WHERE term_id = apt.term_id)
58: AND api.invoice_id = aps.invoice_id
59: AND (NOT EXISTS ( SELECT 'x'
60: FROM fv_inv_selected_duedate fiv
61: WHERE fiv.invoice_id = api.invoice_id)
62: or aps.payment_status_flag <> 'Y'); -- added for bug 5454497;
63: -- transaction_type equals to ACCEPT, RECEIVE.
64: --LGOEL: Add shipment_header_id in the select list

Line 285: DELETE FROM fv_inv_selected_duedate_temp

281:
282: -- bug 2088857 fix, added nvl around set_of_bks_name
283: -- since this holds org_id value which will be null in non-multiorg
284:
285: DELETE FROM fv_inv_selected_duedate_temp
286: WHERE NVL(set_of_bks_name,-99) = NVL(v_sob_name,-99);
287: COMMIT;
288: EXCEPTION
289: WHEN NO_DATA_FOUND THEN

Line 359: FROM fv_inv_selected_duedate fiv

355: v_exists_2_dis_date := null;
356: v_exists_3_dis_date := null;
357: SELECT new_due_date, new_DISCOUNT_DATE,NEW_SECOND_DISC_DATE,NEW_THIRD_DISC_DATE
358: into v_exists_due_date , v_exists_1_dis_date,v_exists_2_dis_date,v_exists_3_dis_date
359: FROM fv_inv_selected_duedate fiv
360: WHERE fiv.invoice_id = v_invoice_id;
361:
362: -- Modified for bug 13790343
363: IF (v_org_due_date IS NOT NULL) then

Line 858: INSERT INTO fv_inv_selected_duedate

854: IF (x_run_mode = 'F') THEN
855: BEGIN
856:
857: x_err_code := 5;
858: INSERT INTO fv_inv_selected_duedate
859: (INVOICE_ID,
860: INVOICE_NUM,
861: TERMS_DATE ,
862: ORG_DUE_DATE,

Line 907: UPDATE fv_inv_selected_duedate

903: WHEN DUP_VAL_ON_INDEX THEN
904: /* If invoice exist update the duedate,this will happen
905: if an invoice have more then one distributions */
906:
907: UPDATE fv_inv_selected_duedate
908: SET NEW_DUE_DATE = DECODE(v_due_date_flag,'Y',
909: v_total_due_date,NULL)
910: WHERE invoice_id = v_invoice_id;
911: END ;

Line 957: INSERT INTO fv_inv_selected_duedate_temp

953: v_second_disc_date IS NOT NULL OR
954: v_new_third_disc_date IS NOT NULL) THEN
955: BEGIN
956:
957: INSERT INTO fv_inv_selected_duedate_temp
958: (INVOICE_ID,
959: INVOICE_NUM,
960: TERMS_DATE ,
961: ORG_DUE_DATE,

Line 993: UPDATE fv_inv_selected_duedate_temp

989: if an invoice have more then one distributions */
990:
991: WHEN DUP_VAL_ON_INDEX THEN
992:
993: UPDATE fv_inv_selected_duedate_temp
994: SET NEW_DUE_DATE = DECODE(v_due_date_flag,'Y',
995: v_total_due_date ,NULL)
996: WHERE invoice_id = v_invoice_id;
997: END ;

Line 1041: errbuf := 'Insert failed in Fv_inv_selected_duedate_temp';

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
1041: errbuf := 'Insert failed in Fv_inv_selected_duedate_temp';
1042: ELSIF(x_err_code = 5) THEN
1043: errbuf := 'Main_select' || SQLERRM;
1044: ELSIF(x_err_code = 4) THEN
1045: errbuf := 'C2_ACCEPT' || SQLERRM;