DBA Data[Home] [Help]

APPS.IGS_FI_PRC_APPL dependencies on IGS_CA_INST

Line 284: PROCEDURE get_cal_details(p_fee_cal_type igs_ca_inst.cal_type%TYPE,

280: fnd_file.put_line(fnd_file.log, fnd_message.Get);
281: RETURN;
282: END apply_and_log_messages;
283:
284: PROCEDURE get_cal_details(p_fee_cal_type igs_ca_inst.cal_type%TYPE,
285: p_fee_seq igs_ca_inst.sequence_number%TYPE,
286: p_end_dt OUT NOCOPY igs_ca_inst.end_dt%TYPE,
287: p_message OUT NOCOPY fnd_new_messages.message_name%TYPE,
288: p_status OUT NOCOPY BOOLEAN) AS

Line 285: p_fee_seq igs_ca_inst.sequence_number%TYPE,

281: RETURN;
282: END apply_and_log_messages;
283:
284: PROCEDURE get_cal_details(p_fee_cal_type igs_ca_inst.cal_type%TYPE,
285: p_fee_seq igs_ca_inst.sequence_number%TYPE,
286: p_end_dt OUT NOCOPY igs_ca_inst.end_dt%TYPE,
287: p_message OUT NOCOPY fnd_new_messages.message_name%TYPE,
288: p_status OUT NOCOPY BOOLEAN) AS
289: /******************************************************************

Line 286: p_end_dt OUT NOCOPY igs_ca_inst.end_dt%TYPE,

282: END apply_and_log_messages;
283:
284: PROCEDURE get_cal_details(p_fee_cal_type igs_ca_inst.cal_type%TYPE,
285: p_fee_seq igs_ca_inst.sequence_number%TYPE,
286: p_end_dt OUT NOCOPY igs_ca_inst.end_dt%TYPE,
287: p_message OUT NOCOPY fnd_new_messages.message_name%TYPE,
288: p_status OUT NOCOPY BOOLEAN) AS
289: /******************************************************************
290: Created By : agairola

Line 302: CURSOR cur_cal(cp_cal_type igs_ca_inst.cal_type%TYPE,

298: Who When What
299:
300: ****************************************************************/
301:
302: CURSOR cur_cal(cp_cal_type igs_ca_inst.cal_type%TYPE,
303: cp_seq_num igs_ca_inst.sequence_number%TYPE) IS
304: SELECT end_dt
305: FROM igs_ca_inst
306: WHERE cal_type = cp_cal_type

Line 303: cp_seq_num igs_ca_inst.sequence_number%TYPE) IS

299:
300: ****************************************************************/
301:
302: CURSOR cur_cal(cp_cal_type igs_ca_inst.cal_type%TYPE,
303: cp_seq_num igs_ca_inst.sequence_number%TYPE) IS
304: SELECT end_dt
305: FROM igs_ca_inst
306: WHERE cal_type = cp_cal_type
307: AND sequence_number = cp_seq_num;

Line 305: FROM igs_ca_inst

301:
302: CURSOR cur_cal(cp_cal_type igs_ca_inst.cal_type%TYPE,
303: cp_seq_num igs_ca_inst.sequence_number%TYPE) IS
304: SELECT end_dt
305: FROM igs_ca_inst
306: WHERE cal_type = cp_cal_type
307: AND sequence_number = cp_seq_num;
308:
309: l_load_cal_type igs_ca_inst.cal_type%TYPE;

Line 309: l_load_cal_type igs_ca_inst.cal_type%TYPE;

305: FROM igs_ca_inst
306: WHERE cal_type = cp_cal_type
307: AND sequence_number = cp_seq_num;
308:
309: l_load_cal_type igs_ca_inst.cal_type%TYPE;
310: l_load_seq igs_ca_inst.sequence_number%TYPE;
311: l_message_name fnd_new_messages.message_name%TYPE;
312: l_end_dt igs_ca_inst.end_dt%TYPE;
313: BEGIN

Line 310: l_load_seq igs_ca_inst.sequence_number%TYPE;

306: WHERE cal_type = cp_cal_type
307: AND sequence_number = cp_seq_num;
308:
309: l_load_cal_type igs_ca_inst.cal_type%TYPE;
310: l_load_seq igs_ca_inst.sequence_number%TYPE;
311: l_message_name fnd_new_messages.message_name%TYPE;
312: l_end_dt igs_ca_inst.end_dt%TYPE;
313: BEGIN
314: p_status := TRUE;

Line 312: l_end_dt igs_ca_inst.end_dt%TYPE;

308:
309: l_load_cal_type igs_ca_inst.cal_type%TYPE;
310: l_load_seq igs_ca_inst.sequence_number%TYPE;
311: l_message_name fnd_new_messages.message_name%TYPE;
312: l_end_dt igs_ca_inst.end_dt%TYPE;
313: BEGIN
314: p_status := TRUE;
315:
316: -- Call the API for getting the Load Calendar from the Fee Calendar

Line 700: l_cur_cal_end_dt igs_ca_inst.end_dt%TYPE;

696: l_v_fund_auth_profile VARCHAR2(1) := NVL(FND_PROFILE.VALUE('IGS_FI_FUND_AUTH'),'N');
697: /** Profile value taken as N if not Set - hence used NVL */
698:
699: l_process_credit BOOLEAN;
700: l_cur_cal_end_dt igs_ca_inst.end_dt%TYPE;
701: l_fee_cal_end_dt igs_ca_inst.end_dt%TYPE;
702: l_status BOOLEAN;
703: l_message_name fnd_new_messages.message_name%TYPE;
704: l_c_closing_status gl_period_statuses.closing_status%TYPE;

Line 701: l_fee_cal_end_dt igs_ca_inst.end_dt%TYPE;

697: /** Profile value taken as N if not Set - hence used NVL */
698:
699: l_process_credit BOOLEAN;
700: l_cur_cal_end_dt igs_ca_inst.end_dt%TYPE;
701: l_fee_cal_end_dt igs_ca_inst.end_dt%TYPE;
702: l_status BOOLEAN;
703: l_message_name fnd_new_messages.message_name%TYPE;
704: l_c_closing_status gl_period_statuses.closing_status%TYPE;
705: