APPS.GL_COA_SVIM_CONC_PKG SQL Statements

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

Line: 34

         SELECT *
         FROM GL_IMP_COA_SEG_VAL_INTERFACE
	 WHERE BATCH_NUMBER = p_batch_number
	 AND STATUS = 'N'
	 ORDER BY SEG_VAL_INT_ID;

Line: 43

         SELECT *
         FROM GL_IMP_COA_NORM_HIER_INTERFACE
	 WHERE BATCH_NUMBER = p_batch_number
	 AND STATUS = 'N'
	 ORDER BY NORM_HIER_INT_ID;

Line: 86

         SELECT
           message_number,
           message_text
         FROM   fnd_new_messages
         WHERE  application_id=101
	 AND    language_code = USERENV('LANG')
	 AND    message_name=cp_c_msg_name;

Line: 269

                 /* Update the interface table with the status*/

                   UPDATE GL_IMP_COA_SEG_VAL_INTERFACE
                    SET status = v_gl_flex_values_tbl(i).status
                   WHERE batch_number=p_batch_number
                   AND seg_val_int_id = v_gl_flex_values_tbl(i).interface_id;

Line: 288

	             INSERT INTO GL_IMP_COA_ERR_INTERFACE
			      (
				err_message_id,
				int_table_name,
				interface_id,
				message_num,
				message_text,
				created_by,
				creation_date,
				last_updated_by,
				last_update_date,
				last_update_login,
				request_id,
				program_application_id,
				program_id,
				program_update_date)
			     VALUES
			      (
				gl_imp_coa_err_interface_s.nextval,
				'GL_IMP_COA_SEG_VAL_INTERFACE',
				v_gl_flex_values_tbl(i).interface_id,
				l_n_msg_num,
				l_c_msg_txt,
				NVL(fnd_global.user_id,-1),
				SYSDATE,
				NVL(fnd_global.user_id,-1),
				SYSDATE,
				NVL(fnd_global.login_id,-1),
				l_n_request_id,
				l_n_prog_appl_id,
				l_n_prog_id,
				l_d_prog_upd_dt
			      );

Line: 332

                     v_gl_flex_values_tbl.DELETE;

Line: 344

                 /* Update the interface table with the status*/

                   UPDATE GL_IMP_COA_NORM_HIER_INTERFACE
                    SET status = v_gl_flex_values_nh_tbl(i).status
                   WHERE batch_number=p_batch_number
                   AND norm_hier_int_id = v_gl_flex_values_nh_tbl(i).interface_id;

Line: 367

	             INSERT INTO GL_IMP_COA_ERR_INTERFACE
			      (
				err_message_id,
				int_table_name,
				interface_id,
				message_num,
				message_text,
				created_by,
				creation_date,
				last_updated_by,
				last_update_date,
				last_update_login,
				request_id,
				program_application_id,
				program_id,
				program_update_date)
			     VALUES
			      (
				gl_imp_coa_err_interface_s.nextval,
				'GL_IMP_COA_NORM_HIER_INTERFACE',
				v_gl_flex_values_nh_tbl(i).interface_id,
				l_n_msg_num,
				l_c_msg_txt,
				NVL(fnd_global.user_id,-1),
				SYSDATE,
				NVL(fnd_global.user_id,-1),
				SYSDATE,
				NVL(fnd_global.login_id,-1),
				l_n_request_id,
				l_n_prog_appl_id,
				l_n_prog_id,
				l_d_prog_upd_dt
			      );

Line: 412

                     v_gl_flex_values_nh_tbl.DELETE;

Line: 417

 /* Delete successfully imported records */
            /* Delete from gl_imp_coa_seg_val_interface Interface Table */
            DELETE FROM gl_imp_coa_seg_val_interface
            WHERE status = 'P';

Line: 422

             /* Delete from gl_imp_coa_norm_hier_interface Interface Table */
            DELETE FROM gl_imp_coa_norm_hier_interface
            WHERE status = 'P';