DBA Data[Home] [Help]

APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_USEC_REF_CD_PKG

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);