APPS.IGS_AV_LVL_LGCY_PUB dependencies on IGS_AV_STND_UNIT_LVL_PKG

Line 343: IF IGS_AV_STND_UNIT_LVL_PKG.GET_UK_FOR_VALIDATION

339: /*
340: Check that the unique key combination for the table
341: IGS_AV_STND_UNIT_LVL_ALL does not already exist
342: */
343: IF IGS_AV_STND_UNIT_LVL_PKG.GET_UK_FOR_VALIDATION
344: (
345: x_person_id => l_person_id,
346: x_exemption_institution_cd => p_lgcy_adstlvl_rec.exemption_institution_cd,
347: x_unit_details_id => l_unit_details_id,

Line 423: END IF; -- IGS_AV_STND_UNIT_LVL_PKG.GET_UK_FOR_VALIDATION

419: l_skip := 'Y';
420: END IF; -- End of l_av_stnd_unit_lvl_id is not null
421: ELSE
422: l_check := 'Y';
423: END IF; -- IGS_AV_STND_UNIT_LVL_PKG.GET_UK_FOR_VALIDATION
424: ELSE -- IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION
425: l_check := 'N';
426: END IF; -- IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION
427:

Line 1367: IF IGS_AV_STND_UNIT_LVL_PKG.GET_PK_FOR_VALIDATION (p_av_stnd_unit_lvl_id) THEN

1363: /*
1364: primary key validation
1365: */
1366: SELECT IGS_AV_STND_UNIT_LVL_S.NEXTVAL INTO p_av_stnd_unit_lvl_id FROM dual;
1367: IF IGS_AV_STND_UNIT_LVL_PKG.GET_PK_FOR_VALIDATION (p_av_stnd_unit_lvl_id) THEN
1368: FND_MESSAGE.SET_NAME('IGS','IGS_AV_ADV_STND_ALREADY_EXISTS');
1369: FND_MSG_PUB.ADD;
1370: p_av_stnd_unit_lvl_id := NULL;
1371: x_return_status := FALSE;

Line 1815: IF NOT IGS_AV_STND_UNIT_LVL_PKG.GET_PK_FOR_VALIDATION

1811: END IF;
1812: /*
1813: Foreign Key with IGS_AV_STND_UNIT_LVL_ALL
1814: */
1815: IF NOT IGS_AV_STND_UNIT_LVL_PKG.GET_PK_FOR_VALIDATION
1816: (
1817: x_av_stnd_unit_lvl_id => p_av_stnd_unit_lvl_id
1818: ) THEN
1819: FND_MESSAGE.SET_NAME('IGS','IGS_AV_NO_ADV_STND_DET_EXIST');