APPS.FV_YE_CLOSE dependencies on GL_INTERFACE_CONTROL

Line 3182: vg_interface_run_id := Gl_Interface_Control_Pkg.Get_Unique_Run_Id;

3178: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' IN POPULATE_GL_INTERFACE PROCEDURE....');
3179: END IF;
3180:
3181: -- Get the interface_run_id
3182: vg_interface_run_id := Gl_Interface_Control_Pkg.Get_Unique_Run_Id;
3183:
3184: -- Get the journal group_id
3185: SELECT Gl_Interface_Control_S.NEXTVAL
3186: INTO vg_jrnl_group_id

Line 3185: SELECT Gl_Interface_Control_S.NEXTVAL

3181: -- Get the interface_run_id
3182: vg_interface_run_id := Gl_Interface_Control_Pkg.Get_Unique_Run_Id;
3183:
3184: -- Get the journal group_id
3185: SELECT Gl_Interface_Control_S.NEXTVAL
3186: INTO vg_jrnl_group_id
3187: FROM DUAL;
3188:
3189: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3194: --Insert a control record in gl_interface_control for gl_import to work

3190: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' INTERFACE RUN ID: '||TO_CHAR(VG_INTERFACE_RUN_ID));
3191: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' JOURNAL GROUP ID: '||TO_CHAR(VG_JRNL_GROUP_ID));
3192: END IF;
3193:
3194: --Insert a control record in gl_interface_control for gl_import to work
3195: INSERT INTO Gl_Interface_Control
3196: (je_source_name,
3197: status,
3198: interface_run_id,

Line 3195: INSERT INTO Gl_Interface_Control

3191: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' JOURNAL GROUP ID: '||TO_CHAR(VG_JRNL_GROUP_ID));
3192: END IF;
3193:
3194: --Insert a control record in gl_interface_control for gl_import to work
3195: INSERT INTO Gl_Interface_Control
3196: (je_source_name,
3197: status,
3198: interface_run_id,
3199: group_id,