APPS.IGS_FI_REFUNDS_PROCESS dependencies on IGS_LOOKUPS_VIEW

Line 72: FUNCTION lookup_desc( p_type IN igs_lookups_view.lookup_type%TYPE,

68: AND (TRUNC(rfnd.voucher_date) >= TRUNC(cp_start_date) OR (cp_start_date IS NULL))
69: AND (TRUNC(rfnd.voucher_date) <= TRUNC(cp_end_date) OR (cp_end_date IS NULL))
70: ORDER BY rfnd.person_id,rfnd.refund_id;
71:
72: FUNCTION lookup_desc( p_type IN igs_lookups_view.lookup_type%TYPE,
73: p_code IN igs_lookups_view.lookup_code%TYPE)
74: RETURN VARCHAR2 IS
75: /***********************************************************************************************
76:

Line 73: p_code IN igs_lookups_view.lookup_code%TYPE)

69: AND (TRUNC(rfnd.voucher_date) <= TRUNC(cp_end_date) OR (cp_end_date IS NULL))
70: ORDER BY rfnd.person_id,rfnd.refund_id;
71:
72: FUNCTION lookup_desc( p_type IN igs_lookups_view.lookup_type%TYPE,
73: p_code IN igs_lookups_view.lookup_code%TYPE)
74: RETURN VARCHAR2 IS
75: /***********************************************************************************************
76:
77: Created By : Sarakshi

Line 373: p_test_run igs_lookups_view.lookup_code%TYPE,

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: /***********************************************************************************************
377:

Line 531: p_test_run IN igs_lookups_view.lookup_code%TYPE) AS

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
532: /***********************************************************************************************
533: Created By : Sarakshi
534: Date Created By: 1-Mar-2001
535: Purpose : To Transfer refunds records to interface table and to update the status

Line 786: p_test_run IN igs_lookups_view.lookup_code%TYPE)

782: p_person_id IN igs_fi_parties_v.person_id%TYPE,
783: p_person_id_group IN igs_pe_persid_group.group_id%TYPE,
784: p_start_date IN VARCHAR2,
785: p_end_date IN VARCHAR2,
786: p_test_run IN igs_lookups_view.lookup_code%TYPE)
787: AS
788: /***********************************************************************************************
789: Created By : vchappid
790: Date Created By: 04-MAR-2001