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.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_USEC_REF_CD

Line 7329: signature of igs_ps_usec_ref_cd_pkg.get_uk_for_validation

7325: smvk 27-Jun-2003 Enh Bug # 2999888. Importing Unit requirements / Unit Section requirements reference codes
7326: jbegum 02-June-2003 Enh#2972950
7327: For Legacy Enhancements TD:
7328: Modified validate_usec_db_cons, changed the impact of change of
7329: signature of igs_ps_usec_ref_cd_pkg.get_uk_for_validation
7330: For PSP Scheduling Enhancements TD:
7331: Modified the local procedure's validate_occur_deri_busi,validate_occur_db_cons.
7332: For PSP Enhancements TD:
7333: Modified validate_occur_db_cons,validate_derivation,validate_unit_db_cons

Line 7683: --Enh#2972950,impact of change of signature of igs_ps_usec_ref_cd_pkg.get_uk_for_validation

7679: BEGIN
7680:
7681: IF p_insert = 'I' THEN
7682: --Unique Key Validation
7683: --Enh#2972950,impact of change of signature of igs_ps_usec_ref_cd_pkg.get_uk_for_validation
7684: IF p_ref_cd_rec.gen_ref_flag = 'Y' THEN -- if generic reference code
7685: IF igs_ps_usec_ref_cd_pkg.get_uk_for_validation(l_n_usec_ref_id,p_ref_cd_rec.reference_cd_type,p_ref_cd_rec.reference_cd) THEN
7686: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS',
7687: igs_ps_validate_lgcy_pkg.get_lkup_meaning('UNIT_SECTION','LEGACY_TOKENS') || ' ' ||

Line 7685: IF igs_ps_usec_ref_cd_pkg.get_uk_for_validation(l_n_usec_ref_id,p_ref_cd_rec.reference_cd_type,p_ref_cd_rec.reference_cd) THEN

7681: IF p_insert = 'I' THEN
7682: --Unique Key Validation
7683: --Enh#2972950,impact of change of signature of igs_ps_usec_ref_cd_pkg.get_uk_for_validation
7684: IF p_ref_cd_rec.gen_ref_flag = 'Y' THEN -- if generic reference code
7685: IF igs_ps_usec_ref_cd_pkg.get_uk_for_validation(l_n_usec_ref_id,p_ref_cd_rec.reference_cd_type,p_ref_cd_rec.reference_cd) THEN
7686: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS',
7687: igs_ps_validate_lgcy_pkg.get_lkup_meaning('UNIT_SECTION','LEGACY_TOKENS') || ' ' ||
7688: igs_ps_validate_lgcy_pkg.get_lkup_meaning('REFERENCE_CD','LEGACY_TOKENS'),
7689: NULL, FALSE);

Line 7791: --For IGS_PS_USEC_REF_CD record

7787:
7788: ---
7789: -- Check for Update/Insert
7790: FUNCTION check_insert_update ( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type ) RETURN VARCHAR2 IS
7791: --For IGS_PS_USEC_REF_CD record
7792: CURSOR c_gen IS
7793: SELECT rc.restricted_flag,ur.reference_code_desc
7794: FROM igs_ps_usec_ref_cd ur, igs_ge_ref_cd_type_all rc
7795: WHERE ur.unit_section_reference_id = l_n_usec_ref_id

Line 7794: FROM igs_ps_usec_ref_cd ur, igs_ge_ref_cd_type_all rc

7790: FUNCTION check_insert_update ( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type ) RETURN VARCHAR2 IS
7791: --For IGS_PS_USEC_REF_CD record
7792: CURSOR c_gen IS
7793: SELECT rc.restricted_flag,ur.reference_code_desc
7794: FROM igs_ps_usec_ref_cd ur, igs_ge_ref_cd_type_all rc
7795: WHERE ur.unit_section_reference_id = l_n_usec_ref_id
7796: AND ur.reference_code_type = p_ref_cd_rec.reference_cd_type
7797: AND ur.reference_code = p_ref_cd_rec.reference_cd
7798: AND ur.reference_code_type=rc.reference_cd_type;

Line 8082: --in the INSERT of table igs_ps_usec_ref_cd

8078: IF p_tab_ref_cd(i).gen_ref_flag = 'Y' THEN -- if generic reference code
8079: --Enh Bug#2972950
8080: --For the PSP Enhancements TD:
8081: --Added the column's reference_code_type,reference_code,reference_code_desc
8082: --in the INSERT of table igs_ps_usec_ref_cd
8083: --Also deleted column reference_code_id in the INSERT of table igs_ps_usec_ref_cd
8084:
8085: -- Creating the unit section refernce code if the datatype is SECTION.
8086: IF l_insert_update = 'I' THEN

Line 8083: --Also deleted column reference_code_id in the INSERT of table igs_ps_usec_ref_cd

8079: --Enh Bug#2972950
8080: --For the PSP Enhancements TD:
8081: --Added the column's reference_code_type,reference_code,reference_code_desc
8082: --in the INSERT of table igs_ps_usec_ref_cd
8083: --Also deleted column reference_code_id in the INSERT of table igs_ps_usec_ref_cd
8084:
8085: -- Creating the unit section refernce code if the datatype is SECTION.
8086: IF l_insert_update = 'I' THEN
8087:

Line 8088: INSERT INTO igs_ps_usec_ref_cd (

8084:
8085: -- Creating the unit section refernce code if the datatype is SECTION.
8086: IF l_insert_update = 'I' THEN
8087:
8088: INSERT INTO igs_ps_usec_ref_cd (
8089: unit_section_reference_cd_id,
8090: unit_section_reference_id,
8091: creation_date,
8092: created_by,

Line 8100: igs_ps_usec_ref_cd_s.nextval,

8096: reference_code_type,
8097: reference_code,
8098: reference_code_desc
8099: ) VALUES (
8100: igs_ps_usec_ref_cd_s.nextval,
8101: l_n_usec_ref_id,
8102: sysdate,
8103: g_n_user_id,
8104: sysdate,

Line 8112: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Inserted_igs_ps_usec_ref_cd',

8108: p_tab_ref_cd(i).reference_cd,
8109: p_tab_ref_cd(i).description
8110: );
8111: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8112: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Inserted_igs_ps_usec_ref_cd',
8113: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
8114: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
8115: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||
8116: 'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||'reference_cd:'||p_tab_ref_cd(i).reference_cd||

Line 8121: UPDATE igs_ps_usec_ref_cd SET reference_code_desc=p_tab_ref_cd(i).description,last_updated_by=g_n_user_id,

8117: ' '||'gen_ref_flag:'||p_tab_ref_cd(i).gen_ref_flag);
8118: END IF;
8119: ELSE
8120:
8121: UPDATE igs_ps_usec_ref_cd SET reference_code_desc=p_tab_ref_cd(i).description,last_updated_by=g_n_user_id,
8122: last_update_date=SYSDATE WHERE unit_section_reference_id=l_n_usec_ref_id AND
8123: reference_code_type=p_tab_ref_cd(i).reference_cd_type AND reference_code=p_tab_ref_cd(i).reference_cd;
8124:
8125: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 8126: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Updated_igs_ps_usec_ref_cd',

8122: last_update_date=SYSDATE WHERE unit_section_reference_id=l_n_usec_ref_id AND
8123: reference_code_type=p_tab_ref_cd(i).reference_cd_type AND reference_code=p_tab_ref_cd(i).reference_cd;
8124:
8125: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8126: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Updated_igs_ps_usec_ref_cd',
8127: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
8128: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
8129: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||
8130: 'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||'reference_cd:'||p_tab_ref_cd(i).reference_cd||