APPS.IGS_AV_LVL_LGCY_PUB dependencies on IGS_AV_ADV_STANDING_ALL

Line 106: inserting a record in the table IGS_AV_ADV_STANDING_ALL

102: RETURN BOOLEAN;
103:
104: /*
105: validate_adv_stnd function validates all the business rules before
106: inserting a record in the table IGS_AV_ADV_STANDING_ALL
107: */
108: FUNCTION validate_adv_stnd
109: (
110: 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 330: IGS_AV_ADV_STANDING_ALL does not exists

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
331: */
332: IF IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION
333: (
334: x_person_id => l_person_id,

Line 430: -- insert into IGS_AV_ADV_STANDING_ALL

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
431: INSERT INTO IGS_AV_ADV_STANDING_ALL (
432: PERSON_ID,
433: COURSE_CD,
434: VERSION_NUMBER,

Line 431: INSERT INTO IGS_AV_ADV_STANDING_ALL (

427:
428: IF l_skip = 'N' THEN
429: IF l_check = 'N' THEN
430: -- insert into IGS_AV_ADV_STANDING_ALL
431: INSERT INTO IGS_AV_ADV_STANDING_ALL (
432: PERSON_ID,
433: COURSE_CD,
434: VERSION_NUMBER,
435: TOTAL_EXMPTN_APPROVED,

Line 1162: IGS_AV_ADV_STANDING_ALL

1158: Created By : smanglm
1159: Date Created on : 2002/11/13
1160: Purpose : validate_adv_stnd function validates all the business
1161: rules before inserting a record in the table
1162: IGS_AV_ADV_STANDING_ALL
1163: Know limitations, enhancements or remarks
1164: Change History
1165: Who When What
1166: (reverse chronological order - newest change first)

Line 1758: update IGS_AV_ADV_STANDING_ALL with above obtained values for

1754: FND_MSG_PUB.ADD;
1755: x_return_status := FALSE;
1756: END IF; -- function returns TRUE
1757: /*
1758: update IGS_AV_ADV_STANDING_ALL with above obtained values for
1759: total_exmptn_approved, total_exmptn_granted and total_exmptn_perc_grntd
1760: */
1761: IF x_return_status THEN
1762: UPDATE IGS_AV_ADV_STANDING_ALL

Line 1762: UPDATE IGS_AV_ADV_STANDING_ALL

1758: update IGS_AV_ADV_STANDING_ALL with above obtained values for
1759: total_exmptn_approved, total_exmptn_granted and total_exmptn_perc_grntd
1760: */
1761: IF x_return_status THEN
1762: UPDATE IGS_AV_ADV_STANDING_ALL
1763: SET TOTAL_EXMPTN_APPROVED = l_total_exmptn_approved,
1764: TOTAL_EXMPTN_GRANTED = l_total_exmptn_granted,
1765: TOTAL_EXMPTN_PERC_GRNTD = l_total_exmptn_perc_grntd
1766: WHERE PERSON_ID = p_person_id