DBA Data[Home] [Help]

APPS.EC_INBOUND_STAGE dependencies on FND_GLOBAL

Line 119: i_run_id := fnd_global.conc_request_id;

115: /**
116: If the program is run from SQLplus , the Concurrent Request id is
117: < 0. In this case , get the run id from ECE_OUTPUT_RUNS_S.NEXTVAL.
118: **/
119: i_run_id := fnd_global.conc_request_id;
120: if i_run_id <= 0
121: then
122: select ece_output_runs_s.NEXTVAL
123: into i_run_id

Line 756: c_current_line := replace(c_current_line,fnd_global.local_chr(13));

752: ec_debug.pl(3,'i_total_rec_unit',i_total_rec_unit);
753: ec_debug.pl(3,'c_current_line',c_current_line);
754: end if;
755: -- bug 4555935
756: c_current_line := replace(c_current_line,fnd_global.local_chr(13));
757: c_current_line := replace(c_current_line,fnd_global.local_chr(10));
758: c_current_line := replace(c_current_line,fnd_global.local_chr(9));
759: --bug 2110652
760: if i_fnd_charset_flag = 'Y' then

Line 757: c_current_line := replace(c_current_line,fnd_global.local_chr(10));

753: ec_debug.pl(3,'c_current_line',c_current_line);
754: end if;
755: -- bug 4555935
756: c_current_line := replace(c_current_line,fnd_global.local_chr(13));
757: c_current_line := replace(c_current_line,fnd_global.local_chr(10));
758: c_current_line := replace(c_current_line,fnd_global.local_chr(9));
759: --bug 2110652
760: if i_fnd_charset_flag = 'Y' then
761: if i_db_charset_flag = 'Y' then

Line 758: c_current_line := replace(c_current_line,fnd_global.local_chr(9));

754: end if;
755: -- bug 4555935
756: c_current_line := replace(c_current_line,fnd_global.local_chr(13));
757: c_current_line := replace(c_current_line,fnd_global.local_chr(10));
758: c_current_line := replace(c_current_line,fnd_global.local_chr(9));
759: --bug 2110652
760: if i_fnd_charset_flag = 'Y' then
761: if i_db_charset_flag = 'Y' then
762: for i in i_file_pos..(i_file_pos + i_total_rec_unit - 1 )

Line 972: cValue_stmt := cValue_stmt||' sysdate ,fnd_global.user_id ,sysdate ,fnd_global.user_id ,';

968: -- cValue_stmt := cValue_stmt||':w1 ,:w2 ,:w3 ,:w4 ,';
969:
970:
971: -- cValue_stmt := cValue_stmt||' ece_stage_id_s.CURRVAL ,:a2 ,:a3 ,:a4 ,:a5 ,ece_stage_id_s.NEXTVAL ,:a7 ,:a8 ,:a9 ,:a10 ,:a11 ,';
972: cValue_stmt := cValue_stmt||' sysdate ,fnd_global.user_id ,sysdate ,fnd_global.user_id ,';
973:
974: --- Add Variable Columns for the Record
975: for i in 1..i_stage_record_type.COUNT
976: loop

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

1034:
1035: -- Bind values for Mandatory Columns
1036: /* Bug 2500898
1037: dbms_sql.bind_variable (i_Insert_Cursor,'w1',sysdate);
1038: dbms_sql.bind_variable (i_Insert_Cursor,'w2',fnd_global.user_id);
1039: dbms_sql.bind_variable (i_Insert_Cursor,'w3',sysdate);
1040: dbms_sql.bind_variable (i_Insert_Cursor,'w4',fnd_global.user_id);
1041: */
1042:

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

1036: /* Bug 2500898
1037: dbms_sql.bind_variable (i_Insert_Cursor,'w1',sysdate);
1038: dbms_sql.bind_variable (i_Insert_Cursor,'w2',fnd_global.user_id);
1039: dbms_sql.bind_variable (i_Insert_Cursor,'w3',sysdate);
1040: dbms_sql.bind_variable (i_Insert_Cursor,'w4',fnd_global.user_id);
1041: */
1042:
1043: if EC_DEBUG.G_debug_level >= 3 then
1044: ec_debug.pl(3,'STAGE_ID',i_level_info(i_level).Stage_Id);

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

1051: ec_debug.pl(3,'DOCUMENT_NUMBER',i_level_info(i_level).Document_Number);
1052: ec_debug.pl(3,'TP_CODE',i_level_info(i_level).Tp_Code);
1053: ec_debug.pl(3,'MAP_ID',i_map_id);
1054: ec_debug.pl(3,'CREATION_DATE',sysdate);
1055: ec_debug.pl(3,'CREATED_BY',fnd_global.user_id);
1056: ec_debug.pl(3,'LAST_UPDATE_DATE',sysdate);
1057: ec_debug.pl(3,'LAST_UPDATED_BY',fnd_global.user_id);
1058: ec_debug.pl(3,'STATUS',i_level_info(i_level).Status);
1059: end if;

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

1053: ec_debug.pl(3,'MAP_ID',i_map_id);
1054: ec_debug.pl(3,'CREATION_DATE',sysdate);
1055: ec_debug.pl(3,'CREATED_BY',fnd_global.user_id);
1056: ec_debug.pl(3,'LAST_UPDATE_DATE',sysdate);
1057: ec_debug.pl(3,'LAST_UPDATED_BY',fnd_global.user_id);
1058: ec_debug.pl(3,'STATUS',i_level_info(i_level).Status);
1059: end if;
1060: -- Bind values for Staging Columns mapped to the Flat File
1061: for k in 1..i_stage_record_type.COUNT