eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ITA_RECORD_CURR_STATUS_PKG dependencies on FND_GLOBAL

Line 426: l_user_id := fnd_global.user_id;

422: from ITA_SETUP_GROUPS_B
423: where SETUP_GROUP_CODE = l_setup_gp_code) and
424: COLUMN_ID = l_column_id;
425:
426: l_user_id := fnd_global.user_id;
427: l_login_id := fnd_global.conc_login_id;
428: IF l_audit_start_date IS NULL
429: THEN
430: l_del_sql := 'delete from ITA_SETUP_CHANGE_HISTORY where INSTANCE_CODE = ''CURRENT'' and SETUP_GROUP_CODE =''' || l_setup_gp_code || '''';

Line 427: l_login_id := fnd_global.conc_login_id;

423: where SETUP_GROUP_CODE = l_setup_gp_code) and
424: COLUMN_ID = l_column_id;
425:
426: l_user_id := fnd_global.user_id;
427: l_login_id := fnd_global.conc_login_id;
428: IF l_audit_start_date IS NULL
429: THEN
430: l_del_sql := 'delete from ITA_SETUP_CHANGE_HISTORY where INSTANCE_CODE = ''CURRENT'' and SETUP_GROUP_CODE =''' || l_setup_gp_code || '''';
431: EXECUTE IMMEDIATE l_del_sql;

Line 704: l_user_id := fnd_global.user_id;

700: from ITA_SETUP_GROUPS_B
701: where SETUP_GROUP_CODE = l_setup_gp_code)
702: and COLUMN_ID = l_column_id1;
703:
704: l_user_id := fnd_global.user_id;
705: l_login_id := fnd_global.conc_login_id;
706: IF l_audit_start_date IS NULL
707: THEN
708: l_del_sql := 'delete from ITA_SETUP_CHANGE_HISTORY where INSTANCE_CODE = ''CURRENT'' and SETUP_GROUP_CODE =''' || l_setup_gp_code || '''';

Line 705: l_login_id := fnd_global.conc_login_id;

701: where SETUP_GROUP_CODE = l_setup_gp_code)
702: and COLUMN_ID = l_column_id1;
703:
704: l_user_id := fnd_global.user_id;
705: l_login_id := fnd_global.conc_login_id;
706: IF l_audit_start_date IS NULL
707: THEN
708: l_del_sql := 'delete from ITA_SETUP_CHANGE_HISTORY where INSTANCE_CODE = ''CURRENT'' and SETUP_GROUP_CODE =''' || l_setup_gp_code || '''';
709: EXECUTE IMMEDIATE l_del_sql;

Line 1022: l_index_column := INSTR(l_profile_sql, '"' || fnd_global.local_chr(10) || 'COLUMN=');

1018: -- contain the code "TITLE=" before the code "COLUMN=". The logic
1019: -- in RECORD_PROFILE_CURRENT_STATE above used to check for the latter.
1020: -- As of bug 5638086, we are not checking for that anymore in the code
1021: -- above. Instead, we do that processing here.
1022: l_index_column := INSTR(l_profile_sql, '"' || fnd_global.local_chr(10) || 'COLUMN=');
1023: l_index_title := INSTR(l_profile_sql, '"' || fnd_global.local_chr(10) || 'TITLE=');
1024:
1025: l_index_end := l_index_column;
1026: IF (l_index_title <> 0) THEN

Line 1023: l_index_title := INSTR(l_profile_sql, '"' || fnd_global.local_chr(10) || 'TITLE=');

1019: -- in RECORD_PROFILE_CURRENT_STATE above used to check for the latter.
1020: -- As of bug 5638086, we are not checking for that anymore in the code
1021: -- above. Instead, we do that processing here.
1022: l_index_column := INSTR(l_profile_sql, '"' || fnd_global.local_chr(10) || 'COLUMN=');
1023: l_index_title := INSTR(l_profile_sql, '"' || fnd_global.local_chr(10) || 'TITLE=');
1024:
1025: l_index_end := l_index_column;
1026: IF (l_index_title <> 0) THEN
1027: IF (l_index_end = 0 or l_index_title < l_index_end) THEN

Line 1076: l_profile_sql := REPLACE(l_profile_sql, fnd_global.local_chr(9), ' '); -- Replace tabs.

1072:
1073: BEGIN
1074:
1075: l_profile_sql := UPPER(p_profile_sql);
1076: l_profile_sql := REPLACE(l_profile_sql, fnd_global.local_chr(9), ' '); -- Replace tabs.
1077: l_profile_sql := REPLACE(l_profile_sql, fnd_global.local_chr(10), ' '); -- Replace new lines.
1078:
1079: -- Try to find the beginning of the first column name.
1080: l_index_select := INSTR(l_profile_sql, 'SELECT');

Line 1077: l_profile_sql := REPLACE(l_profile_sql, fnd_global.local_chr(10), ' '); -- Replace new lines.

1073: BEGIN
1074:
1075: l_profile_sql := UPPER(p_profile_sql);
1076: l_profile_sql := REPLACE(l_profile_sql, fnd_global.local_chr(9), ' '); -- Replace tabs.
1077: l_profile_sql := REPLACE(l_profile_sql, fnd_global.local_chr(10), ' '); -- Replace new lines.
1078:
1079: -- Try to find the beginning of the first column name.
1080: l_index_select := INSTR(l_profile_sql, 'SELECT');
1081: l_index_mark := l_index_select + 6;

Line 1084: IF letter <> ' ' and letter <> fnd_global.local_chr(9) and letter <> fnd_global.local_chr(10) THEN EXIT; END IF;

1080: l_index_select := INSTR(l_profile_sql, 'SELECT');
1081: l_index_mark := l_index_select + 6;
1082: LOOP
1083: letter := SUBSTR(l_profile_sql, l_index_mark, 1);
1084: IF letter <> ' ' and letter <> fnd_global.local_chr(9) and letter <> fnd_global.local_chr(10) THEN EXIT; END IF;
1085: l_index_mark := l_index_mark + 1;
1086: END LOOP;
1087:
1088: -- Check that this word is not "DISTINCT".

Line 1094: IF letter <> ' ' and letter <> fnd_global.local_chr(9) and letter <> fnd_global.local_chr(10) THEN EXIT; END IF;

1090: l_index_mark := l_index_mark + 8;
1091: -- Find the beginning of the first column name.
1092: LOOP
1093: letter := SUBSTR(l_profile_sql, l_index_mark, 1);
1094: IF letter <> ' ' and letter <> fnd_global.local_chr(9) and letter <> fnd_global.local_chr(10) THEN EXIT; END IF;
1095: l_index_mark := l_index_mark + 1;
1096: END LOOP;
1097: END IF;
1098:

Line 1111: IF letter <> ' ' and letter <> fnd_global.local_chr(9) and letter <> fnd_global.local_chr(10) THEN EXIT; END IF;

1107: l_index_comma := INSTR(l_profile_sql, ',');
1108: l_index_mark := l_index_comma + 1;
1109: LOOP
1110: letter := SUBSTR(l_profile_sql, l_index_mark, 1);
1111: IF letter <> ' ' and letter <> fnd_global.local_chr(9) and letter <> fnd_global.local_chr(10) THEN EXIT; END IF;
1112: l_index_mark := l_index_mark + 1;
1113: END LOOP;
1114:
1115: -- Delete the second column alias.