APPS.IGS_DA_TRNS_IMP dependencies on IGS_AV_ADV_STANDING_ALL

Line 473: FROM igs_av_adv_standing_all adv

469:
470: CURSOR c_adv_stnd
471: IS
472: SELECT adv.ROWID, adv.*
473: FROM igs_av_adv_standing_all adv
474: WHERE p_person_id = adv.person_id
475: FOR UPDATE NOWAIT;
476:
477: CURSOR c_adv_unt

Line 527: -- delete records from igs_av_adv_standing_all

523: igs_ad_transcript_pkg.delete_row (l_trans.ROWID);
524: END LOOP;
525: END LOOP;
526:
527: -- delete records from igs_av_adv_standing_all
528:
529:
530: FOR l_adv_stnd_unt IN c_adv_unt
531: LOOP

Line 2342: l_total_exmptn_approved igs_av_adv_standing_all.total_exmptn_approved%TYPE;

2338: | MODIFICATION HISTORY |
2339: | jhanda 11-08-2005 Created |
2340: +===========================================================================*/
2341: x_return_status BOOLEAN := TRUE;
2342: l_total_exmptn_approved igs_av_adv_standing_all.total_exmptn_approved%TYPE;
2343: l_total_exmptn_granted igs_av_adv_standing_all.total_exmptn_granted%TYPE;
2344: l_total_exmptn_perc_grntd igs_av_adv_standing_all.total_exmptn_perc_grntd%TYPE;
2345: l_message_name VARCHAR2 (30);
2346: l_grant_status igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE;

Line 2343: l_total_exmptn_granted igs_av_adv_standing_all.total_exmptn_granted%TYPE;

2339: | jhanda 11-08-2005 Created |
2340: +===========================================================================*/
2341: x_return_status BOOLEAN := TRUE;
2342: l_total_exmptn_approved igs_av_adv_standing_all.total_exmptn_approved%TYPE;
2343: l_total_exmptn_granted igs_av_adv_standing_all.total_exmptn_granted%TYPE;
2344: l_total_exmptn_perc_grntd igs_av_adv_standing_all.total_exmptn_perc_grntd%TYPE;
2345: l_message_name VARCHAR2 (30);
2346: l_grant_status igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE;
2347: BEGIN

Line 2344: l_total_exmptn_perc_grntd igs_av_adv_standing_all.total_exmptn_perc_grntd%TYPE;

2340: +===========================================================================*/
2341: x_return_status BOOLEAN := TRUE;
2342: l_total_exmptn_approved igs_av_adv_standing_all.total_exmptn_approved%TYPE;
2343: l_total_exmptn_granted igs_av_adv_standing_all.total_exmptn_granted%TYPE;
2344: l_total_exmptn_perc_grntd igs_av_adv_standing_all.total_exmptn_perc_grntd%TYPE;
2345: l_message_name VARCHAR2 (30);
2346: l_grant_status igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE;
2347: BEGIN
2348: ecx_debug.push ('IGS_DA_TRNS_IMP.VALIDATE_UNIT');

Line 2526: FROM igs_av_adv_standing_all

2522: +===========================================================================*/
2523: CURSOR c_adv_stnd
2524: IS
2525: SELECT ROWID
2526: FROM igs_av_adv_standing_all
2527: WHERE person_id = p_person_id
2528: AND course_cd = p_program_cd
2529: AND version_number = p_course_version
2530: AND exemption_institution_cd = p_prev_institution_code;

Line 2534: l_total_exmptn_approved igs_av_adv_standing_all.total_exmptn_approved%TYPE;

2530: AND exemption_institution_cd = p_prev_institution_code;
2531:
2532: x_return_status BOOLEAN := TRUE;
2533: l_message VARCHAR2 (2000);
2534: l_total_exmptn_approved igs_av_adv_standing_all.total_exmptn_approved%TYPE;
2535: l_total_exmptn_granted igs_av_adv_standing_all.total_exmptn_granted%TYPE;
2536: l_total_exmptn_perc_grntd igs_av_adv_standing_all.total_exmptn_perc_grntd%TYPE;
2537: l_adv_stnd c_adv_stnd%ROWTYPE;
2538: BEGIN

Line 2535: l_total_exmptn_granted igs_av_adv_standing_all.total_exmptn_granted%TYPE;

2531:
2532: x_return_status BOOLEAN := TRUE;
2533: l_message VARCHAR2 (2000);
2534: l_total_exmptn_approved igs_av_adv_standing_all.total_exmptn_approved%TYPE;
2535: l_total_exmptn_granted igs_av_adv_standing_all.total_exmptn_granted%TYPE;
2536: l_total_exmptn_perc_grntd igs_av_adv_standing_all.total_exmptn_perc_grntd%TYPE;
2537: l_adv_stnd c_adv_stnd%ROWTYPE;
2538: BEGIN
2539: ecx_debug.push ('IGS_DA_TRNS_IMP.CREATE_POST_UNIT');

Line 2536: l_total_exmptn_perc_grntd igs_av_adv_standing_all.total_exmptn_perc_grntd%TYPE;

2532: x_return_status BOOLEAN := TRUE;
2533: l_message VARCHAR2 (2000);
2534: l_total_exmptn_approved igs_av_adv_standing_all.total_exmptn_approved%TYPE;
2535: l_total_exmptn_granted igs_av_adv_standing_all.total_exmptn_granted%TYPE;
2536: l_total_exmptn_perc_grntd igs_av_adv_standing_all.total_exmptn_perc_grntd%TYPE;
2537: l_adv_stnd c_adv_stnd%ROWTYPE;
2538: BEGIN
2539: ecx_debug.push ('IGS_DA_TRNS_IMP.CREATE_POST_UNIT');
2540: x_return_status := TRUE;

Line 2579: update IGS_AV_ADV_STANDING_ALL with above obtained values for

2575: fnd_message.get_string ('IGS', l_message)
2576: );
2577: ELSE -- function returns TRUE
2578: /*
2579: update IGS_AV_ADV_STANDING_ALL with above obtained values for
2580: total_exmptn_approved, total_exmptn_granted and total_exmptn_perc_grntd
2581: */
2582: OPEN c_adv_stnd;
2583: FETCH c_adv_stnd INTO l_adv_stnd;

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

2895: THEN
2896: write_message ('Before IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION'
2897: );
2898:
2899: -- Validate that the current record is already present in the tables IGS_AV_ADV_STANDING_ALL and IGS_AV_STND_UNIT_ALL
2900: IF NOT igs_av_adv_standing_pkg.get_pk_for_validation (x_person_id => l_person_id,
2901: x_course_cd => p_program_cd,
2902: x_version_number => l_as_version_number,
2903: x_exemption_institution_cd => l_prev_institution_code

Line 2906: write_message ('***** INSERT INTO IGS_AV_ADV_STANDING_ALL *****'

2902: x_version_number => l_as_version_number,
2903: x_exemption_institution_cd => l_prev_institution_code
2904: )
2905: THEN
2906: write_message ('***** INSERT INTO IGS_AV_ADV_STANDING_ALL *****'
2907: );
2908:
2909: igs_av_adv_standing_pkg.insert_row (x_rowid => v_rowid,
2910: x_person_id => l_person_id,