DBA Data[Home] [Help]

APPS.EC_OUTBOUND dependencies on FND_GLOBAL

Line 13: c_local_chr_10 varchar2(1) := fnd_global.local_chr(10);

9: cursor seq_document_id
10: is
11: select ece_document_id_s.NEXTVAL
12: from dual;
13: c_local_chr_10 varchar2(1) := fnd_global.local_chr(10);
14: c_local_chr_9 varchar2(1) := fnd_global.local_chr(9);
15: c_local_chr_13 varchar2(1) := fnd_global.local_chr(13);
16:
17: /**

Line 14: c_local_chr_9 varchar2(1) := fnd_global.local_chr(9);

10: is
11: select ece_document_id_s.NEXTVAL
12: from dual;
13: c_local_chr_10 varchar2(1) := fnd_global.local_chr(10);
14: c_local_chr_9 varchar2(1) := fnd_global.local_chr(9);
15: c_local_chr_13 varchar2(1) := fnd_global.local_chr(13);
16:
17: /**
18: Build and Parses the Insert Statement for insert into ece_stage for each Level.

Line 15: c_local_chr_13 varchar2(1) := fnd_global.local_chr(13);

11: select ece_document_id_s.NEXTVAL
12: from dual;
13: c_local_chr_10 varchar2(1) := fnd_global.local_chr(10);
14: c_local_chr_9 varchar2(1) := fnd_global.local_chr(9);
15: c_local_chr_13 varchar2(1) := fnd_global.local_chr(13);
16:
17: /**
18: Build and Parses the Insert Statement for insert into ece_stage for each Level.
19: The Cursor handles are stored in the ec_utils.g_int_levels(i).cursor_handle.

Line 301: dbms_sql.bind_variable (i_Insert_Cursor,'w2',fnd_global.user_id);

297: dbms_sql.bind_variable (i_Insert_Cursor,'a9',i_status);
298:
299: -- Bind values for Mandatory Columns
300: dbms_sql.bind_variable (i_Insert_Cursor,'w1',sysdate);
301: dbms_sql.bind_variable (i_Insert_Cursor,'w2',fnd_global.user_id);
302: dbms_sql.bind_variable (i_Insert_Cursor,'w3',sysdate);
303: dbms_sql.bind_variable (i_Insert_Cursor,'w4',fnd_global.user_id);
304:
305: if ec_debug.G_debug_level = 3 then

Line 303: dbms_sql.bind_variable (i_Insert_Cursor,'w4',fnd_global.user_id);

299: -- Bind values for Mandatory Columns
300: dbms_sql.bind_variable (i_Insert_Cursor,'w1',sysdate);
301: dbms_sql.bind_variable (i_Insert_Cursor,'w2',fnd_global.user_id);
302: dbms_sql.bind_variable (i_Insert_Cursor,'w3',sysdate);
303: dbms_sql.bind_variable (i_Insert_Cursor,'w4',fnd_global.user_id);
304:
305: if ec_debug.G_debug_level = 3 then
306: ec_debug.pl(3,'STAGE_ID',ec_utils.g_ext_levels(i_level).Stage_Id);
307: ec_debug.pl(3,'DOCUMENT_ID',ec_utils.g_ext_levels(i_level).Document_Id);

Line 315: ec_debug.pl(3,'CREATED_BY',fnd_global.user_id);

311: ec_debug.pl(3,'PARENT_STAGE_ID',ec_utils.g_ext_levels(i_level).Parent_Stage_Id);
312: ec_debug.pl(3,'RUN_ID',ec_utils.g_run_id);
313: ec_debug.pl(3,'DOCUMENT_NUMBER',ec_utils.g_ext_levels(i_level).Document_Number);
314: ec_debug.pl(3,'CREATION_DATE',sysdate);
315: ec_debug.pl(3,'CREATED_BY',fnd_global.user_id);
316: ec_debug.pl(3,'LAST_UPDATE_DATE',sysdate);
317: ec_debug.pl(3,'LAST_UPDATED_BY',fnd_global.user_id);
318: end if;
319:

Line 317: ec_debug.pl(3,'LAST_UPDATED_BY',fnd_global.user_id);

313: ec_debug.pl(3,'DOCUMENT_NUMBER',ec_utils.g_ext_levels(i_level).Document_Number);
314: ec_debug.pl(3,'CREATION_DATE',sysdate);
315: ec_debug.pl(3,'CREATED_BY',fnd_global.user_id);
316: ec_debug.pl(3,'LAST_UPDATE_DATE',sysdate);
317: ec_debug.pl(3,'LAST_UPDATED_BY',fnd_global.user_id);
318: end if;
319:
320: -- Bind values for Staging Columns mapped to the Flat File
321: for k in ec_utils.g_int_levels(i_level).file_start_pos..ec_utils.g_int_levels(i_level).file_end_pos

Line 813: i_run_id := fnd_global.conc_request_id;

809: /**
810: If the program is run from SQLplus , the Concurrent Request id is
811: < 0. In this case , get the run id from ECE_OUTPUT_RUNS_S.NEXTVAL.
812: **/
813: i_run_id := fnd_global.conc_request_id;
814: if i_run_id <= 0
815: then
816: select ece_output_runs_s.NEXTVAL
817: into i_run_id