APPS.IGS_FI_GEN_004 dependencies on IGS_PE_STD_TODO

Line 478: FROM IGS_PE_STD_TODO std

474: std.person_id,
475: std.s_student_todo_type,
476: std.sequence_number,
477: std.todo_dt
478: FROM IGS_PE_STD_TODO std
479: WHERE std.s_student_todo_type = cst_fee_recalc AND
480: std.logical_delete_dt IS NULL
481: ORDER BY std.person_id;
482:

Line 484: CURSOR cur_chk_todo_ref(cp_n_person_id igs_pe_std_todo_ref.person_id%TYPE,

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

Line 485: cp_v_todo_type igs_pe_std_todo_ref.s_student_todo_type%TYPE,

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

Line 486: cp_n_seq_num igs_pe_std_todo_ref.sequence_number%TYPE) IS

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

Line 488: FROM igs_pe_std_todo_ref

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;

Line 499: p_sequence_number IN igs_pe_std_todo_ref.sequence_number%TYPE,

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,

Line 500: p_fee_cal_type IN igs_pe_std_todo_ref.cal_type%TYPE,

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,

Line 501: p_fee_ci_sequence_number IN igs_pe_std_todo_ref.ci_sequence_number%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

Line 523: CURSOR c_get_todo_ref_csr(cp_person_id igs_pe_std_todo_ref.person_id%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,

Line 524: cp_sequence_number igs_pe_std_todo_ref.sequence_number%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,
528: person_id,

Line 539: FROM igs_pe_std_todo_ref

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)

Line 621: igs_pe_std_todo_ref_pkg.update_row(

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 ,

Line 801: igs_pe_std_todo_pkg.update_row(

797: FETCH cur_chk_todo_ref INTO l_v_todo_ref_exists;
798: IF cur_chk_todo_ref%NOTFOUND THEN
799: CLOSE cur_chk_todo_ref;
800: BEGIN
801: igs_pe_std_todo_pkg.update_row(
802: x_rowid => v_student_todo_rec.rowid,
803: x_person_id => v_student_todo_rec.person_id ,
804: x_s_student_todo_type => v_student_todo_rec.s_student_todo_type ,
805: x_sequence_number => v_student_todo_rec.sequence_number ,