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_LOOKUP_VALUES

Line 41: g_c_transfer CONSTANT igs_lookup_values.lookup_code%TYPE := 'TRANSFER';

37:
38: g_c_yes CONSTANT VARCHAR2(1) := 'Y';
39: g_c_no CONSTANT VARCHAR2(1) := 'N';
40: g_c_hold CONSTANT VARCHAR2(4) := 'HOLD';
41: g_c_transfer CONSTANT igs_lookup_values.lookup_code%TYPE := 'TRANSFER';
42: g_c_forfeit CONSTANT igs_lookup_values.lookup_code%TYPE := 'FORFEIT';
43: g_c_enrdeposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'ENRDEPOSIT';
44: g_c_othdeposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'OTHDEPOSIT';
45: g_c_sca_enrolled CONSTANT igs_en_stdnt_ps_att.course_attempt_status%TYPE := 'ENROLLED';

Line 42: g_c_forfeit CONSTANT igs_lookup_values.lookup_code%TYPE := 'FORFEIT';

38: g_c_yes CONSTANT VARCHAR2(1) := 'Y';
39: g_c_no CONSTANT VARCHAR2(1) := 'N';
40: g_c_hold CONSTANT VARCHAR2(4) := 'HOLD';
41: g_c_transfer CONSTANT igs_lookup_values.lookup_code%TYPE := 'TRANSFER';
42: g_c_forfeit CONSTANT igs_lookup_values.lookup_code%TYPE := 'FORFEIT';
43: g_c_enrdeposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'ENRDEPOSIT';
44: g_c_othdeposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'OTHDEPOSIT';
45: g_c_sca_enrolled CONSTANT igs_en_stdnt_ps_att.course_attempt_status%TYPE := 'ENROLLED';
46: g_c_sca_other CONSTANT igs_en_stdnt_ps_att.course_attempt_status%TYPE := 'OTHER';

Line 43: g_c_enrdeposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'ENRDEPOSIT';

39: g_c_no CONSTANT VARCHAR2(1) := 'N';
40: g_c_hold CONSTANT VARCHAR2(4) := 'HOLD';
41: g_c_transfer CONSTANT igs_lookup_values.lookup_code%TYPE := 'TRANSFER';
42: g_c_forfeit CONSTANT igs_lookup_values.lookup_code%TYPE := 'FORFEIT';
43: g_c_enrdeposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'ENRDEPOSIT';
44: g_c_othdeposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'OTHDEPOSIT';
45: g_c_sca_enrolled CONSTANT igs_en_stdnt_ps_att.course_attempt_status%TYPE := 'ENROLLED';
46: g_c_sca_other CONSTANT igs_en_stdnt_ps_att.course_attempt_status%TYPE := 'OTHER';
47: g_c_appl_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'APPL';

Line 44: g_c_othdeposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'OTHDEPOSIT';

40: g_c_hold CONSTANT VARCHAR2(4) := 'HOLD';
41: g_c_transfer CONSTANT igs_lookup_values.lookup_code%TYPE := 'TRANSFER';
42: g_c_forfeit CONSTANT igs_lookup_values.lookup_code%TYPE := 'FORFEIT';
43: g_c_enrdeposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'ENRDEPOSIT';
44: g_c_othdeposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'OTHDEPOSIT';
45: g_c_sca_enrolled CONSTANT igs_en_stdnt_ps_att.course_attempt_status%TYPE := 'ENROLLED';
46: g_c_sca_other CONSTANT igs_en_stdnt_ps_att.course_attempt_status%TYPE := 'OTHER';
47: g_c_appl_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'APPL';
48: g_c_all_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'ALL';

Line 47: g_c_appl_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'APPL';

43: g_c_enrdeposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'ENRDEPOSIT';
44: g_c_othdeposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'OTHDEPOSIT';
45: g_c_sca_enrolled CONSTANT igs_en_stdnt_ps_att.course_attempt_status%TYPE := 'ENROLLED';
46: g_c_sca_other CONSTANT igs_en_stdnt_ps_att.course_attempt_status%TYPE := 'OTHER';
47: g_c_appl_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'APPL';
48: g_c_all_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'ALL';
49: g_c_prg_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'PROGRAM';
50: g_c_prgty_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'PROGRAM_TYPE';
51: g_null CONSTANT VARCHAR2(1):= NULL;

Line 48: g_c_all_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'ALL';

44: g_c_othdeposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'OTHDEPOSIT';
45: g_c_sca_enrolled CONSTANT igs_en_stdnt_ps_att.course_attempt_status%TYPE := 'ENROLLED';
46: g_c_sca_other CONSTANT igs_en_stdnt_ps_att.course_attempt_status%TYPE := 'OTHER';
47: g_c_appl_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'APPL';
48: g_c_all_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'ALL';
49: g_c_prg_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'PROGRAM';
50: g_c_prgty_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'PROGRAM_TYPE';
51: g_null CONSTANT VARCHAR2(1):= NULL;
52: g_credit_type_id igs_fi_cr_types_all.credit_type_id%TYPE;

Line 49: g_c_prg_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'PROGRAM';

45: g_c_sca_enrolled CONSTANT igs_en_stdnt_ps_att.course_attempt_status%TYPE := 'ENROLLED';
46: g_c_sca_other CONSTANT igs_en_stdnt_ps_att.course_attempt_status%TYPE := 'OTHER';
47: g_c_appl_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'APPL';
48: g_c_all_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'ALL';
49: g_c_prg_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'PROGRAM';
50: g_c_prgty_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'PROGRAM_TYPE';
51: g_null CONSTANT VARCHAR2(1):= NULL;
52: g_credit_type_id igs_fi_cr_types_all.credit_type_id%TYPE;
53:

Line 50: g_c_prgty_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'PROGRAM_TYPE';

