APPS.IGS_FI_UPG_RETENTION dependencies on IGS_FI_INV_INT_ALL

Line 18: TYPE ret_invoice_rec IS RECORD( invoice_id igs_fi_inv_int_all.invoice_id%TYPE,

14: new columns Unit_Type_Id, Unit_Level in igs_fi_invln_int_all
15: shtatiko 11-DEC-2003 Bug# 3288973, Created this process
16: ***************************************************************** */
17:
18: TYPE ret_invoice_rec IS RECORD( invoice_id igs_fi_inv_int_all.invoice_id%TYPE,
19: ftci_rec_account_cd igs_fi_f_typ_ca_inst.rec_account_cd%TYPE,
20: ftci_rec_gl_ccid igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE,
21: ftci_ret_account_cd igs_fi_f_typ_ca_inst.ret_account_cd%TYPE,
22: ftci_ret_gl_ccid igs_fi_f_typ_ca_inst.ret_gl_ccid%TYPE );

Line 26: FUNCTION find_invoice ( p_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE,

22: ftci_ret_gl_ccid igs_fi_f_typ_ca_inst.ret_gl_ccid%TYPE );
23: TYPE ret_invoice_tab_type IS TABLE OF ret_invoice_rec
24: INDEX BY BINARY_INTEGER;
25:
26: FUNCTION find_invoice ( p_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE,
27: p_invoice_tab ret_invoice_tab_type) RETURN BOOLEAN IS
28:
29: BEGIN
30:

Line 123: FROM igs_fi_inv_int_all a,

119: c.rec_gl_ccid ftci_rec_gl_ccid,
120: c.rec_account_cd ftci_rec_account_cd,
121: c.ret_gl_ccid ftci_ret_gl_ccid,
122: c.ret_account_cd ftci_ret_account_cd
123: FROM igs_fi_inv_int_all a,
124: igs_fi_invln_int_all b,
125: igs_fi_f_typ_ca_inst c,
126: igs_ca_inst ci
127: WHERE a.invoice_id = b.invoice_id

Line 155: igs_fi_inv_int_all inv,

151: ftci.ret_account_cd ftci_ret_account_cd,
152: ci.start_dt,
153: ci.end_dt
154: FROM igs_fi_applications app,
155: igs_fi_inv_int_all inv,
156: igs_fi_f_typ_ca_inst ftci,
157: igs_ca_inst ci
158: WHERE app.invoice_id = inv.invoice_id
159: AND inv.transaction_type = 'RETENTION'

Line 171: CURSOR c_invoice_details ( cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE ) IS

167: And ci.sequence_number = ftci.fee_ci_sequence_number
168: ORDER BY inv.fee_type, inv.fee_cal_type, inv.fee_ci_sequence_number;
169:
170:
171: CURSOR c_invoice_details ( cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE ) IS
172: SELECT ROWID, inv.*
173: FROM igs_fi_invln_int_all inv
174: WHERE invoice_id = cp_n_invoice_id;
175: rec_invoice_details c_invoice_details%ROWTYPE;

Line 177: CURSOR c_application_details ( cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE ) IS

173: FROM igs_fi_invln_int_all inv
174: WHERE invoice_id = cp_n_invoice_id;
175: rec_invoice_details c_invoice_details%ROWTYPE;
176:
177: CURSOR c_application_details ( cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE ) IS
178: SELECT ROWID, app.*
179: FROM igs_fi_applications app
180: WHERE invoice_id = cp_n_invoice_id;
181:

Line 203: l_v_fee_type igs_fi_inv_int_all.fee_type%TYPE;

199:
200: l_v_rec_installed igs_fi_control_all.rec_installed%TYPE;
201: l_v_accounting_method igs_fi_control_all.accounting_method%TYPE;
202:
203: l_v_fee_type igs_fi_inv_int_all.fee_type%TYPE;
204: l_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE;
205: l_n_fee_ci_sequence_number igs_fi_inv_int_all.fee_ci_sequence_number%TYPE;
206:
207: l_n_rec_gl_ccid_sys igs_fi_control_all.rec_gl_ccid%TYPE;

Line 204: l_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE;

200: l_v_rec_installed igs_fi_control_all.rec_installed%TYPE;
201: l_v_accounting_method igs_fi_control_all.accounting_method%TYPE;
202:
203: l_v_fee_type igs_fi_inv_int_all.fee_type%TYPE;
204: l_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE;
205: l_n_fee_ci_sequence_number igs_fi_inv_int_all.fee_ci_sequence_number%TYPE;
206:
207: l_n_rec_gl_ccid_sys igs_fi_control_all.rec_gl_ccid%TYPE;
208: l_n_upd_rec_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;

Line 205: l_n_fee_ci_sequence_number igs_fi_inv_int_all.fee_ci_sequence_number%TYPE;

201: l_v_accounting_method igs_fi_control_all.accounting_method%TYPE;
202:
203: l_v_fee_type igs_fi_inv_int_all.fee_type%TYPE;
204: l_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE;
205: l_n_fee_ci_sequence_number igs_fi_inv_int_all.fee_ci_sequence_number%TYPE;
206:
207: l_n_rec_gl_ccid_sys igs_fi_control_all.rec_gl_ccid%TYPE;
208: l_n_upd_rec_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;
209: l_n_upd_rev_gl_ccid igs_fi_control_all.rec_gl_ccid%TYPE;