[Home] [Help]
17: Change History
18: Who When What
19: akandreg 16-May-2006 Bug 5105131, modified cursor c_f_cal_typ. In function igs_fi_ext_val, the system defined
20: status (igs_ca_stat.S_CAL_STATUS) displayed on the Calendar Statuses form would be used in
21: the validation test instead of IGS_CA_INST.CAL_TYPE, which is user defined status.
22: sapanigr 24-Feb-2006 Bug#5018036 - Replaced cursor cur_person in igs_fi_extto_imp procedure by function call.
23: sapanigr 12-Feb-2006 Bug#5018036 - Modified cursor cur_person in igs_fi_extto_imp procedure. (R12 SQL Repository tuning)
24: svuppala 09-AUG-2005 Enh 3392095 - Tution Waivers build
25: Impact of Charges API version Number change
93: RETURN BOOLEAN AS
94: /***
95: akandreg 16-May-2006 Bug 5105131, modified cursor c_f_cal_typ. In function igs_fi_ext_val, the system defined
96: status (igs_ca_stat.S_CAL_STATUS) displayed on the Calendar Statuses form would be used in
97: the validation test instead of IGS_CA_INST.CAL_TYPE, which is user defined status.
98: pmarada 29-Mar-2005 Bug 4270442, removed the cursor c_person instead of that calling
99: get_std_formerstd_ind function.
100: vvutukur 20-Jun-2003 Bug#2777502.Modified cursor c_fee_typ to exclude closed fee types.
101: pathipat 16-Nov-2002 Enh Bug: 2584986 - Added parameter p_d_gl_Date and its validations
106: SYKRISHN 03-JUL-2002 Bug 2442163
107: Definition of p_transaction_dt changed to Effective_dt%type - since transaction_dt is being made obsolete.
108:
109: ***/
110: l_start_dt igs_ca_inst.start_dt%TYPE;
111: l_end_dt igs_ca_inst.end_dt%TYPE;
112: l_dummy VARCHAR2(1);
113: l_v_status gl_period_statuses.closing_status%TYPE := NULL;
114: l_message_name fnd_new_messages.message_name%TYPE;
107: Definition of p_transaction_dt changed to Effective_dt%type - since transaction_dt is being made obsolete.
108:
109: ***/
110: l_start_dt igs_ca_inst.start_dt%TYPE;
111: l_end_dt igs_ca_inst.end_dt%TYPE;
112: l_dummy VARCHAR2(1);
113: l_v_status gl_period_statuses.closing_status%TYPE := NULL;
114: l_message_name fnd_new_messages.message_name%TYPE;
115:
124: CURSOR c_f_cal_typ
125: IS
126: SELECT ci.start_dt,
127: ci.end_dt
128: FROM igs_ca_inst ci,
129: igs_ca_type ct,
130: igs_ca_stat st
131: WHERE ci.cal_type = ct.cal_type
132: AND ct.s_cal_cat = 'FEE'
429: l_b_flag BOOLEAN := TRUE;
430:
431: l_person_number hz_parties.party_number%TYPE;
432:
433: CURSOR cur_fee_period(cp_cal_type igs_ca_inst.cal_type%TYPE,cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS
434: SELECT igs_ge_date.igschar(start_dt) ||' '|| igs_ge_date.igschar(end_dt) string
435: FROM igs_ca_inst
436: WHERE cal_type=cp_cal_type
437: AND sequence_number=cp_sequence_number;
431: l_person_number hz_parties.party_number%TYPE;
432:
433: CURSOR cur_fee_period(cp_cal_type igs_ca_inst.cal_type%TYPE,cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS
434: SELECT igs_ge_date.igschar(start_dt) ||' '|| igs_ge_date.igschar(end_dt) string
435: FROM igs_ca_inst
436: WHERE cal_type=cp_cal_type
437: AND sequence_number=cp_sequence_number;
438:
439: l_cur_fee_period cur_fee_period%ROWTYPE;