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_FI_PRC_STDNT_DPSTS dependencies on IGS_CA_INST

Line 75: load_cal_type igs_ca_inst.cal_type%TYPE,

71:
72:
73: TYPE rec_input_param IS RECORD ( credit_class igs_fi_cr_types.credit_class%TYPE,
74: credit_type_id igs_fi_cr_types.credit_type_id%TYPE,
75: load_cal_type igs_ca_inst.cal_type%TYPE,
76: load_cal_seq_num igs_ca_inst.sequence_number%TYPE,
77: fee_cal_type igs_ca_inst.cal_type%TYPE,
78: fee_cal_seq_num igs_ca_inst.sequence_number%TYPE,
79: gl_date DATE,

Line 76: load_cal_seq_num igs_ca_inst.sequence_number%TYPE,

72:
73: TYPE rec_input_param IS RECORD ( credit_class igs_fi_cr_types.credit_class%TYPE,
74: credit_type_id igs_fi_cr_types.credit_type_id%TYPE,
75: load_cal_type igs_ca_inst.cal_type%TYPE,
76: load_cal_seq_num igs_ca_inst.sequence_number%TYPE,
77: fee_cal_type igs_ca_inst.cal_type%TYPE,
78: fee_cal_seq_num igs_ca_inst.sequence_number%TYPE,
79: gl_date DATE,
80: test_mode VARCHAR2(1));

Line 77: fee_cal_type igs_ca_inst.cal_type%TYPE,

73: TYPE rec_input_param IS RECORD ( credit_class igs_fi_cr_types.credit_class%TYPE,
74: credit_type_id igs_fi_cr_types.credit_type_id%TYPE,
75: load_cal_type igs_ca_inst.cal_type%TYPE,
76: load_cal_seq_num igs_ca_inst.sequence_number%TYPE,
77: fee_cal_type igs_ca_inst.cal_type%TYPE,
78: fee_cal_seq_num igs_ca_inst.sequence_number%TYPE,
79: gl_date DATE,
80: test_mode VARCHAR2(1));
81:

Line 78: fee_cal_seq_num igs_ca_inst.sequence_number%TYPE,

74: credit_type_id igs_fi_cr_types.credit_type_id%TYPE,
75: load_cal_type igs_ca_inst.cal_type%TYPE,
76: load_cal_seq_num igs_ca_inst.sequence_number%TYPE,
77: fee_cal_type igs_ca_inst.cal_type%TYPE,
78: fee_cal_seq_num igs_ca_inst.sequence_number%TYPE,
79: gl_date DATE,
80: test_mode VARCHAR2(1));
81:
82: FUNCTION check_acad_load_adm_rel(p_c_load_cal_type VARCHAR2,

Line 101: CURSOR c_check_rel(cp_c_load_cal_type igs_ca_inst.cal_type%TYPE,cp_n_load_ci_seq_num igs_ca_inst.sequence_number%TYPE,

97: Who When What
98: ******************************************************************/
99:
100:
101: CURSOR c_check_rel(cp_c_load_cal_type igs_ca_inst.cal_type%TYPE,cp_n_load_ci_seq_num igs_ca_inst.sequence_number%TYPE,
102: cp_c_acad_cal_type igs_ca_inst.cal_type%TYPE,cp_n_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE,
103: cp_c_adm_cal_type igs_ca_inst.cal_type%TYPE,cp_n_adm_ci_seq_num igs_ca_inst.sequence_number%TYPE)
104: IS
105: SELECT 'X'

Line 102: cp_c_acad_cal_type igs_ca_inst.cal_type%TYPE,cp_n_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE,

98: ******************************************************************/
99:
100:
101: CURSOR c_check_rel(cp_c_load_cal_type igs_ca_inst.cal_type%TYPE,cp_n_load_ci_seq_num igs_ca_inst.sequence_number%TYPE,
102: cp_c_acad_cal_type igs_ca_inst.cal_type%TYPE,cp_n_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE,
103: cp_c_adm_cal_type igs_ca_inst.cal_type%TYPE,cp_n_adm_ci_seq_num igs_ca_inst.sequence_number%TYPE)
104: IS
105: SELECT 'X'
106: FROM igs_ca_inst_rel r1

Line 103: cp_c_adm_cal_type igs_ca_inst.cal_type%TYPE,cp_n_adm_ci_seq_num igs_ca_inst.sequence_number%TYPE)

99:
100:
101: CURSOR c_check_rel(cp_c_load_cal_type igs_ca_inst.cal_type%TYPE,cp_n_load_ci_seq_num igs_ca_inst.sequence_number%TYPE,
102: cp_c_acad_cal_type igs_ca_inst.cal_type%TYPE,cp_n_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE,
103: cp_c_adm_cal_type igs_ca_inst.cal_type%TYPE,cp_n_adm_ci_seq_num igs_ca_inst.sequence_number%TYPE)
104: IS
105: SELECT 'X'
106: FROM igs_ca_inst_rel r1
107: WHERE r1.sub_cal_type = cp_c_load_cal_type AND

Line 106: FROM igs_ca_inst_rel r1

102: cp_c_acad_cal_type igs_ca_inst.cal_type%TYPE,cp_n_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE,
103: cp_c_adm_cal_type igs_ca_inst.cal_type%TYPE,cp_n_adm_ci_seq_num igs_ca_inst.sequence_number%TYPE)
104: IS
105: SELECT 'X'
106: FROM igs_ca_inst_rel r1
107: WHERE r1.sub_cal_type = cp_c_load_cal_type AND
108: r1.sub_ci_sequence_number = cp_n_load_ci_seq_num AND
109: r1.sup_cal_type = cp_c_acad_cal_type AND
110: r1.sup_ci_sequence_number = cp_n_acad_ci_seq_num AND

