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 ITA_SETUP_PARAMETERS_B

Line 372: l_select_clause ITA_SETUP_PARAMETERS_B.SELECT_CLAUSE%TYPE;

368: l_column_id NUMBER;
369: l_column_id1 NUMBER;
370: --l_shadow_table_name VARCHAR2(40);
371: l_del_sql VARCHAR2(32767);
372: l_select_clause ITA_SETUP_PARAMETERS_B.SELECT_CLAUSE%TYPE;
373: l_from_clause ITA_SETUP_PARAMETERS_B.FROM_CLAUSE%TYPE;
374: l_where_clause ITA_SETUP_PARAMETERS_B.WHERE_CLAUSE%TYPE;
375: l_ins_sql VARCHAR2(32767);
376: l_column_name FND_COLUMNS.COLUMN_NAME%TYPE;

Line 373: l_from_clause ITA_SETUP_PARAMETERS_B.FROM_CLAUSE%TYPE;

369: l_column_id1 NUMBER;
370: --l_shadow_table_name VARCHAR2(40);
371: l_del_sql VARCHAR2(32767);
372: l_select_clause ITA_SETUP_PARAMETERS_B.SELECT_CLAUSE%TYPE;
373: l_from_clause ITA_SETUP_PARAMETERS_B.FROM_CLAUSE%TYPE;
374: l_where_clause ITA_SETUP_PARAMETERS_B.WHERE_CLAUSE%TYPE;
375: l_ins_sql VARCHAR2(32767);
376: l_column_name FND_COLUMNS.COLUMN_NAME%TYPE;
377: l_user_id NUMBER;

Line 374: l_where_clause ITA_SETUP_PARAMETERS_B.WHERE_CLAUSE%TYPE;

370: --l_shadow_table_name VARCHAR2(40);
371: l_del_sql VARCHAR2(32767);
372: l_select_clause ITA_SETUP_PARAMETERS_B.SELECT_CLAUSE%TYPE;
373: l_from_clause ITA_SETUP_PARAMETERS_B.FROM_CLAUSE%TYPE;
374: l_where_clause ITA_SETUP_PARAMETERS_B.WHERE_CLAUSE%TYPE;
375: l_ins_sql VARCHAR2(32767);
376: l_column_name FND_COLUMNS.COLUMN_NAME%TYPE;
377: l_user_id NUMBER;
378: l_login_id NUMBER;

Line 385: from fnd_columns fnd, ita_setup_parameters_b isp

381:
382: CURSOR c_get_parameters(p_setup_group_code IN VARCHAR2)
383: IS
384: SELECT fnd.column_name, isp.parameter_code
385: from fnd_columns fnd, ita_setup_parameters_b isp
386: WHERE isp.setup_group_code = p_setup_group_code AND
387: isp.column_id = fnd.column_id;
388:
389: l_param_rec c_get_parameters%ROWTYPE;

Line 410: (SELECT column_id FROM ita_setup_parameters_b WHERE parameter_code = setup_gp.CONTEXT_PARAMETER_CODE) column_id,

406:
407: select setup_gp.SETUP_GROUP_CODE, setup_gp.AUDIT_START_DATE,
408: setup_gp.CONTEXT_PARAMETER_CODE, setup_gp.HIERARCHY_LEVEL hierarchy_level_code,
409: setup_gp.context_parameter_code2,
410: (SELECT column_id FROM ita_setup_parameters_b WHERE parameter_code = setup_gp.CONTEXT_PARAMETER_CODE) column_id,
411: (SELECT column_id FROM ita_setup_parameters_b WHERE parameter_code = setup_gp.CONTEXT_PARAMETER_CODE2) column_id1
412: INTO l_setup_gp_code, l_audit_start_date, l_context_param_code, l_hier_level_code, l_context_param_code2,
413: l_column_id, l_column_id1
414: FROM ITA_SETUP_GROUPS_B setup_gp

