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_FI_CR_TYPES

Line 52: g_credit_type_id igs_fi_cr_types_all.credit_type_id%TYPE;

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;
55:
56: -- Pl/SQL table for storing all Student Program Attempts

Line 73: TYPE rec_input_param IS RECORD ( credit_class igs_fi_cr_types.credit_class%TYPE,

69: TYPE stdnt_sca_status_tab IS TABLE OF igs_en_stdnt_ps_att.course_attempt_status%TYPE
70: INDEX BY BINARY_INTEGER;
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,

Line 74: credit_type_id igs_fi_cr_types.credit_type_id%TYPE,

70: INDEX BY BINARY_INTEGER;
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,

Line 325: CURSOR cur_cr_type_names(cp_credit_type_id igs_fi_cr_types_all.credit_type_id%TYPE) 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
327: FROM igs_fi_cr_types_v
328: WHERE credit_type_id = cp_credit_type_id;
329:

Line 327: FROM igs_fi_cr_types_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
327: FROM igs_fi_cr_types_v
328: WHERE credit_type_id = cp_credit_type_id;
329:
330: rec_cur_cr_type_names cur_cr_type_names%ROWTYPE;
331:

Line 393: FUNCTION validate_credit_type(p_c_credit_type_id igs_fi_cr_types.credit_type_id%TYPE,

389: fnd_file.new_line(fnd_file.log);
390:
391: END generate_log;
392:
393: FUNCTION validate_credit_type(p_c_credit_type_id igs_fi_cr_types.credit_type_id%TYPE,
394: p_c_credit_class igs_fi_cr_types.credit_class%TYPE) RETURN BOOLEAN AS
395: /******************************************************************
396: Created By : Vinay Chappidi
397: Date Created By : 05-DEC-2002

Line 394: p_c_credit_class igs_fi_cr_types.credit_class%TYPE) RETURN BOOLEAN AS

390:
391: END generate_log;
392:
393: FUNCTION validate_credit_type(p_c_credit_type_id igs_fi_cr_types.credit_type_id%TYPE,
394: p_c_credit_class igs_fi_cr_types.credit_class%TYPE) RETURN BOOLEAN AS
395: /******************************************************************
396: Created By : Vinay Chappidi
397: Date Created By : 05-DEC-2002
398: Purpose : Validates Credit Type

Line 407: CURSOR c_credit_type(cp_credit_type_id IN igs_fi_cr_types.credit_type_id%TYPE)

403: Who When What
404: vchappid 09-Jan-2003 Bug# 2729935, Invalid Value token is removed from all parameters when the
405: input parameter is an invalid value
406: ******************************************************************/
407: CURSOR c_credit_type(cp_credit_type_id IN igs_fi_cr_types.credit_type_id%TYPE)
408: IS
409: SELECT credit_type_name
410: FROM igs_fi_cr_types
411: WHERE credit_type_id = cp_credit_type_id AND

Line 410: FROM igs_fi_cr_types

406: ******************************************************************/
407: CURSOR c_credit_type(cp_credit_type_id IN igs_fi_cr_types.credit_type_id%TYPE)
408: IS
409: SELECT credit_type_name
410: FROM igs_fi_cr_types
411: WHERE credit_type_id = cp_credit_type_id AND
412: credit_class = p_c_credit_class;
413:
414: l_b_return_val BOOLEAN := FALSE;

Line 934: cp_c_cr_type_id igs_fi_cr_types.credit_type_id%TYPE,

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
938: SELECT crd.*

Line 940: igs_fi_cr_types crt

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
941: WHERE crd.party_id = cp_n_person_id AND
942: crd.credit_type_id = crt.credit_type_id AND
943: crt.credit_class = g_c_othdeposit AND
944: (

Line 1037: cp_n_cr_type_id igs_fi_cr_types.credit_type_id%TYPE)

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,
1041: crd.credit_number,

Line 1044: igs_fi_cr_types crt

1040: TO_NUMBER(crd.source_transaction_ref) source_transaction_ref,
1041: crd.credit_number,
1042: crd.amount
1043: FROM igs_fi_credits crd,
1044: igs_fi_cr_types crt
1045: WHERE crd.party_id = cp_n_person_id AND
1046: crd.credit_type_id = crt.credit_type_id AND
1047: (
1048: (crt.credit_type_id = cp_n_cr_type_id AND cp_n_cr_type_id IS NOT NULL)