APPS.ISC_DBI_CHANGE_LOG_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

PROCEDURE Update_Del_Detail_Log(p_detail_list		IN LOG_TAB_TYPE,
                                p_dml_type		IN VARCHAR2,
				x_return_status		OUT NOCOPY VARCHAR2) IS
BEGIN

  FORALL i IN p_detail_list.FIRST..p_detail_list.LAST
     INSERT INTO isc_dbi_wdd_change_log (
        DELIVERY_DETAIL_ID,
        DML_TYPE,
        LAST_UPDATE_DATE)
     VALUES (p_detail_list(i), p_dml_type, sysdate);

Line: 26

END Update_Del_Detail_Log;

Line: 28

PROCEDURE Update_Trip_Stop_Log(p_stop_list		IN LOG_TAB_TYPE,
                               p_dml_type		IN VARCHAR2,
			       x_return_status		OUT NOCOPY VARCHAR2) IS
BEGIN

  FORALL i IN p_stop_list.FIRST..p_stop_list.LAST
     INSERT INTO isc_dbi_wts_change_log (
        STOP_ID,
        DML_TYPE,
        LAST_UPDATE_DATE)
     VALUES (p_stop_list(i), p_dml_type, sysdate);

Line: 46

END Update_Trip_Stop_Log;

Line: 48

PROCEDURE Update_Fte_Invoice_Log (p_invoice_list	IN LOG_TAB_TYPE,
				  p_dml_type		IN VARCHAR2,
				  x_return_status	OUT NOCOPY VARCHAR2) IS
BEGIN

  FORALL i IN p_invoice_list.FIRST..p_invoice_list.LAST
     INSERT INTO isc_dbi_fih_change_log (
        INVOICE_HEADER_ID,
        DML_TYPE,
        LAST_UPDATE_DATE)
     VALUES (p_invoice_list(i), p_dml_type, sysdate);

Line: 66

END Update_Fte_Invoice_Log;