Line 112: FROM igs_ca_inst_rel r2

108: r1.sub_ci_sequence_number = cp_n_load_ci_seq_num AND
109: r1.sup_cal_type = cp_c_acad_cal_type AND
110: r1.sup_ci_sequence_number = cp_n_acad_ci_seq_num AND
111: EXISTS (SELECT 'X'
112: FROM igs_ca_inst_rel r2
113: WHERE r2.sup_cal_type = r1.sup_cal_type AND
114: r2.sup_ci_sequence_number = r1.sup_ci_sequence_number AND
115: r2.sub_cal_type = cp_c_adm_cal_type AND
116: r2.sub_ci_sequence_number = cp_n_adm_ci_seq_num);

Line 162: cp_c_load_cal_type igs_ca_inst.cal_type%TYPE,

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
166: SELECT spa.course_cd course_cd,

Line 163: cp_n_load_cal_seq_num igs_ca_inst.sequence_number%TYPE,

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
166: SELECT spa.course_cd course_cd,
167: spa.version_number version_number,

Line 577: FUNCTION validate_term_cal_inst(p_c_load_cal_type IN igs_ca_inst.cal_type%TYPE,

573: END IF;
574: RETURN l_b_return_val;
575: END validate_person_grp;
576:
577: FUNCTION validate_term_cal_inst(p_c_load_cal_type IN igs_ca_inst.cal_type%TYPE,
578: p_n_load_seq_number igs_ca_inst.sequence_number%TYPE) RETURN BOOLEAN AS
579: /******************************************************************
580: Created By : Vinay Chappidi
581: Date Created By : 05-DEC-2002

Line 578: p_n_load_seq_number igs_ca_inst.sequence_number%TYPE) RETURN BOOLEAN AS

574: RETURN l_b_return_val;
575: END validate_person_grp;
576:
577: FUNCTION validate_term_cal_inst(p_c_load_cal_type IN igs_ca_inst.cal_type%TYPE,
578: p_n_load_seq_number igs_ca_inst.sequence_number%TYPE) RETURN BOOLEAN AS
579: /******************************************************************
580: Created By : Vinay Chappidi
581: Date Created By : 05-DEC-2002
582: Purpose : validates term calendar

Line 592: CURSOR c_cal_inst (cp_c_cal_type igs_ca_inst.cal_type%TYPE,

588: vchappid 09-Jan-2003 Bug# 2729935, Invalid Value token is removed from all parameters when the
589: input parameter is an invalid value
590: ******************************************************************/
591:
592: CURSOR c_cal_inst (cp_c_cal_type igs_ca_inst.cal_type%TYPE,
593: cp_n_seq_num igs_ca_inst.sequence_number%TYPE)
594: IS
595: SELECT t.cal_type, t.start_dt, t.end_dt
596: FROM igs_ca_inst t, igs_ca_type ty

Line 593: cp_n_seq_num igs_ca_inst.sequence_number%TYPE)