Line 411: (SELECT column_id FROM ita_setup_parameters_b WHERE parameter_code = setup_gp.CONTEXT_PARAMETER_CODE2) column_id1

407: select setup_gp.SETUP_GROUP_CODE, setup_gp.AUDIT_START_DATE,
408: setup_gp.CONTEXT_PARAMETER_CODE, setup_gp.HIERARCHY_LEVEL hierarchy_level_code,
409: setup_gp.context_parameter_code2,
410: (SELECT column_id FROM ita_setup_parameters_b WHERE parameter_code = setup_gp.CONTEXT_PARAMETER_CODE) column_id,
411: (SELECT column_id FROM ita_setup_parameters_b WHERE parameter_code = setup_gp.CONTEXT_PARAMETER_CODE2) column_id1
412: INTO l_setup_gp_code, l_audit_start_date, l_context_param_code, l_hier_level_code, l_context_param_code2,
413: l_column_id, l_column_id1
414: FROM ITA_SETUP_GROUPS_B setup_gp
415: WHERE setup_gp.TABLE_APP_ID = p_application_id and

Line 440: FROM ita_setup_parameters_b

436: EXIT WHEN c_get_parameters%NOTFOUND;
437:
438: SELECT select_clause, from_clause, where_clause
439: INTO l_select_clause, l_from_clause, l_where_clause
440: FROM ita_setup_parameters_b
441: WHERE parameter_code = l_param_rec.parameter_code;
442:
443: IF l_select_clause IS NOT NULL
444: THEN

Line 624: l_select_clause ITA_SETUP_PARAMETERS_B.SELECT_CLAUSE%TYPE;

620: l_context_param_code2 ITA_SETUP_GROUPS_B.CONTEXT_PARAMETER_CODE2%TYPE;
621: l_column_id NUMBER;
622: l_column_id1 NUMBER;
623: l_del_sql VARCHAR2(32767);
624: l_select_clause ITA_SETUP_PARAMETERS_B.SELECT_CLAUSE%TYPE;
625: l_ins_sql VARCHAR2(32767);
626: l_ins_param_sql VARCHAR2(32767);
627: l_column_name FND_COLUMNS.COLUMN_NAME%TYPE;
628: l_column_name1 FND_COLUMNS.COLUMN_NAME%TYPE;

Line 643: FROM ITA_SETUP_CHANGE_HISTORY isch, ITA_SETUP_PARAMETERS_B isp

639:
640: -- cpetriuc start - bug 5163722
641: CURSOR c_get_profiles_with_sql(p_setup_group_code IN VARCHAR2) IS
642: SELECT isch.CHANGE_ID, isp.SELECT_CLAUSE, isch.CURRENT_VALUE
643: FROM ITA_SETUP_CHANGE_HISTORY isch, ITA_SETUP_PARAMETERS_B isp
644: WHERE
645: isch.SETUP_GROUP_CODE = p_setup_group_code and
646: isch.CURRENT_VALUE is not null and
647: isch.PARAMETER_CODE = isp.PARAMETER_CODE and

Line 680: (SELECT column_id FROM ita_setup_parameters_b WHERE parameter_code = setup_gp.CONTEXT_PARAMETER_CODE) column_id,

676:
677: select setup_gp.SETUP_GROUP_CODE, setup_gp.AUDIT_START_DATE,
678: setup_gp.CONTEXT_PARAMETER_CODE, setup_gp.HIERARCHY_LEVEL hierarchy_level_code,
679: setup_gp.context_parameter_code2,
680: (SELECT column_id FROM ita_setup_parameters_b WHERE parameter_code = setup_gp.CONTEXT_PARAMETER_CODE) column_id,
681: (SELECT column_id FROM ita_setup_parameters_b WHERE parameter_code = setup_gp.CONTEXT_PARAMETER_CODE2) column_id1
682: INTO l_setup_gp_code, l_audit_start_date, l_context_param_code, l_hier_level_code, l_context_param_code2,
683: l_column_id, l_column_id1
684: FROM ITA_SETUP_GROUPS_B setup_gp

