[Home] [Help]
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
532: /***********************************************************************************************
543: Added validation for manage_account - call to chk_manage_account()
544: Added code to log messages for test run = Y and for no-data-found cases
545: Increased width of l_v_sql_query from 1000 to 32767
546: pathipat 18-Feb-2003 Enh 2747329 - Payables Intg build
547: 1. Modified cursor cur_pers_grp - used igs_pe_all_persid_group_v instead of igs_pe_persid_group
548: Changed declaration of l_group_code accordingly.
549: 2. Added validation to check for Refunds Destination before allowing the process to be run
550: 3. Modified approach to identify persons in a person id group
551: vvutukur 03-Jan-2003 Bug#2727216.Modified the logic for logging the parameters, by removing the
595: l_valid_param BOOLEAN := TRUE;
596:
597: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;
598: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
599: lv_group_type igs_pe_persid_group_v.group_type%TYPE;
600:
601: BEGIN
602:
603: -- initialises the out parameter to 0
779:
780: PROCEDURE update_pay_info ( errbuf OUT NOCOPY VARCHAR2,
781: retcode OUT NOCOPY NUMBER,
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