46: g_c_sca_other CONSTANT igs_en_stdnt_ps_att.course_attempt_status%TYPE := 'OTHER';
47: g_c_appl_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'APPL';
48: g_c_all_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'ALL';
49: g_c_prg_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'PROGRAM';
50: g_c_prgty_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'PROGRAM_TYPE';
51: g_null CONSTANT VARCHAR2(1):= NULL;
52: g_credit_type_id igs_fi_cr_types_all.credit_type_id%TYPE;
53:
54: do_nothing EXCEPTION;

Line 146: p_c_action OUT NOCOPY igs_lookup_values.lookup_code%TYPE,

142: p_tab_sca_typ stdnt_sca_typ_tab,
143: p_rec_input_param rec_input_param,
144: p_c_sca_status igs_en_stdnt_ps_att.course_attempt_status%TYPE,
145: p_c_dep_lvl VARCHAR2,
146: p_c_action OUT NOCOPY igs_lookup_values.lookup_code%TYPE,
147: p_c_sca_att_status OUT NOCOPY igs_lookup_values.lookup_code%TYPE)
148: AS
149: /******************************************************************
150: Created By : Vinay Chappidi

Line 147: p_c_sca_att_status OUT NOCOPY igs_lookup_values.lookup_code%TYPE)

143: p_rec_input_param rec_input_param,
144: p_c_sca_status igs_en_stdnt_ps_att.course_attempt_status%TYPE,
145: p_c_dep_lvl VARCHAR2,
146: p_c_action OUT NOCOPY igs_lookup_values.lookup_code%TYPE,
147: p_c_sca_att_status OUT NOCOPY igs_lookup_values.lookup_code%TYPE)
148: AS
149: /******************************************************************
150: Created By : Vinay Chappidi
151: Date Created By : 05-DEC-2002

Line 227: l_c_course_attempt_status igs_lookup_values.lookup_code%TYPE;

223: l_tab_std_sca_stat_typ stdnt_sca_status_tab;
224:
225: -- this flag is used if the program attempt match with the one that is found from the above cursor
226: l_b_found BOOLEAN := FALSE;
227: l_c_course_attempt_status igs_lookup_values.lookup_code%TYPE;
228:
229: BEGIN
230: -- For the person incontext and for the load calendar instance as selected by the user
231: -- select all program attempts the student has attempted and with the course attempt status decided

Line 302: p_c_sca_att_status igs_lookup_values.lookup_code%TYPE) AS

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,
301: p_c_message_name fnd_new_messages.message_name%TYPE,
302: p_c_sca_att_status igs_lookup_values.lookup_code%TYPE) AS
303: /******************************************************************
304: Created By : Vinay Chappidi
305: Date Created By : 05-DEC-2002
306: Purpose : Log Messages

Line 857: p_c_action igs_lookup_values.lookup_code%TYPE,

853: END validate_log_parameters;
854:
855: PROCEDURE take_action(p_n_credit_id igs_fi_credits_all.credit_id%TYPE,
856: p_d_gl_date DATE,
857: p_c_action igs_lookup_values.lookup_code%TYPE,
858: p_c_credit_number OUT NOCOPY igs_fi_credits.credit_number%TYPE,
859: p_c_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE)
860: AS
861: /******************************************************************

Line 1089: cp_c_criteria igs_lookup_values.lookup_code%TYPE)

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,
1093: ps.course_type course_type

Line 1167: l_c_action igs_lookup_values.lookup_code%TYPE;

1163:
1164: -- local boolean variable
1165: l_b_status BOOLEAN;
1166:
1167: l_c_action igs_lookup_values.lookup_code%TYPE;
1168: l_c_outcome igs_lookup_values.lookup_code%TYPE := g_c_forfeit;
1169: l_c_criteria igs_lookup_values.lookup_code%TYPE;
1170: l_c_sca_att_status igs_lookup_values.lookup_code%TYPE;
1171:

Line 1168: l_c_outcome igs_lookup_values.lookup_code%TYPE := g_c_forfeit;

1164: -- local boolean variable
1165: l_b_status BOOLEAN;
1166:
1167: l_c_action igs_lookup_values.lookup_code%TYPE;
1168: l_c_outcome igs_lookup_values.lookup_code%TYPE := g_c_forfeit;
1169: l_c_criteria igs_lookup_values.lookup_code%TYPE;
1170: l_c_sca_att_status igs_lookup_values.lookup_code%TYPE;
1171:
1172: l_c_message_name fnd_new_messages.message_name%TYPE;

Line 1169: l_c_criteria igs_lookup_values.lookup_code%TYPE;

1165: l_b_status BOOLEAN;
1166:
1167: l_c_action igs_lookup_values.lookup_code%TYPE;
1168: l_c_outcome igs_lookup_values.lookup_code%TYPE := g_c_forfeit;
1169: l_c_criteria igs_lookup_values.lookup_code%TYPE;
1170: l_c_sca_att_status igs_lookup_values.lookup_code%TYPE;
1171:
1172: l_c_message_name fnd_new_messages.message_name%TYPE;
1173: l_c_credit_number igs_fi_credits.credit_number%TYPE;

Line 1170: l_c_sca_att_status igs_lookup_values.lookup_code%TYPE;

1166:
1167: l_c_action igs_lookup_values.lookup_code%TYPE;
1168: l_c_outcome igs_lookup_values.lookup_code%TYPE := g_c_forfeit;
1169: l_c_criteria igs_lookup_values.lookup_code%TYPE;
1170: l_c_sca_att_status igs_lookup_values.lookup_code%TYPE;
1171:
1172: l_c_message_name fnd_new_messages.message_name%TYPE;
1173: l_c_credit_number igs_fi_credits.credit_number%TYPE;
1174: