[Home] [Help]
443: v_dummy VARCHAR2(1);
444: v_record_found BOOLEAN := FALSE;
445: v_creation_dt DATE;
446: v_message_name VARCHAR2(30);
447: l_rpt_person_id hz_parties.party_id%TYPE;
448: l_return_status VARCHAR2(1);
449: l_msg_data fnd_new_messages.message_name%TYPE;
450: l_fee_cal_type igs_ca_inst.cal_type%TYPE;
451: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
494: l_v_todo_ref_exists VARCHAR2(1);
495:
496:
497: PROCEDURE finp_prc_fa_ref_todo(
498: p_person_id IN hz_parties.party_id%TYPE,
499: p_sequence_number IN igs_pe_std_todo_ref.sequence_number%TYPE,
500: p_fee_cal_type IN igs_pe_std_todo_ref.cal_type%TYPE,
501: p_fee_ci_sequence_number IN igs_pe_std_todo_ref.ci_sequence_number%TYPE,
502: x_return_status OUT NOCOPY VARCHAR2,
517: rpt_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
518: l_message fnd_new_messages.message_name%TYPE;
519: l_message_name fnd_new_messages.message_name%TYPE;
520: l_n_waiver_amount NUMBER;
521: l_v_person_number hz_parties.party_number%TYPE;
522:
523: CURSOR c_get_todo_ref_csr(cp_person_id igs_pe_std_todo_ref.person_id%TYPE,
524: cp_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE,
525: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,
891: v_message_name VARCHAR2(30);
892: v_record_found BOOLEAN := FALSE;
893: v_create_dt DATE;
894: l_c_closing_status igs_fi_gl_periods_v.closing_status%TYPE;
895: l_n_person_id hz_parties.party_id%TYPE;
896: l_v_fee_cal_type igs_ca_inst_all.cal_type%TYPE;
897: l_n_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
898: l_n_person_grp_id igs_pe_prsid_grp_mem_v.group_id%TYPE;
899: l_d_gl_date DATE;