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_CHANGE_HISTORY

Line 379: l_inst_code ITA_SETUP_CHANGE_HISTORY.INSTANCE_CODE%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;
379: l_inst_code ITA_SETUP_CHANGE_HISTORY.INSTANCE_CODE%TYPE;
380: l_rec_val_code_sql VARCHAR2(32767);
381:
382: CURSOR c_get_parameters(p_setup_group_code IN VARCHAR2)
383: IS

Line 393: l_curr_val_code ita_setup_change_history.pk3_value%TYPE;

389: l_param_rec c_get_parameters%ROWTYPE;
390: l_curr_sql VARCHAR2(32767);
391: l_rec_sql VARCHAR2(32767);
392: l_upd_sql VARCHAR2(32767);
393: l_curr_val_code ita_setup_change_history.pk3_value%TYPE;
394: l_rec_val_code ita_setup_change_history.pk5_value%TYPE;
395:
396: BEGIN
397: IF LENGTH(p_table_name) IS NULL

Line 394: l_rec_val_code ita_setup_change_history.pk5_value%TYPE;

390: l_curr_sql VARCHAR2(32767);
391: l_rec_sql VARCHAR2(32767);
392: l_upd_sql VARCHAR2(32767);
393: l_curr_val_code ita_setup_change_history.pk3_value%TYPE;
394: l_rec_val_code ita_setup_change_history.pk5_value%TYPE;
395:
396: BEGIN
397: IF LENGTH(p_table_name) IS NULL
398: THEN