Line 681: (SELECT column_id FROM ita_setup_parameters_b WHERE parameter_code = setup_gp.CONTEXT_PARAMETER_CODE2) column_id1

677: select setup_gp.SETUP_GROUP_CODE, setup_gp.AUDIT_START_DATE,
678: setup_gp.CONTEXT_PARAMETER_CODE, setup_gp.HIERARCHY_LEVEL hierarchy_level_code,
679: setup_gp.context_parameter_code2,
680: (SELECT column_id FROM ita_setup_parameters_b WHERE parameter_code = setup_gp.CONTEXT_PARAMETER_CODE) column_id,
681: (SELECT column_id FROM ita_setup_parameters_b WHERE parameter_code = setup_gp.CONTEXT_PARAMETER_CODE2) column_id1
682: INTO l_setup_gp_code, l_audit_start_date, l_context_param_code, l_hier_level_code, l_context_param_code2,
683: l_column_id, l_column_id1
684: FROM ITA_SETUP_GROUPS_B setup_gp
685: WHERE setup_gp.TABLE_APP_ID = p_application_id and

Line 740: -- For all profiles in fnd_profile_options that don't exist in ita_setup_parameters_b and

736: 'parameter_code=''' || l_setup_gp_code || '.''|| (SELECT profile_option_name FROM ' ||
737: 'fnd_profile_options WHERE application_id=bt.application_id and profile_option_id=' ||
738: 'bt.profile_option_id)) rec_code, bt.LEVEL_VALUE_APPLICATION_ID FROM ' || p_table_name || ' bt WHERE bt.profile_option_value is NOT NULL)';
739: EXECUTE IMMEDIATE l_ins_sql;
740: -- For all profiles in fnd_profile_options that don't exist in ita_setup_parameters_b and
741: -- exist in fnd_profile_option_values,
742: -- insert into ita_setup_parameters_b, ita_setup_parameters_tl
743: l_ins_param_sql := 'INSERT INTO ita_setup_parameters_b (PARAMETER_CODE, SETUP_GROUP_CODE, COLUMN_ID, AUDIT_ENABLED_FLAG, COLUMN_REFERENCE1, COLUMN_REFERENCE2, CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE,' ||
744: 'LAST_UPDATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, SELECT_CLAUSE)' ||

Line 742: -- insert into ita_setup_parameters_b, ita_setup_parameters_tl

