[Home] [Help]
135:
136: END check_acad_load_adm_rel;
137:
138:
139: PROCEDURE check_enrollment(p_n_person_id igs_fi_parties_v.person_id%TYPE,
140: p_tab_course_cd stdnt_sca_tab,
141: p_tab_ver_num stdnt_sca_ver_num_tab,
142: p_tab_sca_typ stdnt_sca_typ_tab,
143: p_rec_input_param rec_input_param,
157: Who When What
158: ******************************************************************/
159:
160:
161: CURSOR c_sca_status (cp_n_person_id igs_fi_parties_v.person_id%TYPE,
162: cp_c_load_cal_type igs_ca_inst.cal_type%TYPE,
163: cp_n_load_cal_seq_num igs_ca_inst.sequence_number%TYPE,
164: cp_c_sca_status VARCHAR2)
165: IS
292: p_c_sca_att_status := NULL;
293: END IF;
294: END check_enrollment;
295:
296: PROCEDURE generate_log(p_n_person_id igs_fi_parties_v.person_id%TYPE,
297: p_c_credit_number igs_fi_credits.credit_number%TYPE,
298: p_n_amount igs_fi_credits.amount%TYPE,
299: p_c_action VARCHAR2,
300: p_c_payment_cr_num igs_fi_credits.credit_number%TYPE,
315: incorrect token is being logged. Corrected the token
316: ******************************************************************/
317:
318:
319: CURSOR c_person(cp_n_person_id igs_fi_parties_v.person_id%TYPE)
320: IS
321: SELECT person_number, full_name
322: FROM igs_fi_parties_v
323: WHERE person_id = cp_n_person_id;
318:
319: CURSOR c_person(cp_n_person_id igs_fi_parties_v.person_id%TYPE)
320: IS
321: SELECT person_number, full_name
322: FROM igs_fi_parties_v
323: WHERE person_id = cp_n_person_id;
324:
325: CURSOR cur_cr_type_names(cp_credit_type_id igs_fi_cr_types_all.credit_type_id%TYPE) IS
326: SELECT credit_type_name,payment_credit_type_name
485: remarks :
486: Change History
487: Who When What
488: sapanigr 12-Feb-2006 Bug#5018036 - Cursor c_person now queries hz_parties instead of
489: igs_fi_parties_v. (R12 SQL Repository tuning)
490: vchappid 09-Jan-2003 Bug# 2729935, Invalid Value token is removed from all parameters when the
491: input parameter is an invalid value
492: ******************************************************************/
493:
718: END validate_test_mode;
719:
720:
721: PROCEDURE validate_log_parameters(p_rec_input_param rec_input_param,
722: p_n_person_id igs_fi_parties_v.person_id%TYPE,
723: p_n_person_id_grp NUMBER,
724: p_b_ret_status OUT NOCOPY BOOLEAN) AS
725:
726: /******************************************************************
915: END IF;
916: RETURN;
917: END take_action;
918:
919: PROCEDURE prcss_oth_dpsts(p_n_person_id IN igs_fi_parties_v.person_id%TYPE, l_rec_input_param rec_input_param) AS
920: /******************************************************************
921: Created By : Vinay Chappidi
922: Date Created By : 05-DEC-2002
923: Purpose : Processess other deposits
929: vvutukur 10-Apr-2003 Enh#2831554.Internal Credits API Build. Assigned credit type id to a global variable as this global variable
930: value is used to fetch the credit type name and payment credit type name in the local procedure generate_log.
931: ******************************************************************/
932:
933: CURSOR c_oth_dpsts(cp_n_person_id igs_fi_parties_v.person_id%TYPE,
934: cp_c_cr_type_id igs_fi_cr_types.credit_type_id%TYPE,
935: cp_c_fee_cal_type igs_ca_inst.cal_type%TYPE,
936: cp_n_fee_seq_num igs_ca_inst.sequence_number%TYPE)
937: IS
1010:
1011: END IF;
1012: END prcss_oth_dpsts;
1013:
1014: PROCEDURE prcss_enr_dpsts(p_n_person_id IN igs_fi_parties_v.person_id%TYPE, l_rec_input_param rec_input_param) AS
1015: /******************************************************************
1016: Created By : Vinay Chappidi
1017: Date Created By : 05-DEC-2002
1018: Purpose : Processess enrollment deposits
1032: ******************************************************************/
1033:
1034: -- Cursor for fetching all Deposit Transactions of Enrolment Deposit Credit Class
1035: -- with 'Cleared' status and matching credit type if provided
1036: CURSOR c_enr_dpsts(cp_n_person_id igs_fi_parties_v.person_id%TYPE,
1037: cp_n_cr_type_id igs_fi_cr_types.credit_type_id%TYPE)
1038: IS
1039: SELECT crd.credit_id,crd.credit_type_id,
1040: TO_NUMBER(crd.source_transaction_ref) source_transaction_ref,
1056: -- For each Enrollment Deposit Transaction there wiil be an Admission Application Id Attached
1057: -- Get the Admission Application Number for the Admission Application Id
1058: -- With an Admission Application Id, a unique Admission Application Number can be identified for a
1059: -- person incontext
1060: CURSOR c_adm_appl_number(cp_n_person_id igs_fi_parties_v.person_id%TYPE,
1061: cp_n_appl_id igs_ad_appl.application_id%TYPE)
1062: IS
1063: SELECT admission_appl_number, application_type
1064: FROM igs_ad_appl
1081: -- If cp_c_criteria parameter value is 'APPL' then all matching instances for a Admission Application Number,
1082: -- the matching load calendar will be selected.
1083: -- If cp_c_criteria parameter value is 'ALL' then all matching instances excluding for a Admission Application Number,
1084: -- the matching load calendar will be selected.
1085: CURSOR c_appl_number (cp_n_person_id igs_fi_parties_v.person_id%TYPE,
1086: cp_c_adm_application_number NUMBER,
1087: cp_load_cal_type igs_ca_inst.cal_type%TYPE,
1088: cp_load_ci_seq_number igs_ca_inst.cal_type%TYPE,
1089: cp_c_criteria igs_lookup_values.lookup_code%TYPE)