APPS.FV_DUE_DATE_CALCULATION dependencies on FV_INV_SELECTED_DUEDATE_TEMP

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 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;