APPS.IGS_FI_ACCT_STP_CNV dependencies on IGS_FI_F_TYP_CA_INST

Line 18: gurprsin 18-Jun-2005 Bug# 3392088 , Modified call to igs_fi_f_typ_ca_inst_pkg.update_row method to include

14: sapanigr 05-May-2006 Bug 5178077: Modified procedure updt_ftci_acct_info to disable process in R12.
15: svuppala 14-JUL-2005 Enh 3392095 - impact of Tution Waivers build
16: Modified igs_fi_control_pkg.update_row by adding two new columns
17: post_waiver_gl_flag, waiver_notify_finaid_flag
18: gurprsin 18-Jun-2005 Bug# 3392088 , Modified call to igs_fi_f_typ_ca_inst_pkg.update_row method to include
19: scope_rul_sequence_num and elm_rng_order_name
20: gurprsin 02-Jun-2005 Enh# 3442712 - Fee Based on Unit Level Attributes
21: Added 4 new columns unit_level,unit_type_id,unit_class,unit_mode in insert_ftci_accounts
22: Modifications to reflect the Addition of 4 new parameters to incorporate Unit Level Attributes.

Line 45: igs_fi_f_typ_ca_inst ftci,

41: h.name,
42: ftci.rowid,
43: ftci.*
44: FROM igs_fi_fee_type ft,
45: igs_fi_f_typ_ca_inst ftci,
46: igs_ca_inst ca,
47: igs_fi_hier_accounts h
48: WHERE ft.fee_type = ftci.fee_type
49: AND ftci.fee_cal_type = ca.cal_type

Line 125: p_v_rev_account_cd igs_fi_f_typ_ca_inst.rev_account_cd%TYPE) IS

121: );
122: END insert_ftci_accounts;
123:
124: PROCEDURE update_ftci_rev_acc_cd( l_cur_ftci_details cur_ftci%ROWTYPE,
125: p_v_rev_account_cd igs_fi_f_typ_ca_inst.rev_account_cd%TYPE) IS
126: /*------------------------------------------------------------------
127: Created by : vvutukur, Oracle IDC
128: Date created: 05-Jun-2003
129:

Line 136: gurprsin 18-Jun-2005 Bug# 3392088 , Modified call to igs_fi_f_typ_ca_inst_pkg.update_row method to include

132: Known limitations/enhancements and/or remarks:
133:
134: Change History:
135: Who When What
136: gurprsin 18-Jun-2005 Bug# 3392088 , Modified call to igs_fi_f_typ_ca_inst_pkg.update_row method to include
137: scope_rul_sequence_num and elm_rng_order_name
138: svuppala 13-Apr-2005 Bug 4297359 - ER REGISTRATION FEE ISSUE - ASSESSED TO STUDENTS WITH NO LOAD
139: TBH impact of NONZERO_BILLABLE_CP_FLAG field in Fee Type Calendar Instances Table
140: rmaddipa 17-Sep-2004 Added two parameters retention_level_code,complete_ret_flag.

Line 145: igs_fi_f_typ_ca_inst_pkg.update_row(

141: -------------------------------------------------------------------*/
142:
143: BEGIN
144:
145: igs_fi_f_typ_ca_inst_pkg.update_row(
146: x_rowid => l_cur_ftci_details.rowid,
147: x_fee_type => l_cur_ftci_details.fee_type,
148: x_fee_cal_type => l_cur_ftci_details.fee_cal_type,
149: x_fee_ci_sequence_number => l_cur_ftci_details.fee_ci_sequence_number,

Line 207: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

203:
204: l_cur_ctrl cur_ctrl%ROWTYPE;
205:
206: CURSOR cur_chk_acct_rec_exists(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
207: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
208: cp_n_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE
209: )IS
210: SELECT 'x'
211: FROM igs_fi_ftci_accts

Line 208: cp_n_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE

204: l_cur_ctrl cur_ctrl%ROWTYPE;
205:
206: CURSOR cur_chk_acct_rec_exists(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
207: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
208: cp_n_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE
209: )IS
210: SELECT 'x'
211: FROM igs_fi_ftci_accts
212: WHERE fee_type = cp_v_fee_type

Line 273: l_v_rev_account_cd igs_fi_f_typ_ca_inst.rev_account_cd%TYPE;

269: l_v_fee_period igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD');
270: l_v_acct_hierarchy igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','ACCT_HIERARCHY');
271: l_v_message_text igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','MESSAGE_TEXT');
272:
273: l_v_rev_account_cd igs_fi_f_typ_ca_inst.rev_account_cd%TYPE;
274: l_v_entity_code igs_fi_hier_acct_tbl.entity_type_code%TYPE;
275:
276: --For Program.
277: TYPE prg_rec_type IS RECORD (