[Home] [Help]
876:
877: CURSOR prepay_adj_events(l_prepay_app_event_id NUMBER,
878: l_accounting_date DATE) is
879: SELECT APPH.accounting_event_id
880: FROM AP_PREPAY_HISTORY_ALL APPH, AP_INVOICE_DISTRIBUTIONS AID
881: WHERE APPH.related_prepay_app_Event_id = l_prepay_app_event_id
882: AND APPH.invoice_adjustment_event_id = AID.accounting_event_id
883: AND nvl(APPH.posted_flag,'N') = 'N'
884: AND AID.accounting_date = l_accounting_date;
7042: p_calling_sequence IN VARCHAR2)
7043: IS
7044:
7045: l_curr_calling_sequence VARCHAR2(2000);
7046: TYPE l_prepay_hist_list IS TABLE OF ap_prepay_history.prepay_history_id%TYPE;
7047: l_prepay_hist_tab l_prepay_hist_list;
7048:
7049:
7050: -- Logging:
7064: G_MODULE_NAME || l_procedure_name,
7065: l_log_msg);
7066: END IF;
7067:
7068: UPDATE AP_Prepay_History
7069: SET Accounting_Event_ID = p_accounting_event_id
7070: WHERE Invoice_ID = p_invoice_id
7071: AND Invoice_Line_Number = p_invoice_line_number
7072: AND Accounting_Date = p_accounting_date
7238: ELSE
7239: l_transaction_type := PREPAYMENT_UNAPPLIED_TYPE;
7240: END IF;
7241:
7242: INSERT INTO AP_PREPAY_HISTORY_ALL
7243: ( PREPAY_HISTORY_ID
7244: ,PREPAY_INVOICE_ID
7245: ,PREPAY_LINE_NUM
7246: ,ACCOUNTING_EVENT_ID
7262: ,PROGRAM_ID
7263: ,PROGRAM_UPDATE_DATE
7264: ,REQUEST_ID)
7265: VALUES
7266: (AP_PREPAY_HISTORY_S.nextval
7267: ,l_prepay_invoice_id
7268: ,l_prepay_line_number
7269: ,p_Accounting_event_id
7270: ,'N'
7329: ELSE
7330: l_transaction_type := PREPAYMENT_UNAPPLIED_TYPE;
7331: END IF;
7332:
7333: INSERT INTO AP_PREPAY_HISTORY_ALL
7334: ( PREPAY_HISTORY_ID
7335: ,PREPAY_INVOICE_ID
7336: ,PREPAY_LINE_NUM
7337: ,ACCOUNTING_EVENT_ID
7352: ,PROGRAM_ID
7353: ,PROGRAM_UPDATE_DATE
7354: ,REQUEST_ID)
7355: VALUES
7356: (AP_PREPAY_HISTORY_S.nextval
7357: ,l_prepay_invoice_id
7358: ,l_prepay_line_number
7359: ,p_Accounting_event_id
7360: ,p_accounting_date