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_AV_LVL_LGCY_PUB dependencies on IGS_PS_UNIT_LEVEL

Line 123: p_s_adv_stnd_unit_level IN igs_ps_unit_level.unit_level%type,

119: */
120: FUNCTION validate_lvl_db_cons
121: (
122: p_person_id IN igs_pe_person.person_id%type,
123: p_s_adv_stnd_unit_level IN igs_ps_unit_level.unit_level%type,
124: p_cal_type IN igs_ca_inst.cal_type%type,
125: p_seq_number IN igs_ca_inst.sequence_number%type,
126: p_auth_pers_id IN igs_pe_person.person_id%type,
127: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,

Line 143: p_unit_level IN igs_ps_unit_level.unit_level%type,

139: */
140: FUNCTION validate_level
141: (
142: p_person_id IN igs_pe_person.person_id%type,
143: p_unit_level IN igs_ps_unit_level.unit_level%type,
144: p_cal_type IN igs_ca_inst.cal_type%type,
145: p_seq_number IN igs_ca_inst.sequence_number%type,
146: p_auth_pers_id IN igs_pe_person.person_id%type,
147: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,

Line 1327: p_s_adv_stnd_unit_level IN igs_ps_unit_level.unit_level%type,

1323:
1324: FUNCTION validate_lvl_db_cons
1325: (
1326: p_person_id IN igs_pe_person.person_id%type,
1327: p_s_adv_stnd_unit_level IN igs_ps_unit_level.unit_level%type,
1328: p_cal_type IN igs_ca_inst.cal_type%type,
1329: p_seq_number IN igs_ca_inst.sequence_number%type,
1330: p_auth_pers_id IN igs_pe_person.person_id%type,
1331: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,

Line 1409: Foreign Key with Table IGS_PS_UNIT_LEVEL

1405: FND_MSG_PUB.ADD;
1406: x_return_status := FALSE;
1407: END IF;
1408: /*
1409: Foreign Key with Table IGS_PS_UNIT_LEVEL
1410: */
1411: IF NOT IGS_PS_UNIT_LEVEL_PKG.GET_PK_FOR_VALIDATION
1412: (
1413: x_unit_level => p_s_adv_stnd_unit_level

Line 1411: IF NOT IGS_PS_UNIT_LEVEL_PKG.GET_PK_FOR_VALIDATION

1407: END IF;
1408: /*
1409: Foreign Key with Table IGS_PS_UNIT_LEVEL
1410: */
1411: IF NOT IGS_PS_UNIT_LEVEL_PKG.GET_PK_FOR_VALIDATION
1412: (
1413: x_unit_level => p_s_adv_stnd_unit_level
1414: ) THEN
1415: FND_MESSAGE.SET_NAME('IGS','IGS_AV_TYPE_MUSTBE_LEVEL');

Line 1530: p_unit_level IN igs_ps_unit_level.unit_level%type,

1526:
1527: FUNCTION validate_level
1528: (
1529: p_person_id IN igs_pe_person.person_id%type,
1530: p_unit_level IN igs_ps_unit_level.unit_level%type,
1531: p_cal_type IN igs_ca_inst.cal_type%type,
1532: p_seq_number IN igs_ca_inst.sequence_number%type,
1533: p_auth_pers_id IN igs_pe_person.person_id%type,
1534: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,