APPS.IGS_AV_LVL_LGCY_PUB dependencies on IGS_AV_ADV_STANDING_PKG

Line 332: IF IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION

328: /*
329: Check that the Primary Key for the table
330: IGS_AV_ADV_STANDING_ALL does not exists
331: */
332: IF IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION
333: (
334: x_person_id => l_person_id,
335: x_course_cd => p_lgcy_adstlvl_rec.program_cd,
336: x_version_number => l_as_version_number,

Line 424: ELSE -- IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION

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:
428: IF l_skip = 'N' THEN

Line 426: END IF; -- IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION

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:
428: IF l_skip = 'N' THEN
429: IF l_check = 'N' THEN
430: -- insert into IGS_AV_ADV_STANDING_ALL

Line 1375: Foreign Key with Table IGS_AV_ADV_STANDING_PKG

1371: x_return_status := FALSE;
1372: END IF;
1373:
1374: /*
1375: Foreign Key with Table IGS_AV_ADV_STANDING_PKG
1376: */
1377: IF NOT IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION
1378: (
1379: x_person_id => p_person_id,

Line 1377: IF NOT IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION

1373:
1374: /*
1375: Foreign Key with Table IGS_AV_ADV_STANDING_PKG
1376: */
1377: IF NOT IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION
1378: (
1379: x_person_id => p_person_id,
1380: x_course_cd => p_lgcy_adstlvl_rec.program_cd,
1381: x_version_number => p_course_version,