APPS.IGS_AV_LVL_LGCY_PUB dependencies on IGS_AV_STND_UNIT_LVL_ALL

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