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.

[Home] [Help]

APPS.IGS_DA_TRNS_IMP dependencies on IGS_AV_STND_UNIT_ALL

Line 466: FROM igs_av_stnd_unit_all unt

462: p_unit_details_id igs_ad_term_unitdtls.unit_details_id%TYPE
463: )
464: IS
465: SELECT unt.ROWID, unt.*
466: FROM igs_av_stnd_unit_all unt
467: WHERE unit_details_id = p_unit_details_id
468: FOR UPDATE NOWAIT;
469:
470: CURSOR c_adv_stnd

Line 480: FROM igs_av_stnd_unit_all unt

476:
477: CURSOR c_adv_unt
478: IS
479: SELECT unt.ROWID, unt.*
480: FROM igs_av_stnd_unit_all unt
481: WHERE p_person_id = unt.person_id
482: FOR UPDATE NOWAIT;
483:
484: CURSOR c_adv_unt_basis(cp_AV_STND_UNIT_ID IGS_AV_STD_UNT_BASIS_ALL.AV_STND_UNIT_ID%type)

Line 1619: RETURN igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE

1615: ********************************************************************/
1616: FUNCTION get_adv_stnd_granting_status (
1617: p_batch_id igs_da_rqst.batch_id%TYPE
1618: )
1619: RETURN igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE
1620: IS
1621: CURSOR c_ftr_val
1622: IS
1623: SELECT feature_value

Line 1758: p_s_adv_stnd_type IN OUT NOCOPY igs_av_stnd_unit_all.s_adv_stnd_type%TYPE,

1754: p_load_cal_alt_code IN igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,
1755: p_avstnd_grade IN igs_av_lgcy_unt_int.grade%TYPE,
1756: p_achievable_credit_points IN OUT NOCOPY igs_av_lgcy_unt_int.achievable_credit_points%TYPE,
1757: p_person_id IN OUT NOCOPY igs_pe_person.person_id%TYPE,
1758: p_s_adv_stnd_type IN OUT NOCOPY igs_av_stnd_unit_all.s_adv_stnd_type%TYPE,
1759: p_cal_type IN OUT NOCOPY igs_ca_inst.cal_type%TYPE,
1760: p_seq_number IN OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
1761: p_auth_pers_id IN OUT NOCOPY igs_pe_person.person_id%TYPE,
1762: p_as_version_number IN OUT NOCOPY igs_en_stdnt_ps_att.version_number%TYPE

Line 2335: | inserting a record into the table IGS_AV_STND_UNIT_ALL and|

2331: | validate_unit |
2332: | |
2333: | DESCRIPTION |
2334: | This function performs all the business validations before |
2335: | inserting a record into the table IGS_AV_STND_UNIT_ALL and|
2336: | keeps adding error message to stack as an when it encounters.|
2337: | |
2338: | MODIFICATION HISTORY |
2339: | jhanda 11-08-2005 Created |

Line 2346: l_grant_status igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE;

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');
2349:
2350: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')

Line 2642: l_s_adv_stnd_type igs_av_stnd_unit_all.s_adv_stnd_type%TYPE;

2638: l_api_version CONSTANT NUMBER := 1.0;
2639: l_ret_status BOOLEAN;
2640: l_b_av_stnd_alt_unit_pk_exist BOOLEAN := TRUE;
2641: l_person_id igs_pe_person.person_id%TYPE;
2642: l_s_adv_stnd_type igs_av_stnd_unit_all.s_adv_stnd_type%TYPE;
2643: l_cal_type igs_ca_inst.cal_type%TYPE;
2644: l_seq_number igs_ca_inst.sequence_number%TYPE;
2645: l_auth_pers_id igs_pe_person.person_id%TYPE;
2646: l_as_version_number igs_en_stdnt_ps_att.version_number%TYPE;

Line 2647: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;

2643: l_cal_type igs_ca_inst.cal_type%TYPE;
2644: l_seq_number igs_ca_inst.sequence_number%TYPE;
2645: l_auth_pers_id igs_pe_person.person_id%TYPE;
2646: l_as_version_number igs_en_stdnt_ps_att.version_number%TYPE;
2647: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;
2648: l_request_id igs_av_stnd_unit_all.request_id%TYPE;
2649: l_program_id igs_av_stnd_unit_all.program_id%TYPE;
2650: l_program_application_id igs_av_stnd_unit_all.program_application_id%TYPE;
2651: l_program_update_date igs_av_stnd_unit_all.program_update_date%TYPE;

Line 2648: l_request_id igs_av_stnd_unit_all.request_id%TYPE;

2644: l_seq_number igs_ca_inst.sequence_number%TYPE;
2645: l_auth_pers_id igs_pe_person.person_id%TYPE;
2646: l_as_version_number igs_en_stdnt_ps_att.version_number%TYPE;
2647: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;
2648: l_request_id igs_av_stnd_unit_all.request_id%TYPE;
2649: l_program_id igs_av_stnd_unit_all.program_id%TYPE;
2650: l_program_application_id igs_av_stnd_unit_all.program_application_id%TYPE;
2651: l_program_update_date igs_av_stnd_unit_all.program_update_date%TYPE;
2652: duplicate_record_exists EXCEPTION;

