APPS.GL_COA_SVIM_CONC_PKG dependencies on GL_IMP_COA_NORM_HIER_INTERFACE

Line 44: FROM GL_IMP_COA_NORM_HIER_INTERFACE

40: -- Fnd Flex Val Interface Table cursor
41:
42: CURSOR c_gl_flex_values_nh IS
43: SELECT *
44: FROM GL_IMP_COA_NORM_HIER_INTERFACE
45: WHERE BATCH_NUMBER = p_batch_number
46: AND STATUS = 'N'
47: ORDER BY NORM_HIER_INT_ID;
48:

Line 346: UPDATE GL_IMP_COA_NORM_HIER_INTERFACE

342: FOR i IN 1..v_gl_flex_values_nh_tbl.LAST
343: LOOP
344: /* Update the interface table with the status*/
345:
346: UPDATE GL_IMP_COA_NORM_HIER_INTERFACE
347: SET status = v_gl_flex_values_nh_tbl(i).status
348: WHERE batch_number=p_batch_number
349: AND norm_hier_int_id = v_gl_flex_values_nh_tbl(i).interface_id;
350:

Line 386: 'GL_IMP_COA_NORM_HIER_INTERFACE',

382: program_update_date)
383: VALUES
384: (
385: gl_imp_coa_err_interface_s.nextval,
386: 'GL_IMP_COA_NORM_HIER_INTERFACE',
387: v_gl_flex_values_nh_tbl(i).interface_id,
388: l_n_msg_num,
389: l_c_msg_txt,
390: NVL(fnd_global.user_id,-1),

Line 422: /* Delete from gl_imp_coa_norm_hier_interface Interface Table */

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
424: WHERE status = 'P';
425:
426:

Line 423: DELETE FROM gl_imp_coa_norm_hier_interface

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
424: WHERE status = 'P';
425:
426:
427: /* If none of the interface tables has not appropriate data that is to be processed, then set the message and error out */