Line 430: l_del_sql := 'delete from ITA_SETUP_CHANGE_HISTORY where INSTANCE_CODE = ''CURRENT'' and SETUP_GROUP_CODE =''' || l_setup_gp_code || '''';

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;
432: SELECT INSTANCE_CODE INTO l_inst_code FROM ITA_SETUP_INSTANCES_B WHERE CURRENT_FLAG='Y';
433: -- l_shadow_table_name := get_shadow_table_prefix(p_table_name);
434: FOR l_param_rec IN c_get_parameters(l_setup_gp_code)

Line 481: -- insert into ita_setup_change_history

477: IF l_setup_gp_code = 'FND' || '.FND_PROFILE_OPTION_VALUES'
478: THEN
479: l_ins_sql := '';
480: END IF;
481: -- insert into ita_setup_change_history
482: IF p_table_name = 'AP_SUPPLIERS'
483: THEN
484: /* pk1 - supplier name
485: pk2 - supplier id */

Line 486: l_ins_sql := 'INSERT INTO ITA_SETUP_CHANGE_HISTORY(INSTANCE_CODE, CHANGE_ID, PARAMETER_CODE, ' ||

482: IF p_table_name = 'AP_SUPPLIERS'
483: THEN
484: /* pk1 - supplier name
485: pk2 - supplier id */
486: l_ins_sql := 'INSERT INTO ITA_SETUP_CHANGE_HISTORY(INSTANCE_CODE, CHANGE_ID, PARAMETER_CODE, ' ||
487: 'SETUP_GROUP_CODE, CHANGE_AUTHOR, CHANGE_DATE, PK2_VALUE, PK3_VALUE, PK1_VALUE, ' ||
488: 'PK5_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ' ||
489: 'LAST_UPDATE_DATE, CURRENT_VALUE, OBJECT_VERSION_NUMBER) ' ||
490: '(SELECT ''' || l_inst_code || ''', ' ||

Line 491: 'ITA_SETUP_CHANGE_HISTORY_S1.NEXTVAL, ''' || l_param_rec.parameter_code || ''', ''' || l_setup_gp_code || ''', ' ||

487: 'SETUP_GROUP_CODE, CHANGE_AUTHOR, CHANGE_DATE, PK2_VALUE, PK3_VALUE, PK1_VALUE, ' ||
488: 'PK5_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ' ||
489: 'LAST_UPDATE_DATE, CURRENT_VALUE, OBJECT_VERSION_NUMBER) ' ||
490: '(SELECT ''' || l_inst_code || ''', ' ||
491: 'ITA_SETUP_CHANGE_HISTORY_S1.NEXTVAL, ''' || l_param_rec.parameter_code || ''', ''' || l_setup_gp_code || ''', ' ||
492: '(SELECT USER_NAME FROM FND_USER WHERE USER_ID=bt.LAST_UPDATED_BY), bt.LAST_UPDATE_DATE, ' ||
493: 'bt.' || l_column_name || ', bt.' || l_param_rec.column_name || ', ' ||
494: '(SELECT VENDOR_NAME FROM AP_SUPPLIERS WHERE VENDOR_ID = bt.' || l_column_name || '), ' ||
495: 'to_char(null), ' || l_user_id || ', sysdate, ' || l_user_id || ', ' || l_login_id || ', sysdate, (' || l_curr_sql || '), 1 obj_ver FROM ' || p_table_name || ' bt WHERE ' ||

Line 514: l_ins_sql := 'INSERT INTO ITA_SETUP_CHANGE_HISTORY(INSTANCE_CODE, CHANGE_ID, PARAMETER_CODE, ' ||

510: pk6 - supplier name
511: pk7 - supplier id
512: pk8 - site name
513: pk9 - site id*/
514: l_ins_sql := 'INSERT INTO ITA_SETUP_CHANGE_HISTORY(INSTANCE_CODE, CHANGE_ID, PARAMETER_CODE, ' ||
515: 'SETUP_GROUP_CODE, CHANGE_AUTHOR, CHANGE_DATE, PK9_VALUE, PK3_VALUE, PK8_VALUE, ' ||
516: 'PK5_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ' ||
517: 'LAST_UPDATE_DATE, PK1_VALUE, PK7_VALUE, PK6_VALUE, PK2_VALUE, CURRENT_VALUE, ' ||
518: 'OBJECT_VERSION_NUMBER) ' ||

Line 520: 'ITA_SETUP_CHANGE_HISTORY_S1.NEXTVAL, ''' || l_param_rec.parameter_code || ''', ''' || l_setup_gp_code || ''', ' ||

516: 'PK5_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ' ||
517: 'LAST_UPDATE_DATE, PK1_VALUE, PK7_VALUE, PK6_VALUE, PK2_VALUE, CURRENT_VALUE, ' ||
518: 'OBJECT_VERSION_NUMBER) ' ||
519: '(SELECT ''' || l_inst_code || ''', ' ||
520: 'ITA_SETUP_CHANGE_HISTORY_S1.NEXTVAL, ''' || l_param_rec.parameter_code || ''', ''' || l_setup_gp_code || ''', ' ||
521: '(SELECT USER_NAME FROM FND_USER WHERE USER_ID=bt.LAST_UPDATED_BY), bt.LAST_UPDATE_DATE, ' ||
522: 'bt.' || l_column_name || ', bt.' || l_param_rec.column_name || ', ' ||
523: '(SELECT VENDOR_SITE_CODE FROM AP_SUPPLIER_SITES_ALL WHERE VENDOR_SITE_ID = bt.' || l_column_name || '), ' ||
524: 'to_char(null), ' || l_user_id || ', sysdate, ' || l_user_id || ', ' || l_login_id || ', sysdate, ' ||

Line 559: l_ins_sql := 'INSERT INTO ITA_SETUP_CHANGE_HISTORY(INSTANCE_CODE, CHANGE_ID, PARAMETER_CODE, ' ||

555: || l_param_rec.parameter_code || ''' and default_flag = ''Y'' and not exists (select recommended_value ' ||
556: ' from ita_setup_rec_values_vl where parameter_code = ''' || l_param_rec.parameter_code || ''' and pk1_value = to_char(bt.' ||
557: l_column_name || ')))) ';
558: l_rec_sql := l_rec_val_code_sql || 'recomm_val';
559: l_ins_sql := 'INSERT INTO ITA_SETUP_CHANGE_HISTORY(INSTANCE_CODE, CHANGE_ID, PARAMETER_CODE, ' ||
560: 'SETUP_GROUP_CODE, CHANGE_AUTHOR, CHANGE_DATE, PK2_VALUE, PK3_VALUE, PK1_VALUE, ' ||
561: 'PK5_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ' ||
562: 'LAST_UPDATE_DATE, CURRENT_VALUE, RECOMMENDED_VALUE, OBJECT_VERSION_NUMBER) ' ||
563: '(SELECT ''' || l_inst_code || ''', ' ||

Line 564: 'ITA_SETUP_CHANGE_HISTORY_S1.NEXTVAL, ''' || l_param_rec.parameter_code || ''', ''' || l_setup_gp_code || ''', ' ||

560: 'SETUP_GROUP_CODE, CHANGE_AUTHOR, CHANGE_DATE, PK2_VALUE, PK3_VALUE, PK1_VALUE, ' ||
561: 'PK5_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ' ||
562: 'LAST_UPDATE_DATE, CURRENT_VALUE, RECOMMENDED_VALUE, OBJECT_VERSION_NUMBER) ' ||
563: '(SELECT ''' || l_inst_code || ''', ' ||
564: 'ITA_SETUP_CHANGE_HISTORY_S1.NEXTVAL, ''' || l_param_rec.parameter_code || ''', ''' || l_setup_gp_code || ''', ' ||
565: '(SELECT USER_NAME FROM FND_USER WHERE USER_ID=bt.LAST_UPDATED_BY), bt.LAST_UPDATE_DATE, ' ||
566: 'bt.' || l_column_name || ', bt.' || l_param_rec.column_name || ', ' ||
567: '(SELECT name FROM ((select distinct org.ORGANIZATION_ID, org.NAME, org_info.ORG_INFORMATION1 type ' ||
568: 'from HR_ALL_ORGANIZATION_UNITS org, HR_ORGANIZATION_INFORMATION org_info ' ||

Line 631: l_inst_code ITA_SETUP_CHANGE_HISTORY.INSTANCE_CODE%TYPE;

627: l_column_name FND_COLUMNS.COLUMN_NAME%TYPE;
628: l_column_name1 FND_COLUMNS.COLUMN_NAME%TYPE;
629: l_user_id NUMBER;
630: l_login_id NUMBER;
631: l_inst_code ITA_SETUP_CHANGE_HISTORY.INSTANCE_CODE%TYPE;
632: l_rec_val_code_sql VARCHAR2(32767);
633:
634: l_curr_sql VARCHAR2(32767);
635: l_rec_sql VARCHAR2(32767);

Line 637: l_curr_val_code ita_setup_change_history.pk3_value%TYPE;

633:
634: l_curr_sql VARCHAR2(32767);
635: l_rec_sql VARCHAR2(32767);
636: l_upd_sql VARCHAR2(32767);
637: l_curr_val_code ita_setup_change_history.pk3_value%TYPE;
638: l_rec_val_code ita_setup_change_history.pk5_value%TYPE;
639:
640: -- cpetriuc start - bug 5163722
641: CURSOR c_get_profiles_with_sql(p_setup_group_code IN VARCHAR2) IS

Line 638: l_rec_val_code ita_setup_change_history.pk5_value%TYPE;

634: l_curr_sql VARCHAR2(32767);
635: l_rec_sql VARCHAR2(32767);
636: l_upd_sql VARCHAR2(32767);
637: l_curr_val_code ita_setup_change_history.pk3_value%TYPE;
638: l_rec_val_code ita_setup_change_history.pk5_value%TYPE;
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

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 708: l_del_sql := 'delete from ITA_SETUP_CHANGE_HISTORY where INSTANCE_CODE = ''CURRENT'' and SETUP_GROUP_CODE =''' || l_setup_gp_code || '''';

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;
710: SELECT INSTANCE_CODE INTO l_inst_code FROM ITA_SETUP_INSTANCES_B WHERE CURRENT_FLAG='Y';
711: /* pk1 - level id
712: pk2 - level value

Line 715: l_ins_sql := 'INSERT INTO ITA_SETUP_CHANGE_HISTORY(INSTANCE_CODE, CHANGE_ID, PARAMETER_CODE,' ||

711: /* pk1 - level id
712: pk2 - level value
713: pk6 - level value name
714: pk10 - level value application id */
715: l_ins_sql := 'INSERT INTO ITA_SETUP_CHANGE_HISTORY(INSTANCE_CODE, CHANGE_ID, PARAMETER_CODE,' ||
716: 'SETUP_GROUP_CODE, CHANGE_AUTHOR, CHANGE_DATE, PK2_VALUE, PK3_VALUE, PK1_VALUE, ' ||
717: 'CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ' ||
718: 'LAST_UPDATE_DATE, PK6_VALUE, OBJECT_VERSION_NUMBER, CURRENT_VALUE, RECOMMENDED_VALUE, PK5_VALUE, PK10_VALUE) ' ||
719: '(SELECT /*+ PARALLEL(bt) */''' || l_inst_code || ''', ' || 'ITA_SETUP_CHANGE_HISTORY_S1.NEXTVAL, ''' ||

Line 719: '(SELECT /+ PARALLEL(bt) /''' || l_inst_code || ''', ' || 'ITA_SETUP_CHANGE_HISTORY_S1.NEXTVAL, ''' ||

715: l_ins_sql := 'INSERT INTO ITA_SETUP_CHANGE_HISTORY(INSTANCE_CODE, CHANGE_ID, PARAMETER_CODE,' ||
716: 'SETUP_GROUP_CODE, CHANGE_AUTHOR, CHANGE_DATE, PK2_VALUE, PK3_VALUE, PK1_VALUE, ' ||
717: 'CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ' ||
718: 'LAST_UPDATE_DATE, PK6_VALUE, OBJECT_VERSION_NUMBER, CURRENT_VALUE, RECOMMENDED_VALUE, PK5_VALUE, PK10_VALUE) ' ||
719: '(SELECT /*+ PARALLEL(bt) */''' || l_inst_code || ''', ' || 'ITA_SETUP_CHANGE_HISTORY_S1.NEXTVAL, ''' ||
720: l_setup_gp_code || '.''|| (SELECT profile_option_name FROM fnd_profile_options WHERE application_id=bt.application_id and profile_option_id=bt.profile_option_id), ''' ||
721: l_setup_gp_code || ''', ' ||
722: '(SELECT USER_NAME FROM FND_USER WHERE USER_ID=bt.LAST_UPDATED_BY) change_author, bt.LAST_UPDATE_DATE, ' ||
723: 'bt.LEVEL_VALUE, bt.PROFILE_OPTION_VALUE, bt.LEVEL_ID, ' ||

Line 832: l_update_sql := 'UPDATE ITA_SETUP_CHANGE_HISTORY SET CURRENT_VALUE = ''' || l_profile_value_meaning || ''' WHERE CHANGE_ID = ' || l_change_id;

828: BEGIN
829:
830: l_profile_value_meaning := get_profile_value_meaning(l_profile_sql, l_profile_value_code);
831:
832: l_update_sql := 'UPDATE ITA_SETUP_CHANGE_HISTORY SET CURRENT_VALUE = ''' || l_profile_value_meaning || ''' WHERE CHANGE_ID = ' || l_change_id;
833: EXECUTE IMMEDIATE l_update_sql;
834:
835: EXCEPTION
836: WHEN OTHERS THEN fnd_file.PUT_LINE(fnd_file.LOG, SUBSTR(SQLERRM, 1, 2000));