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

Line 4286: igs_ps_usec_ref_pkg.check_constraints ( 'EXCLUDE_FROM_MAX_CP_LIMIT', p_usec_rec.exclude_from_max_cp_limit);

4282: END IF;
4283:
4284: IF p_usec_rec.exclude_from_max_cp_limit IS NOT NULL THEN
4285: BEGIN
4286: igs_ps_usec_ref_pkg.check_constraints ( 'EXCLUDE_FROM_MAX_CP_LIMIT', p_usec_rec.exclude_from_max_cp_limit);
4287: EXCEPTION
4288: WHEN OTHERS THEN
4289: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'EXCLUDE_FROM_MAX_CP_LIMIT', 'LEGACY_TOKENS', TRUE);
4290: p_usec_rec.status := 'E';

Line 4664: IF igs_ps_usec_ref_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN

4660: PROCEDURE validate_ref_db_cons ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,p_insert_update VARCHAR2 ) AS
4661: BEGIN
4662: IF p_insert_update = 'I' THEN
4663: /* Check for Unique Key Constraints */
4664: IF igs_ps_usec_ref_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN
4665: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'UNIT_SEC_REF', 'LEGACY_TOKENS', FALSE);
4666: p_usec_rec.status := 'W';
4667: RETURN;
4668: END IF;

Line 4681: igs_ps_usec_ref_pkg.check_constraints ( 'REFERENCE_SUBTITLE_MOD_FLAG', p_usec_rec.reference_subtitle_mod_flag);

4677:
4678:
4679: IF p_usec_rec.reference_subtitle_mod_flag IS NOT NULL THEN
4680: BEGIN
4681: igs_ps_usec_ref_pkg.check_constraints ( 'REFERENCE_SUBTITLE_MOD_FLAG', p_usec_rec.reference_subtitle_mod_flag);
4682: EXCEPTION
4683: WHEN OTHERS THEN
4684: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'REFERENCE_SUBTITLE_MOD_FLAG', 'LEGACY_TOKENS', TRUE);
4685: p_usec_rec.status := 'E';

Line 4691: igs_ps_usec_ref_pkg.check_constraints ( 'REFERENCE_CLASS_SCH_EXCL_FLAG', p_usec_rec.reference_class_sch_excl_flag);

4687: END IF;
4688:
4689: IF p_usec_rec.reference_class_sch_excl_flag IS NOT NULL THEN
4690: BEGIN
4691: igs_ps_usec_ref_pkg.check_constraints ( 'REFERENCE_CLASS_SCH_EXCL_FLAG', p_usec_rec.reference_class_sch_excl_flag);
4692: EXCEPTION
4693: WHEN OTHERS THEN
4694: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'REFERENCE_CLASS_SCH_EXCL_FLAG', 'LEGACY_TOKENS', TRUE);
4695: p_usec_rec.status := 'E';

Line 4701: igs_ps_usec_ref_pkg.check_constraints ( 'REFERENCE_REC_EXCLUSION_FLAG', p_usec_rec.reference_rec_exclusion_flag);

4697: END IF;
4698:
4699: IF p_usec_rec.reference_rec_exclusion_flag IS NOT NULL THEN
4700: BEGIN
4701: igs_ps_usec_ref_pkg.check_constraints ( 'REFERENCE_REC_EXCLUSION_FLAG', p_usec_rec.reference_rec_exclusion_flag);
4702: EXCEPTION
4703: WHEN OTHERS THEN
4704: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'REFERENCE_REC_EXCLUSION_FLAG', 'LEGACY_TOKENS', TRUE);
4705: p_usec_rec.status := 'E';

Line 4720: FROM igs_ps_usec_ref

4716: FUNCTION check_insert_update (p_usec_rec IN igs_ps_generic_pub.usec_rec_type ) RETURN VARCHAR2 IS
4717:
4718: CURSOR c_usec_ref(p_n_uoo_id NUMBER) IS
4719: SELECT 'X'
4720: FROM igs_ps_usec_ref
4721: WHERE uoo_id = p_n_uoo_id;
4722:
4723: c_usec_ref_rec c_usec_ref%ROWTYPE;
4724: BEGIN

