480: std.logical_delete_dt IS NULL
481: ORDER BY std.person_id;
482:
483: -- Cursor to check if all REF records have been processed
484: CURSOR cur_chk_todo_ref(cp_n_person_id igs_pe_std_todo_ref.person_id%TYPE,
485: cp_v_todo_type igs_pe_std_todo_ref.s_student_todo_type%TYPE,
486: cp_n_seq_num igs_pe_std_todo_ref.sequence_number%TYPE) IS
487: SELECT 'x'
488: FROM igs_pe_std_todo_ref
481: ORDER BY std.person_id;
482:
483: -- Cursor to check if all REF records have been processed
484: CURSOR cur_chk_todo_ref(cp_n_person_id igs_pe_std_todo_ref.person_id%TYPE,
485: cp_v_todo_type igs_pe_std_todo_ref.s_student_todo_type%TYPE,
486: cp_n_seq_num igs_pe_std_todo_ref.sequence_number%TYPE) IS
487: SELECT 'x'
488: FROM igs_pe_std_todo_ref
489: WHERE person_id = cp_n_person_id
482:
483: -- Cursor to check if all REF records have been processed
484: CURSOR cur_chk_todo_ref(cp_n_person_id igs_pe_std_todo_ref.person_id%TYPE,
485: cp_v_todo_type igs_pe_std_todo_ref.s_student_todo_type%TYPE,
486: cp_n_seq_num igs_pe_std_todo_ref.sequence_number%TYPE) IS
487: SELECT 'x'
488: FROM igs_pe_std_todo_ref
489: WHERE person_id = cp_n_person_id
490: AND s_student_todo_type = cp_v_todo_type
484: CURSOR cur_chk_todo_ref(cp_n_person_id igs_pe_std_todo_ref.person_id%TYPE,
485: cp_v_todo_type igs_pe_std_todo_ref.s_student_todo_type%TYPE,
486: cp_n_seq_num igs_pe_std_todo_ref.sequence_number%TYPE) IS
487: SELECT 'x'
488: FROM igs_pe_std_todo_ref
489: WHERE person_id = cp_n_person_id
490: AND s_student_todo_type = cp_v_todo_type
491: AND sequence_number = cp_n_seq_num
492: AND logical_delete_dt IS NULL;
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,
503: x_msg_data OUT NOCOPY VARCHAR2,
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,
503: x_msg_data OUT NOCOPY VARCHAR2,
504: p_v_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,
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,
503: x_msg_data OUT NOCOPY VARCHAR2,
504: p_v_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,
505: p_n_load_ci_seq_num IN igs_ca_inst_all.sequence_number%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,
526: cp_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
527: SELECT rowid,
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,
526: cp_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
527: SELECT rowid,
528: person_id,
535: unit_cd,
536: other_reference,
537: logical_delete_dt,
538: uoo_id
539: FROM igs_pe_std_todo_ref
540: WHERE person_id = cp_person_id
541: AND sequence_number = cp_sequence_number
542: AND s_student_todo_type = cst_fee_recalc
543: AND (cal_type = cp_v_load_cal_type OR cp_v_load_cal_type IS NULL)
617: x_msg_data := l_message_name;
618: RAISE FND_API.G_EXC_ERROR;
619: ELSE
620: -- If call is success, action off child record
621: igs_pe_std_todo_ref_pkg.update_row(
622: x_rowid => lp_todo_ref_rec.rowid,
623: x_person_id => lp_todo_ref_rec.person_id ,
624: x_s_student_todo_type => lp_todo_ref_rec.s_student_todo_type ,
625: x_sequence_number => lp_todo_ref_rec.sequence_number ,