Line 2649: l_program_id igs_av_stnd_unit_all.program_id%TYPE;

2645: l_auth_pers_id igs_pe_person.person_id%TYPE;
2646: l_as_version_number igs_en_stdnt_ps_att.version_number%TYPE;
2647: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;
2648: l_request_id igs_av_stnd_unit_all.request_id%TYPE;
2649: l_program_id igs_av_stnd_unit_all.program_id%TYPE;
2650: l_program_application_id igs_av_stnd_unit_all.program_application_id%TYPE;
2651: l_program_update_date igs_av_stnd_unit_all.program_update_date%TYPE;
2652: duplicate_record_exists EXCEPTION;
2653: l_granted_dt igs_av_stnd_unit_all.granted_dt%TYPE

Line 2650: l_program_application_id igs_av_stnd_unit_all.program_application_id%TYPE;

2646: l_as_version_number igs_en_stdnt_ps_att.version_number%TYPE;
2647: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;
2648: l_request_id igs_av_stnd_unit_all.request_id%TYPE;
2649: l_program_id igs_av_stnd_unit_all.program_id%TYPE;
2650: l_program_application_id igs_av_stnd_unit_all.program_application_id%TYPE;
2651: l_program_update_date igs_av_stnd_unit_all.program_update_date%TYPE;
2652: duplicate_record_exists EXCEPTION;
2653: l_granted_dt igs_av_stnd_unit_all.granted_dt%TYPE
2654: := NULL;

Line 2651: l_program_update_date igs_av_stnd_unit_all.program_update_date%TYPE;

2647: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;
2648: l_request_id igs_av_stnd_unit_all.request_id%TYPE;
2649: l_program_id igs_av_stnd_unit_all.program_id%TYPE;
2650: l_program_application_id igs_av_stnd_unit_all.program_application_id%TYPE;
2651: l_program_update_date igs_av_stnd_unit_all.program_update_date%TYPE;
2652: duplicate_record_exists EXCEPTION;
2653: l_granted_dt igs_av_stnd_unit_all.granted_dt%TYPE
2654: := NULL;
2655: l_unit_cd igs_av_lgcy_unt_int.unit_cd%TYPE; --- advstnd unit

Line 2653: l_granted_dt igs_av_stnd_unit_all.granted_dt%TYPE

2649: l_program_id igs_av_stnd_unit_all.program_id%TYPE;
2650: l_program_application_id igs_av_stnd_unit_all.program_application_id%TYPE;
2651: l_program_update_date igs_av_stnd_unit_all.program_update_date%TYPE;
2652: duplicate_record_exists EXCEPTION;
2653: l_granted_dt igs_av_stnd_unit_all.granted_dt%TYPE
2654: := NULL;
2655: l_unit_cd igs_av_lgcy_unt_int.unit_cd%TYPE; --- advstnd unit
2656: l_version_number igs_av_lgcy_unt_int.version_number%TYPE;
2657: l_person_number igs_av_lgcy_unt_int.person_number%TYPE;

Line 2702: FROM igs_av_stnd_unit_all unt

2698: cp_s_adv_stnd_type VARCHAR2
2699: )
2700: IS
2701: SELECT unt.ROWID, unt.*
2702: FROM igs_av_stnd_unit_all unt
2703: WHERE person_id = cp_person_id
2704: AND exemption_institution_cd = cp_exemption_institution_cd
2705: AND unit_details_id = cp_unit_details_id
2706: AND unit_cd = cp_unit_cd

Line 2724: l_grant_status igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE;

2720:
2721:
2722:
2723: l_adv_stnd_unt c_adv_stnd_unt%ROWTYPE;
2724: l_grant_status igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE;
2725: v_dummy hz_parties.party_id%TYPE;
2726: v_rowid ROWID;
2727: BEGIN
2728: write_message (' p_batch_id => ' || p_batch_id);

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 2990: write_message ('* INSERT INTO IGS_AV_STND_UNIT_ALL *'

2986:
2987: write_message ( '***** l_av_stnd_unit_lvl_id='
2988: || l_av_stnd_unit_lvl_id
2989: );
2990: write_message ('***** INSERT INTO IGS_AV_STND_UNIT_ALL *****'
2991: );
2992: DECLARE
2993: CURSOR c_unitcd_ver
2994: IS

Line 3114: write_message ( ' Inserted into IGS_AV_STND_UNIT_ALL val AV_STND_UNIT_ID ='

3110: CLOSE c_unitcd_ver;
3111: END;
3112: END IF;
3113:
3114: write_message ( ' Inserted into IGS_AV_STND_UNIT_ALL val AV_STND_UNIT_ID ='
3115: || l_av_stnd_unit_lvl_id
3116: );
3117: ELSE -- validate_unit
3118: write_message ('Error 3');

Line 3126: write_message (' Updating igs_av_stnd_unit_all');

3122: l_return_status := fnd_api.g_ret_sts_error;
3123: write_message ('Error 4');
3124: END IF; --validate_std_unt_db_cons
3125: ELSE
3126: write_message (' Updating igs_av_stnd_unit_all');
3127: OPEN c_adv_stnd_unt (l_person_id,
3128: l_prev_institution_code,
3129: p_unit_details_id,
3130: l_unit_cd,