APPS.IGS_FI_REFUNDS_PROCESS dependencies on IGS_PE_PERSON

Line 41: g_last_person_id igs_pe_person.person_id%TYPE :=NULL;

37: g_v_offset CONSTANT VARCHAR2(15) := 'OFFSET';
38:
39: g_b_data_found BOOLEAN := FALSE;
40:
41: g_last_person_id igs_pe_person.person_id%TYPE :=NULL;
42: g_update_last_person igs_fi_parties_v.person_id%TYPE :=NULL;
43:
44: e_resource_busy EXCEPTION;
45: PRAGMA EXCEPTION_INIT(e_resource_busy,-0054);

Line 47: CURSOR cur_ref(cp_person_id igs_pe_person.person_id%TYPE,

43:
44: e_resource_busy EXCEPTION;
45: PRAGMA EXCEPTION_INIT(e_resource_busy,-0054);
46:
47: CURSOR cur_ref(cp_person_id igs_pe_person.person_id%TYPE,
48: cp_start_date igs_fi_refunds.voucher_date%TYPE,
49: cp_end_date igs_fi_refunds.voucher_date%TYPE) IS
50: SELECT rfnd.*,rfnd.rowid
51: FROM igs_fi_refunds rfnd

Line 59: CURSOR cur_refund(cp_person_id igs_pe_person.person_id%TYPE,

55: AND (TRUNC(rfnd.voucher_date) >= TRUNC(cp_start_date) OR (cp_start_date IS NULL))
56: AND (TRUNC(rfnd.voucher_date) <= TRUNC(cp_end_date) OR (cp_end_date IS NULL))
57: ORDER BY rfnd.person_id,rfnd.refund_id;
58:
59: CURSOR cur_refund(cp_person_id igs_pe_person.person_id%TYPE,
60: cp_start_date igs_fi_refunds.voucher_date%TYPE,
61: cp_end_date igs_fi_refunds.voucher_date%TYPE) IS
62: SELECT rfnd.*,rfnd.rowid
63: FROM igs_fi_refunds rfnd

Line 97: PROCEDURE log_person(p_person_id igs_pe_person_v.person_id%TYPE,

93: );
94: RETURN l_cur_desc;
95: END lookup_desc;
96:
97: PROCEDURE log_person(p_person_id igs_pe_person_v.person_id%TYPE,
98: p_invoice_id igs_fi_refunds.invoice_id%TYPE,
99: p_refund_id igs_fi_refunds.refund_id%TYPE,
100: p_pay_person_id igs_fi_refunds.pay_person_id%TYPE,
101: p_fee_type igs_fi_refunds.fee_type%TYPE,

Line 372: PROCEDURE transfer_int_rec(p_person_id igs_pe_person.person_id%TYPE,

368: p_err_msg:=sqlerrm;
369: END IF;
370: END insert_interface;
371:
372: PROCEDURE transfer_int_rec(p_person_id igs_pe_person.person_id%TYPE,
373: p_test_run igs_lookups_view.lookup_code%TYPE,
374: p_start_date igs_fi_refunds.voucher_date%TYPE,
375: p_end_date igs_fi_refunds.voucher_date%TYPE) AS
376: /***********************************************************************************************

Line 527: p_person_id IN igs_pe_person.person_id%TYPE,

523: END transfer_int_rec;
524:
525: PROCEDURE transfer_to_int( errbuf OUT NOCOPY VARCHAR2,
526: retcode OUT NOCOPY NUMBER,
527: p_person_id IN igs_pe_person.person_id%TYPE,
528: p_person_id_grp IN igs_pe_persid_group.group_id%TYPE,
529: p_start_date IN VARCHAR2,
530: p_end_date IN VARCHAR2,
531: p_test_run IN igs_lookups_view.lookup_code%TYPE) AS