589: input parameter is an invalid value
590: ******************************************************************/
591:
592: CURSOR c_cal_inst (cp_c_cal_type igs_ca_inst.cal_type%TYPE,
593: cp_n_seq_num igs_ca_inst.sequence_number%TYPE)
594: IS
595: SELECT t.cal_type, t.start_dt, t.end_dt
596: FROM igs_ca_inst t, igs_ca_type ty
597: WHERE t.cal_type = ty.cal_type

Line 596: FROM igs_ca_inst t, igs_ca_type ty

592: CURSOR c_cal_inst (cp_c_cal_type igs_ca_inst.cal_type%TYPE,
593: cp_n_seq_num igs_ca_inst.sequence_number%TYPE)
594: IS
595: SELECT t.cal_type, t.start_dt, t.end_dt
596: FROM igs_ca_inst t, igs_ca_type ty
597: WHERE t.cal_type = ty.cal_type
598: AND ty.s_cal_cat='LOAD'
599: AND t.cal_type = cp_c_cal_type
600: AND t.sequence_number = cp_n_seq_num;

Line 935: cp_c_fee_cal_type igs_ca_inst.cal_type%TYPE,

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
938: SELECT crd.*
939: FROM igs_fi_credits_all crd,

Line 936: cp_n_fee_seq_num igs_ca_inst.sequence_number%TYPE)

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
938: SELECT crd.*
939: FROM igs_fi_credits_all crd,
940: igs_fi_cr_types crt

Line 1087: cp_load_cal_type igs_ca_inst.cal_type%TYPE,

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)
1090: IS
1091: SELECT inst.course_cd course_cd,

Line 1088: cp_load_ci_seq_number igs_ca_inst.cal_type%TYPE,

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)
1090: IS
1091: SELECT inst.course_cd course_cd,
1092: inst.crv_version_number version_number,

Line 1480: l_c_load_cal_type igs_ca_inst.cal_type%TYPE;

1476: cp_n_person_grp_id IS NULL;
1477:
1478: l_rec_input_param rec_input_param;
1479:
1480: l_c_load_cal_type igs_ca_inst.cal_type%TYPE;
1481: l_n_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1482: l_c_fee_cal_type igs_ca_inst.cal_type%TYPE;
1483: l_n_fee_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1484:

Line 1481: l_n_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;

1477:
1478: l_rec_input_param rec_input_param;
1479:
1480: l_c_load_cal_type igs_ca_inst.cal_type%TYPE;
1481: l_n_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1482: l_c_fee_cal_type igs_ca_inst.cal_type%TYPE;
1483: l_n_fee_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1484:
1485: l_b_ret_status BOOLEAN;

Line 1482: l_c_fee_cal_type igs_ca_inst.cal_type%TYPE;

1478: l_rec_input_param rec_input_param;
1479:
1480: l_c_load_cal_type igs_ca_inst.cal_type%TYPE;
1481: l_n_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1482: l_c_fee_cal_type igs_ca_inst.cal_type%TYPE;
1483: l_n_fee_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1484:
1485: l_b_ret_status BOOLEAN;
1486:

Line 1483: l_n_fee_ci_seq_num igs_ca_inst.sequence_number%TYPE;

1479:
1480: l_c_load_cal_type igs_ca_inst.cal_type%TYPE;
1481: l_n_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1482: l_c_fee_cal_type igs_ca_inst.cal_type%TYPE;
1483: l_n_fee_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1484:
1485: l_b_ret_status BOOLEAN;
1486:
1487: l_c_message_name fnd_new_messages.message_name%TYPE := NULL;