APPS.IGS_FI_GEN_REFUNDS dependencies on IGS_FI_F_TYP_CA_INST

Line 57: p_fee_cal_type IN OUT NOCOPY igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

53: END check_fund_auth;
54:
55:
56: PROCEDURE get_fee_prd( p_fee_type OUT NOCOPY igs_fi_fee_type.fee_type%TYPE,
57: p_fee_cal_type IN OUT NOCOPY igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
58: p_fee_ci_sequence_number IN OUT NOCOPY igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
59: p_status OUT NOCOPY BOOLEAN) AS
60: /*************************************************************
61: Created By : vchappid

Line 58: p_fee_ci_sequence_number IN OUT NOCOPY igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,

54:
55:
56: PROCEDURE get_fee_prd( p_fee_type OUT NOCOPY igs_fi_fee_type.fee_type%TYPE,
57: p_fee_cal_type IN OUT NOCOPY igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
58: p_fee_ci_sequence_number IN OUT NOCOPY igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
59: p_status OUT NOCOPY BOOLEAN) AS
60: /*************************************************************
61: Created By : vchappid
62: Date Created By : 01-Mar-2002

Line 73: CURSOR cur_fee_type ( cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

69: (reverse chronological order - newest change first)
70: ***************************************************************/
71:
72:
73: CURSOR cur_fee_type ( cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
74: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE)
75: IS
76: SELECT ft.fee_type
77: FROM igs_fi_f_typ_ca_inst ftci,

Line 74: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE)

70: ***************************************************************/
71:
72:
73: CURSOR cur_fee_type ( cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
74: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE)
75: IS
76: SELECT ft.fee_type
77: FROM igs_fi_f_typ_ca_inst ftci,
78: igs_fi_fee_type ft,

Line 77: FROM igs_fi_f_typ_ca_inst ftci,

73: CURSOR cur_fee_type ( cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
74: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE)
75: IS
76: SELECT ft.fee_type
77: FROM igs_fi_f_typ_ca_inst ftci,
78: igs_fi_fee_type ft,
79: igs_fi_fee_str_stat fsst
80: WHERE ft.fee_type = ftci.fee_type
81: AND ftci.fee_cal_type = p_fee_cal_type

Line 96: igs_fi_f_typ_ca_inst ftci,

92: SELECT ftci.fee_type,
93: ci.cal_type,
94: ci.sequence_number
95: FROM igs_fi_fee_type ft,
96: igs_fi_f_typ_ca_inst ftci,
97: igs_ca_inst ci,
98: igs_fi_fee_str_stat fsst
99: WHERE ft.fee_type = ftci.fee_type
100: AND ft.s_fee_type = g_refund

Line 182: FUNCTION val_add_drop (p_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

178: RETURN TRUE;
179: END IF;
180: END get_rfnd_hold;
181:
182: FUNCTION val_add_drop (p_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
183: p_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) RETURN BOOLEAN AS
184: /*************************************************************
185: Created By : vchappid
186: Date Created By : 01-Mar-2002

Line 183: p_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) RETURN BOOLEAN AS

179: END IF;
180: END get_rfnd_hold;
181:
182: FUNCTION val_add_drop (p_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
183: p_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) RETURN BOOLEAN AS
184: /*************************************************************
185: Created By : vchappid
186: Date Created By : 01-Mar-2002
187: Purpose : Function to determine the Refund Date Alias is less than the Sysdate

Line 322: PROCEDURE get_refund_acc ( p_dr_gl_ccid OUT NOCOPY igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE,

318: CLOSE cur_borrower;
319:
320: END get_borw_det;
321:
322: PROCEDURE get_refund_acc ( p_dr_gl_ccid OUT NOCOPY igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE,
323: p_dr_account_cd OUT NOCOPY igs_fi_f_typ_ca_inst.rec_account_cd%TYPE,
324: p_cr_gl_ccid OUT NOCOPY igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE,
325: p_cr_account_cd OUT NOCOPY igs_fi_f_typ_ca_inst.rec_account_cd%TYPE,
326: p_err_message OUT NOCOPY fnd_new_messages.message_name%TYPE,

Line 323: p_dr_account_cd OUT NOCOPY igs_fi_f_typ_ca_inst.rec_account_cd%TYPE,

319:
320: END get_borw_det;
321:
322: PROCEDURE get_refund_acc ( p_dr_gl_ccid OUT NOCOPY igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE,
323: p_dr_account_cd OUT NOCOPY igs_fi_f_typ_ca_inst.rec_account_cd%TYPE,
324: p_cr_gl_ccid OUT NOCOPY igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE,
325: p_cr_account_cd OUT NOCOPY igs_fi_f_typ_ca_inst.rec_account_cd%TYPE,
326: p_err_message OUT NOCOPY fnd_new_messages.message_name%TYPE,
327: p_status OUT NOCOPY BOOLEAN) AS

Line 324: p_cr_gl_ccid OUT NOCOPY igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE,

320: END get_borw_det;
321:
322: PROCEDURE get_refund_acc ( p_dr_gl_ccid OUT NOCOPY igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE,
323: p_dr_account_cd OUT NOCOPY igs_fi_f_typ_ca_inst.rec_account_cd%TYPE,
324: p_cr_gl_ccid OUT NOCOPY igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE,
325: p_cr_account_cd OUT NOCOPY igs_fi_f_typ_ca_inst.rec_account_cd%TYPE,
326: p_err_message OUT NOCOPY fnd_new_messages.message_name%TYPE,
327: p_status OUT NOCOPY BOOLEAN) AS
328: /*************************************************************

Line 325: p_cr_account_cd OUT NOCOPY igs_fi_f_typ_ca_inst.rec_account_cd%TYPE,

321:
322: PROCEDURE get_refund_acc ( p_dr_gl_ccid OUT NOCOPY igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE,
323: p_dr_account_cd OUT NOCOPY igs_fi_f_typ_ca_inst.rec_account_cd%TYPE,
324: p_cr_gl_ccid OUT NOCOPY igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE,
325: p_cr_account_cd OUT NOCOPY igs_fi_f_typ_ca_inst.rec_account_cd%TYPE,
326: p_err_message OUT NOCOPY fnd_new_messages.message_name%TYPE,
327: p_status OUT NOCOPY BOOLEAN) AS
328: /*************************************************************
329: Created By : vchappid