Line 4742: FROM igs_ps_usec_ref

4738: PROCEDURE Assign_default( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
4739: p_insert_update VARCHAR2 ) AS
4740: CURSOR c_usec_ref(p_n_uoo_id NUMBER) IS
4741: SELECT *
4742: FROM igs_ps_usec_ref
4743: WHERE uoo_id = p_n_uoo_id;
4744:
4745: c_usec_ref_rec c_usec_ref%ROWTYPE;
4746: BEGIN

Line 4973: INSERT INTO igs_ps_usec_ref

4969:
4970: IF ( p_usec_rec.status = 'S' ) THEN
4971: IF l_insert_update = 'I' THEN
4972: /* Insert Record */
4973: INSERT INTO igs_ps_usec_ref
4974: (unit_section_reference_id,
4975: uoo_id,
4976: short_title,
4977: subtitle,

Line 5012: (igs_ps_usec_ref_s.NEXTVAL,

5008: title,
5009: subtitle_id
5010: )
5011: VALUES
5012: (igs_ps_usec_ref_s.NEXTVAL,
5013: l_n_uoo_id,
5014: p_usec_rec.reference_short_title,
5015: p_usec_rec.reference_subtitle,
5016: p_usec_rec.reference_subtitle_mod_flag,

Line 5058: UPDATE igs_ps_usec_ref SET

5054: p_usec_rec.unit_class);
5055: END IF;
5056:
5057: ELSE ---update
5058: UPDATE igs_ps_usec_ref SET
5059: short_title =p_usec_rec.reference_short_title,
5060: subtitle =p_usec_rec.reference_subtitle,
5061: subtitle_modifiable_flag =p_usec_rec.reference_subtitle_mod_flag,
5062: class_schedule_exclusion_flag =p_usec_rec.reference_class_sch_excl_flag,

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 7342: l_n_usec_ref_id igs_ps_usec_ref.unit_section_reference_id%TYPE; -- Holds Unit Section Reference Identifier

7338:
7339: l_c_cal_type igs_ca_inst_all.cal_type%TYPE; -- Holds Calendar Type
7340: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE; -- Holds Calendar Instance Sequence Number
7341: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE; -- Holds Unit Offering Options Identifier
7342: l_n_usec_ref_id igs_ps_usec_ref.unit_section_reference_id%TYPE; -- Holds Unit Section Reference Identifier
7343: l_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE; -- Holds the Unit Section Occurrence Identifier
7344:
7345: --
7346: l_insert_update VARCHAR2(1);

Line 7451: FROM igs_ps_usec_ref A

7447: PROCEDURE validate_usec_derivations( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type) AS
7448:
7449: CURSOR c_usec_ref_id (cp_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
7450: SELECT A.unit_section_reference_id
7451: FROM igs_ps_usec_ref A
7452: WHERE A.uoo_id = cp_uoo_id;
7453:
7454: l_d_start igs_ca_inst_all.start_dt%TYPE;
7455: l_d_end igs_ca_inst_all.end_dt%TYPE;

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 7721: IF NOT igs_ps_usec_ref_pkg.get_pk_for_validation(l_n_usec_ref_id) THEN

7717: END IF;
7718: CLOSE c_res_flag;
7719:
7720: -- Foreign Key Validation : Unit Section doesn't exists
7721: IF NOT igs_ps_usec_ref_pkg.get_pk_for_validation(l_n_usec_ref_id) THEN
7722: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS',
7723: igs_ps_validate_lgcy_pkg.get_lkup_meaning('UNIT_SECTION','LEGACY_TOKENS') || ' ' ||
7724: igs_ps_validate_lgcy_pkg.get_lkup_meaning('REFERENCE_CD','LEGACY_TOKENS'),
7725: 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||