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_AV_STND_UNIT_LVL

Line 83: p_s_adv_stnd_unit_level OUT NOCOPY igs_av_stnd_unit_lvl.s_adv_stnd_type%type,

79: PROCEDURE derive_level_data
80: (
81: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type,
82: p_person_id OUT NOCOPY igs_pe_person.person_id%type,
83: p_s_adv_stnd_unit_level OUT NOCOPY igs_av_stnd_unit_lvl.s_adv_stnd_type%type,
84: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%type,
85: p_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%type,
86: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%type,
87: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%type,

Line 118: before entering into the table IGS_AV_STND_UNIT_LVL_ALL

114: RETURN BOOLEAN;
115:
116: /*
117: validate_lvl_db_cons function performs all the data integrity validation
118: before entering into the table IGS_AV_STND_UNIT_LVL_ALL
119: */
120: FUNCTION validate_lvl_db_cons
121: (
122: p_person_id IN igs_pe_person.person_id%type,

Line 138: inserting a record into the table IGS_AV_STND_UNIT_LVL_ALL

134: RETURN BOOLEAN;
135:
136: /*
137: validate_level function performs all the business validations before
138: inserting a record into the table IGS_AV_STND_UNIT_LVL_ALL
139: */
140: FUNCTION validate_level
141: (
142: p_person_id IN igs_pe_person.person_id%type,

Line 157: validations on the table IGS_AV_STND_UNIT_LVL_ALL

153: RETURN BOOLEAN;
154:
155: /*
156: create_post_lvl function performs all the Post Insert business
157: validations on the table IGS_AV_STND_UNIT_LVL_ALL
158: */
159: FUNCTION create_post_lvl
160: (
161: p_person_id IN igs_pe_person.person_id%type,

Line 248: l_s_adv_stnd_unit_level igs_av_stnd_unit_lvl.s_adv_stnd_type%type;

244: l_api_version CONSTANT NUMBER := 1.0;
245:
246: -- variables declared to fetch data from derive_level_data
247: l_person_id igs_pe_person.person_id%type;
248: l_s_adv_stnd_unit_level igs_av_stnd_unit_lvl.s_adv_stnd_type%type;
249: l_cal_type igs_ca_inst.cal_type%type;
250: l_sequence_number igs_ca_inst.sequence_number%type;
251: l_auth_pers_id igs_pe_person.person_id%type;
252: l_unit_details_id igs_ad_term_unitdtls.unit_details_id%type;

Line 326: tables IGS_AV_ADV_STANDING_ALL and IGS_AV_STND_UNIT_LVL_ALL

322: p_lgcy_adstlvl_rec => p_lgcy_adstlvl_rec
323: ) THEN
324: /*
325: Validate that the current record is already present in the
326: tables IGS_AV_ADV_STANDING_ALL and IGS_AV_STND_UNIT_LVL_ALL
327: */
328: /*
329: Check that the Primary Key for the table
330: IGS_AV_ADV_STANDING_ALL does not exists

Line 341: IGS_AV_STND_UNIT_LVL_ALL does not already exist

337: x_exemption_institution_cd => p_lgcy_adstlvl_rec.exemption_institution_cd
338: ) THEN
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,

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 493: insert into IGS_AV_STND_UNIT_LVL_ALL

489: p_course_version => l_as_version_number,
490: p_lgcy_adstlvl_rec => p_lgcy_adstlvl_rec
491: ) THEN
492: /*
493: insert into IGS_AV_STND_UNIT_LVL_ALL
494: */
495: INSERT INTO IGS_AV_STND_UNIT_LVL_ALL (
496: PERSON_ID,
497: AS_COURSE_CD,

Line 495: INSERT INTO IGS_AV_STND_UNIT_LVL_ALL (

491: ) THEN
492: /*
493: insert into IGS_AV_STND_UNIT_LVL_ALL
494: */
495: INSERT INTO IGS_AV_STND_UNIT_LVL_ALL (
496: PERSON_ID,
497: AS_COURSE_CD,
498: AS_VERSION_NUMBER,
499: S_ADV_STND_TYPE,

Line 884: p_s_adv_stnd_unit_level OUT NOCOPY igs_av_stnd_unit_lvl.s_adv_stnd_type%type,

880: PROCEDURE derive_level_data
881: (
882: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type,
883: p_person_id OUT NOCOPY igs_pe_person.person_id%type,
884: p_s_adv_stnd_unit_level OUT NOCOPY igs_av_stnd_unit_lvl.s_adv_stnd_type%type,
885: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%type,
886: p_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%type,
887: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%type,
888: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%type,

Line 1344: IGS_AV_STND_UNIT_LVL_ALL

1340: Created By : smanglm
1341: Date Created on : 2002/11/13
1342: Purpose : validate_lvl_db_cons function performs all the data
1343: integrity validation before entering into the table
1344: IGS_AV_STND_UNIT_LVL_ALL
1345: Know limitations, enhancements or remarks
1346: Change History
1347: Who When What
1348: (reverse chronological order - newest change first)

Line 1366: SELECT IGS_AV_STND_UNIT_LVL_S.NEXTVAL INTO p_av_stnd_unit_lvl_id FROM dual;

1362: x_return_status := TRUE;
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;

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 1546: IGS_AV_STND_UNIT_LVL_ALL

1542: Created By : smanglm
1543: Date Created on : 2002/11/13
1544: Purpose : validate_level function performs all the business
1545: validations before inserting a record into the table
1546: IGS_AV_STND_UNIT_LVL_ALL
1547: Know limitations, enhancements or remarks
1548: Change History
1549: Who When What
1550: (reverse chronological order - newest change first)

Line 1713: IGS_AV_STND_UNIT_LVL_ALL

1709: Created By : smanglm
1710: Date Created on : 2002/11/13
1711: Purpose : create_post_lvl function performs all the Post
1712: Insert business validations on the table
1713: IGS_AV_STND_UNIT_LVL_ALL
1714: Know limitations, enhancements or remarks
1715: Change History
1716: Who When What
1717: (reverse chronological order - newest change first)

Line 1813: Foreign Key with IGS_AV_STND_UNIT_LVL_ALL

1809: x_return_status := 'W';
1810: return x_return_status;
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

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