APPS.IGS_FI_PRC_SP_FEES dependencies on HZ_PARTIES

Line 49: PROCEDURE log_details(p_v_person_number IN hz_parties.party_number%TYPE,

45: p_v_course_cd IN igs_fi_spa_fee_prds.course_cd%TYPE,
46: p_v_fee_cal_type IN igs_fi_spa_fee_prds.fee_cal_type%TYPE,
47: p_n_fee_ci_sequence_number IN igs_fi_spa_fee_prds.fee_ci_sequence_number%TYPE) RETURN BOOLEAN;
48:
49: PROCEDURE log_details(p_v_person_number IN hz_parties.party_number%TYPE,
50: p_v_fee_period IN VARCHAR2,
51: p_v_unit_section_desc IN VARCHAR2,
52: p_v_fee_type IN igs_fi_fee_type.fee_type%TYPE)AS
53: /******************************************************************

Line 94: PROCEDURE call_charges_api(p_n_person_id IN hz_parties.party_id%TYPE,

90: END IF;
91: END log_details;
92:
93:
94: PROCEDURE call_charges_api(p_n_person_id IN hz_parties.party_id%TYPE,
95: p_v_fee_type IN igs_fi_f_typ_ca_inst.fee_type%TYPE,
96: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
97: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
98: p_v_course_cd IN igs_ps_ver.course_cd%TYPE,

Line 284: TYPE sp_fees_rec_type IS RECORD( person_id hz_parties.party_id%TYPE,

280: reversed charges.
281: Obsoleted the cursor CUR_FEE_DECLINED
282: ******************************************************************/
283:
284: TYPE sp_fees_rec_type IS RECORD( person_id hz_parties.party_id%TYPE,
285: course_cd igs_ps_ver.course_cd%TYPE,
286: uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
287: fee_type igs_fi_fee_type.fee_type%TYPE,
288: fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

Line 301: CURSOR cur_get_sum_sp_fees(cp_n_person_id hz_parties.party_id%TYPE,

297: l_sp_fees_tbl sp_fees_tab;
298:
299: -- Cursor to determine sum of Special Fees for a student from the special fees table
300: -- This does not include the Retention Fees
301: CURSOR cur_get_sum_sp_fees(cp_n_person_id hz_parties.party_id%TYPE,
302: cp_v_course_cd igs_ps_ver.course_cd%TYPE,
303: cp_n_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
304: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
305: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,

Line 320: CURSOR cur_unit_load(cp_n_person_id hz_parties.party_id%TYPE,

316: AND s_transaction_type_code <> cp_v_transaction_type_cd
317: GROUP BY fee_type, invoice_id;
318:
319: -- Cursor to determine if the current unit attempt is assessable or not
320: CURSOR cur_unit_load(cp_n_person_id hz_parties.party_id%TYPE,
321: cp_v_course_cd igs_ps_ver.course_cd%TYPE,
322: cp_n_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
323: cp_v_unit_att_status igs_lookups_view.lookup_type%TYPE,
324: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE) IS

Line 1193: PROCEDURE log_error_message(p_v_person_number hz_parties.party_number%TYPE,

1189: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;
1190: igs_ge_msg_stack.conc_exception_hndl;
1191: END assess_fees;
1192:
1193: PROCEDURE log_error_message(p_v_person_number hz_parties.party_number%TYPE,
1194: p_v_fee_period VARCHAR2,
1195: p_uooid igs_pe_std_todo_ref.uoo_id%TYPE,
1196: p_v_message_name VARCHAR2 ) IS
1197: ------------------------------------------------------------------

Line 1328: l_v_person_number hz_parties.party_number%TYPE;

1324: l_c_alt_code_desc c_get_alt_code_desc%ROWTYPE;
1325: l_v_alt_code_desc igs_ca_inst.alternate_code%TYPE;
1326: l_v_ci_desc igs_ca_inst.description%TYPE;
1327:
1328: l_v_person_number hz_parties.party_number%TYPE;
1329: l_unit_section VARCHAR2(4000);
1330:
1331: l_message_name fnd_new_messages.message_name%TYPE;
1332: -- To identify whether any records are found for given the input criteria.