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_UNT_LGCY_PUB dependencies on IGS_AV_ADV_STANDING_ALL

Line 1194: l_total_exmptn_approved igs_av_adv_standing_all.total_exmptn_approved%TYPE ;

1190: | jhanda 11-11-2002 Created |
1191: +===========================================================================*/
1192: x_return_status BOOLEAN :=TRUE;
1193: l_message VARCHAR2(2000);
1194: l_total_exmptn_approved igs_av_adv_standing_all.total_exmptn_approved%TYPE ;
1195: l_total_exmptn_granted igs_av_adv_standing_all.total_exmptn_granted%TYPE ;
1196: l_total_exmptn_perc_grntd igs_av_adv_standing_all.total_exmptn_perc_grntd%TYPE ;
1197: BEGIN
1198: x_return_status := TRUE;

Line 1195: l_total_exmptn_granted igs_av_adv_standing_all.total_exmptn_granted%TYPE ;

1191: +===========================================================================*/
1192: x_return_status BOOLEAN :=TRUE;
1193: l_message VARCHAR2(2000);
1194: l_total_exmptn_approved igs_av_adv_standing_all.total_exmptn_approved%TYPE ;
1195: l_total_exmptn_granted igs_av_adv_standing_all.total_exmptn_granted%TYPE ;
1196: l_total_exmptn_perc_grntd igs_av_adv_standing_all.total_exmptn_perc_grntd%TYPE ;
1197: BEGIN
1198: x_return_status := TRUE;
1199: mydebug ('in create_post_unit');

Line 1196: l_total_exmptn_perc_grntd igs_av_adv_standing_all.total_exmptn_perc_grntd%TYPE ;

1192: x_return_status BOOLEAN :=TRUE;
1193: l_message VARCHAR2(2000);
1194: l_total_exmptn_approved igs_av_adv_standing_all.total_exmptn_approved%TYPE ;
1195: l_total_exmptn_granted igs_av_adv_standing_all.total_exmptn_granted%TYPE ;
1196: l_total_exmptn_perc_grntd igs_av_adv_standing_all.total_exmptn_perc_grntd%TYPE ;
1197: BEGIN
1198: x_return_status := TRUE;
1199: mydebug ('in create_post_unit');
1200: /*

Line 1229: update IGS_AV_ADV_STANDING_ALL with above obtained values for

1225: FND_MSG_PUB.ADD;
1226: x_return_status := FALSE;
1227: ELSE -- function returns TRUE
1228: /*
1229: update IGS_AV_ADV_STANDING_ALL with above obtained values for
1230: total_exmptn_approved, total_exmptn_granted and total_exmptn_perc_grntd
1231: */
1232: UPDATE igs_av_adv_standing_all
1233: SET total_exmptn_approved = l_total_exmptn_approved,

Line 1232: UPDATE igs_av_adv_standing_all

1228: /*
1229: update IGS_AV_ADV_STANDING_ALL with above obtained values for
1230: total_exmptn_approved, total_exmptn_granted and total_exmptn_perc_grntd
1231: */
1232: UPDATE igs_av_adv_standing_all
1233: SET total_exmptn_approved = l_total_exmptn_approved,
1234: total_exmptn_granted = l_total_exmptn_granted,
1235: total_exmptn_perc_grntd = l_total_exmptn_perc_grntd
1236: WHERE person_id = p_person_id

Line 1677: -- Validate that the current record is already present in the tables IGS_AV_ADV_STANDING_ALL and IGS_AV_STND_UNIT_ALL

1673: p_version_number => l_as_version_number,
1674: p_lgcy_adstunt_rec => p_lgcy_adstunt_rec
1675: ) THEN
1676: mydebug('Before IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION');
1677: -- Validate that the current record is already present in the tables IGS_AV_ADV_STANDING_ALL and IGS_AV_STND_UNIT_ALL
1678: IF NOT igs_av_adv_standing_pkg.get_pk_for_validation(
1679: x_person_id => l_person_id,
1680: x_course_cd => p_lgcy_adstunt_rec.program_cd ,
1681: x_version_number => l_as_version_number,

Line 1684: mydebug('* INSERT INTO IGS_AV_ADV_STANDING_ALL *');

1680: x_course_cd => p_lgcy_adstunt_rec.program_cd ,
1681: x_version_number => l_as_version_number,
1682: x_exemption_institution_cd => p_lgcy_adstunt_rec.exemption_institution_cd
1683: ) THEN
1684: mydebug('***** INSERT INTO IGS_AV_ADV_STANDING_ALL *****');
1685: INSERT INTO igs_av_adv_standing_all(person_id,
1686: created_by,
1687: creation_date,
1688: last_updated_by,

Line 1685: INSERT INTO igs_av_adv_standing_all(person_id,

1681: x_version_number => l_as_version_number,
1682: x_exemption_institution_cd => p_lgcy_adstunt_rec.exemption_institution_cd
1683: ) THEN
1684: mydebug('***** INSERT INTO IGS_AV_ADV_STANDING_ALL *****');
1685: INSERT INTO igs_av_adv_standing_all(person_id,
1686: created_by,
1687: creation_date,
1688: last_updated_by,
1689: last_update_date,