[Home] [Help]
201: l_expiration_date c_expiration_date%ROWTYPE;
202:
203: l_v_currency igs_fi_control_all.currency_cd%TYPE;
204: l_v_curr_desc fnd_currencies_tl.name%TYPE;
205: l_v_message_name fnd_new_messages.message_name%TYPE;
206:
207: l_b_return_status BOOLEAN;
208: l_credit_rec igs_fi_credit_pvt.credit_rec_type;
209: l_exception EXCEPTION;
879: l_c_rpt_ld_cal_type igs_pe_std_todo_ref.cal_type%TYPE;
880: l_n_rpt_ld_ci_sequence_number igs_pe_std_todo_ref.ci_sequence_number%TYPE;
881: l_c_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE;
882: l_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE;
883: l_c_message_name fnd_new_messages.message_name%TYPE DEFAULT NULL;
884: l_c_message VARCHAR2(32767) DEFAULT NULL;
885: l_d_creation_dt DATE;
886: cst_fee_recalc CONSTANT VARCHAR2(10) := 'FEE_RECALC';
887:
1112:
1113: END finp_calc_fees_todo;
1114:
1115: FUNCTION get_msg_text(
1116: p_v_message_name IN fnd_new_messages.message_name%TYPE
1117: ) RETURN VARCHAR2 AS
1118: ------------------------------------------------------------------
1119: --Created by : Sanil Madathil, Oracle IDC
1120: --Date created: 30 May 2003
1131: --Who When What
1132: --gurprsin 13-Sep-2005 Bug 3765876, Modified the Cursor c_get_msg_text select statement to add userenv. language condition with application id
1133: ------------------------------------------------------------------
1134:
1135: CURSOR c_get_msg_text(cp_v_message_name fnd_new_messages.message_name%TYPE) IS
1136: SELECT message_text
1137: FROM fnd_new_messages
1138: WHERE message_name = cp_v_message_name
1139: AND application_id = 8405
1133: ------------------------------------------------------------------
1134:
1135: CURSOR c_get_msg_text(cp_v_message_name fnd_new_messages.message_name%TYPE) IS
1136: SELECT message_text
1137: FROM fnd_new_messages
1138: WHERE message_name = cp_v_message_name
1139: AND application_id = 8405
1140: AND language_code = USERENV('LANG');
1141: