APPS.CE_UK_VALIDATIONS_DATA_LDR dependencies on FND_GLOBAL

Line 191: FND_GLOBAL.conc_request_id,

187: SELECT
188: INTERFACE_LINE_ID,
189: SOURCE_VALUE1,
190: SOURCE_VALUE2,
191: FND_GLOBAL.conc_request_id,
192: FND_GLOBAL.user_id,
193: sysdate,
194: FND_GLOBAL.user_id,
195: sysdate,

Line 192: FND_GLOBAL.user_id,

188: INTERFACE_LINE_ID,
189: SOURCE_VALUE1,
190: SOURCE_VALUE2,
191: FND_GLOBAL.conc_request_id,
192: FND_GLOBAL.user_id,
193: sysdate,
194: FND_GLOBAL.user_id,
195: sysdate,
196: FND_GLOBAL.user_id

Line 194: FND_GLOBAL.user_id,

190: SOURCE_VALUE2,
191: FND_GLOBAL.conc_request_id,
192: FND_GLOBAL.user_id,
193: sysdate,
194: FND_GLOBAL.user_id,
195: sysdate,
196: FND_GLOBAL.user_id
197: FROM
198: CE_UK_VALIDATIONS_INTERFACE;

Line 196: FND_GLOBAL.user_id

192: FND_GLOBAL.user_id,
193: sysdate,
194: FND_GLOBAL.user_id,
195: sysdate,
196: FND_GLOBAL.user_id
197: FROM
198: CE_UK_VALIDATIONS_INTERFACE;
199: log_msg(SQL%Rowcount||' record(s) inserted.');
200:

Line 419: FND_GLOBAL.conc_request_id,

415: SOURCE_VALUE15,
416: SOURCE_VALUE16,
417: SOURCE_VALUE17,
418: SOURCE_VALUE18,
419: FND_GLOBAL.conc_request_id,
420: FND_GLOBAL.user_id,
421: sysdate,
422: FND_GLOBAL.user_id,
423: sysdate,

Line 420: FND_GLOBAL.user_id,

416: SOURCE_VALUE16,
417: SOURCE_VALUE17,
418: SOURCE_VALUE18,
419: FND_GLOBAL.conc_request_id,
420: FND_GLOBAL.user_id,
421: sysdate,
422: FND_GLOBAL.user_id,
423: sysdate,
424: FND_GLOBAL.user_id

Line 422: FND_GLOBAL.user_id,

418: SOURCE_VALUE18,
419: FND_GLOBAL.conc_request_id,
420: FND_GLOBAL.user_id,
421: sysdate,
422: FND_GLOBAL.user_id,
423: sysdate,
424: FND_GLOBAL.user_id
425: FROM
426: CE_UK_VALIDATIONS_INTERFACE;

Line 424: FND_GLOBAL.user_id

420: FND_GLOBAL.user_id,
421: sysdate,
422: FND_GLOBAL.user_id,
423: sysdate,
424: FND_GLOBAL.user_id
425: FROM
426: CE_UK_VALIDATIONS_INTERFACE;
427: log_msg(SQL%Rowcount||' record(s) inserted.');
428:

Line 549: put_element('requestId',FND_GLOBAL.conc_request_id);

545: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
546: put_starttag('?xml version="1.0" encoding="'||l_encoding||'"?');
547: put_starttag('ukValLoader');
548: put_element('reportType','EXEC');
549: put_element('requestId',FND_GLOBAL.conc_request_id);
550: put_element('requestDate',to_char(SYSDATE,FND_PROFILE.value('ICX_DATE_FORMAT_MASK')));
551: put_element('filePath',X_directory_path);
552: put_element('fileName',X_input_file);
553: put_element('fileTypeCode',X_file_type);

Line 593: IF (INSTR(X_directory_path, FND_GLOBAL.local_chr(92)) <> 0 )

589: END IF;
590:
591: -- Reformat the input file name
592: -- local_chr(92) = '\' character, local_chr(47) = '/' character
593: IF (INSTR(X_directory_path, FND_GLOBAL.local_chr(92)) <> 0 )
594: THEN
595: l_data_file := X_directory_path || FND_GLOBAL.local_chr(92) || X_input_file;
596: ELSE
597: l_data_file := X_directory_path || FND_GLOBAL.local_chr(47) || X_input_file;

Line 595: l_data_file := X_directory_path || FND_GLOBAL.local_chr(92) || X_input_file;

591: -- Reformat the input file name
592: -- local_chr(92) = '\' character, local_chr(47) = '/' character
593: IF (INSTR(X_directory_path, FND_GLOBAL.local_chr(92)) <> 0 )
594: THEN
595: l_data_file := X_directory_path || FND_GLOBAL.local_chr(92) || X_input_file;
596: ELSE
597: l_data_file := X_directory_path || FND_GLOBAL.local_chr(47) || X_input_file;
598: END IF;
599:

Line 597: l_data_file := X_directory_path || FND_GLOBAL.local_chr(47) || X_input_file;

593: IF (INSTR(X_directory_path, FND_GLOBAL.local_chr(92)) <> 0 )
594: THEN
595: l_data_file := X_directory_path || FND_GLOBAL.local_chr(92) || X_input_file;
596: ELSE
597: l_data_file := X_directory_path || FND_GLOBAL.local_chr(47) || X_input_file;
598: END IF;
599:
600: --
601: -- Call SQL*Loader to load data into interface table

Line 618: argument2 => fnd_global.local_chr(0));

614: application => 'CE',
615: program => G_ldr_program,
616: sub_request => TRUE,
617: argument1 => l_data_file,
618: argument2 => fnd_global.local_chr(0));
619:
620: log_msg('-->Loading datafile:'||l_data_file||', request_id='||l_request_id);
621: IF nvl(l_request_id,0) = 0
622: THEN