APPS.GL_COA_SVIM_CONC_PKG dependencies on GL_IMP_COA_SEG_VAL_INTERFACE

Line 35: FROM GL_IMP_COA_SEG_VAL_INTERFACE

31: -- Fnd Flex val Interface Table cursor
32:
33: CURSOR c_gl_flex_values IS
34: SELECT *
35: FROM GL_IMP_COA_SEG_VAL_INTERFACE
36: WHERE BATCH_NUMBER = p_batch_number
37: AND STATUS = 'N'
38: ORDER BY SEG_VAL_INT_ID;
39:

Line 271: UPDATE GL_IMP_COA_SEG_VAL_INTERFACE

267: FOR i IN 1..v_gl_flex_values_tbl.LAST
268: LOOP
269: /* Update the interface table with the status*/
270:
271: UPDATE GL_IMP_COA_SEG_VAL_INTERFACE
272: SET status = v_gl_flex_values_tbl(i).status
273: WHERE batch_number=p_batch_number
274: AND seg_val_int_id = v_gl_flex_values_tbl(i).interface_id;
275:

Line 307: 'GL_IMP_COA_SEG_VAL_INTERFACE',

303: program_update_date)
304: VALUES
305: (
306: gl_imp_coa_err_interface_s.nextval,
307: 'GL_IMP_COA_SEG_VAL_INTERFACE',
308: v_gl_flex_values_tbl(i).interface_id,
309: l_n_msg_num,
310: l_c_msg_txt,
311: NVL(fnd_global.user_id,-1),

Line 418: /* Delete from gl_imp_coa_seg_val_interface Interface Table */

414:
415: /******************End Fnd Flex Val Norm Hier Log and Error***********************/
416:
417: /* Delete successfully imported records */
418: /* Delete from gl_imp_coa_seg_val_interface Interface Table */
419: DELETE FROM gl_imp_coa_seg_val_interface
420: WHERE status = 'P';
421:
422: /* Delete from gl_imp_coa_norm_hier_interface Interface Table */

Line 419: DELETE FROM gl_imp_coa_seg_val_interface

415: /******************End Fnd Flex Val Norm Hier Log and Error***********************/
416:
417: /* Delete successfully imported records */
418: /* Delete from gl_imp_coa_seg_val_interface Interface Table */
419: DELETE FROM gl_imp_coa_seg_val_interface
420: WHERE status = 'P';
421:
422: /* Delete from gl_imp_coa_norm_hier_interface Interface Table */
423: DELETE FROM gl_imp_coa_norm_hier_interface