APPS.GL_CI_DATA_TRANSFER_PKG dependencies on GL_INTERFACE

Line 348: l_pd_name gl_interface.period_name%TYPE;

344: l_group_id number;
345: v_InsertSQL VARCHAR2(10000);
346: l_out_table_name varchar2(30);
347: l_in_table_name varchar2(30);
348: l_pd_name gl_interface.period_name%TYPE;
349: v_BlockSQL varchar2(300);
350: v_SQL varchar2(1000);
351: l_target_ledger_id number;
352: l_request_id number;

Line 376: --+procedure, make sure you get source data from gl_interface table

372: l_source_ledger_id := source_ledger_id;
373: l_target_ledger_id := p_target_ledger_id;
374: --+for debug from SQL Navigator, run consolidation from the Oracle Applications without
375: --+Journal Import, use its group ID and consolidation concurrent request id to run this
376: --+procedure, make sure you get source data from gl_interface table
377: --+l_in_table_name := 'GL_INTERFACE';
378: l_request_id := request_id;
379: l_in_table_name := i_parallel_name || group_id;
380: v_SQL := 'BEGIN '||' :l_group_id := ' || applSysSchema ||'.GL_CI_REMOTE_INVOKE_PKG.Get_Group_ID@' || dblink||';'||' END;';

Line 377: --+l_in_table_name := 'GL_INTERFACE';

373: l_target_ledger_id := p_target_ledger_id;
374: --+for debug from SQL Navigator, run consolidation from the Oracle Applications without
375: --+Journal Import, use its group ID and consolidation concurrent request id to run this
376: --+procedure, make sure you get source data from gl_interface table
377: --+l_in_table_name := 'GL_INTERFACE';
378: l_request_id := request_id;
379: l_in_table_name := i_parallel_name || group_id;
380: v_SQL := 'BEGIN '||' :l_group_id := ' || applSysSchema ||'.GL_CI_REMOTE_INVOKE_PKG.Get_Group_ID@' || dblink||';'||' END;';
381: EXECUTE IMMEDIATE v_SQL USING OUT l_group_id;

Line 958: --+has been transfered into gl_interface table

954: return result;
955: END Remote_Data_Validation;
956: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
957: --+get the group ID from the source dtaabase after the consolidation data
958: --+has been transfered into gl_interface table
959: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
960: function Get_Source_Group_ID(
961: cons_id IN number,
962: cons_run_id IN number

Line 1036: l_pd_name gl_interface.period_name%TYPE;

1032: dblink varchar2(30);
1033: l_inter_run_id number;
1034: l_reqJI_id number;
1035: l_reqPost_id number;
1036: l_pd_name gl_interface.period_name%TYPE;
1037: l_to_ledger_id number;
1038: l_user_id number;
1039: l_resp_id number;
1040: l_app_id number;

Line 1194: --+populates the gl_interface_control table and gl_cons_interface_to_group_id table

1190: log_message('==>' || FND_MESSAGE.get, TRUE);
1191: errbuf := errbuf || ' ' || FND_MESSAGE.get;
1192: end if;
1193: IF (p_j_import = 'N') THEN
1194: --+populates the gl_interface_control table and gl_cons_interface_to_group_id table
1195: --+add an average flag to indicate whether this is a adb balances transfer or not
1196: v_SQL := 'BEGIN '||' :l_id := ' || applSysSchema || '.GL_CI_REMOTE_INVOKE_PKG.Apps_Initialize@' || dblink ||
1197: '(:usr_id, :rsp_id, :ap_id, :sb_id, :gp_id, :pd_name, :flag, :avg);'||' END;';
1198: EXECUTE IMMEDIATE v_SQL USING OUT l_inter_run_id, IN l_user_id, IN l_resp_id, IN l_app_id, IN l_to_ledger_id,

Line 1213: debug_message('Populates the gl_interface_control table on Target database',TRUE);

1209: IF (p_j_import = 'Y') THEN
1210: --+get the target ledger id
1211: section_number := 2;
1212: if l_debug = 'Y' then
1213: debug_message('Populates the gl_interface_control table on Target database',TRUE);
1214: debug_message('Updates the gl_cons_interface_' || l_to_group_id || ' on target database',TRUE);
1215: end if;
1216: --+populates the gl_interface_control table and gl_cons_interface_to_group_id table
1217: v_SQL := 'BEGIN '||' :l_id := ' || applSysSchema || '.GL_CI_REMOTE_INVOKE_PKG.Apps_Initialize@' || dblink ||

Line 1216: --+populates the gl_interface_control table and gl_cons_interface_to_group_id table

1212: if l_debug = 'Y' then
1213: debug_message('Populates the gl_interface_control table on Target database',TRUE);
1214: debug_message('Updates the gl_cons_interface_' || l_to_group_id || ' on target database',TRUE);
1215: end if;
1216: --+populates the gl_interface_control table and gl_cons_interface_to_group_id table
1217: v_SQL := 'BEGIN '||' :l_id := ' || applSysSchema || '.GL_CI_REMOTE_INVOKE_PKG.Apps_Initialize@' || dblink ||
1218: '(:usr_id, :rsp_id, :ap_id, :sb_id, :gp_id, :pd_name, :flag, :avg);'||' END;';
1219: EXECUTE IMMEDIATE v_SQL USING OUT l_inter_run_id, IN l_user_id, IN l_resp_id, IN l_app_id, IN l_to_ledger_id,
1220: IN l_to_group_id, IN l_pd_name, IN p_actual_flag, IN l_avg_flag;