738: 'bt.profile_option_id)) rec_code, bt.LEVEL_VALUE_APPLICATION_ID FROM ' || p_table_name || ' bt WHERE bt.profile_option_value is NOT NULL)';
739: EXECUTE IMMEDIATE l_ins_sql;
740: -- For all profiles in fnd_profile_options that don't exist in ita_setup_parameters_b and
741: -- exist in fnd_profile_option_values,
742: -- insert into ita_setup_parameters_b, ita_setup_parameters_tl
743: l_ins_param_sql := 'INSERT INTO ita_setup_parameters_b (PARAMETER_CODE, SETUP_GROUP_CODE, COLUMN_ID, AUDIT_ENABLED_FLAG, COLUMN_REFERENCE1, COLUMN_REFERENCE2, CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE,' ||
744: 'LAST_UPDATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, SELECT_CLAUSE)' ||
745: '(SELECT ''' || l_setup_gp_code || '.' || ''' || bt.profile_option_name, ''' || l_setup_gp_code || ''', bt.profile_option_id' || ', ''Y'',' ||
746: 'bt.profile_option_id, bt.application_id, ' || l_user_id || ', sysdate, sysdate, ' || l_user_id ||

Line 743: l_ins_param_sql := 'INSERT INTO ita_setup_parameters_b (PARAMETER_CODE, SETUP_GROUP_CODE, COLUMN_ID, AUDIT_ENABLED_FLAG, COLUMN_REFERENCE1, COLUMN_REFERENCE2, CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE,' ||

739: EXECUTE IMMEDIATE l_ins_sql;
740: -- For all profiles in fnd_profile_options that don't exist in ita_setup_parameters_b and
741: -- exist in fnd_profile_option_values,
742: -- insert into ita_setup_parameters_b, ita_setup_parameters_tl
743: l_ins_param_sql := 'INSERT INTO ita_setup_parameters_b (PARAMETER_CODE, SETUP_GROUP_CODE, COLUMN_ID, AUDIT_ENABLED_FLAG, COLUMN_REFERENCE1, COLUMN_REFERENCE2, CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE,' ||
744: 'LAST_UPDATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, SELECT_CLAUSE)' ||
745: '(SELECT ''' || l_setup_gp_code || '.' || ''' || bt.profile_option_name, ''' || l_setup_gp_code || ''', bt.profile_option_id' || ', ''Y'',' ||
746: 'bt.profile_option_id, bt.application_id, ' || l_user_id || ', sysdate, sysdate, ' || l_user_id ||
747: ', ' || l_login_id || ', 1, ' ||

Line 759: '(SELECT parameter_code FROM ita_setup_parameters_b) AND (bt.profile_option_id, bt.application_id) ' ||

755: -- '(UPPER(REPLACE(substr(sql_validation, instr(upper(sql_validation), ''SELECT ''), (instr(upper(sql_validation), ''"'' || chr(10) || ''COLUMN='') - instr(upper(sql_validation), ''SELECT ''))), ''\"'', ''"''))) select_cl ' ||
756: '(UPPER(REPLACE(substr(sql_validation, instr(upper(sql_validation), ''SELECT''), (1 + length(upper(sql_validation)) - instr(upper(sql_validation), ''SELECT''))), ''\"'', ''"''))) select_cl ' ||
757: -- cpetriuc end - bug 5638086
758: 'FROM fnd_profile_options bt WHERE ''' || l_setup_gp_code || '.' || ''' || bt.profile_option_name NOT IN ' ||
759: '(SELECT parameter_code FROM ita_setup_parameters_b) AND (bt.profile_option_id, bt.application_id) ' ||
760: 'IN (SELECT profile_option_id, application_id from fnd_profile_option_values))';
761: EXECUTE IMMEDIATE l_ins_param_sql;
762: l_ins_param_sql := 'INSERT INTO ita_setup_parameters_tl (PARAMETER_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE,' ||
763: 'LAST_UPDATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, LANGUAGE, SOURCE_LANG, PARAMETER_NAME)' ||

Line 765: 'FROM ita_setup_parameters_b isp, fnd_profile_options_tl prof WHERE ''' || l_setup_gp_code || '.' || ''' || prof.profile_option_name = isp.parameter_code ' ||

761: EXECUTE IMMEDIATE l_ins_param_sql;
762: l_ins_param_sql := 'INSERT INTO ita_setup_parameters_tl (PARAMETER_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE,' ||
763: 'LAST_UPDATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, LANGUAGE, SOURCE_LANG, PARAMETER_NAME)' ||
764: '(SELECT PARAMETER_CODE, isp.CREATED_BY, isp.CREATION_DATE, isp.LAST_UPDATE_DATE, isp.LAST_UPDATED_BY, isp.LAST_UPDATE_LOGIN, 1, prof.language, prof.source_lang, prof.user_profile_option_name ' ||
765: 'FROM ita_setup_parameters_b isp, fnd_profile_options_tl prof WHERE ''' || l_setup_gp_code || '.' || ''' || prof.profile_option_name = isp.parameter_code ' ||
766: 'AND (isp.parameter_code, prof.language) NOT IN (SELECT parameter_code, language from ita_setup_parameters_tl))';
767: EXECUTE IMMEDIATE l_ins_param_sql;
768: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current State fetched for table - ' || p_table_name);
769: ELSE