APPS.IGS_SV_UTIL dependencies on IGS_PE_NONIMG_FORM

Line 639: p_person_id IN igs_pe_nonimg_form.person_id%TYPE,

635: END GET_BTCH_PROCESS_DT;
636:
637:
638: PROCEDURE GET_PROGRAM_DATES(
639: p_person_id IN igs_pe_nonimg_form.person_id%TYPE,
640: p_prgm_end_date OUT NOCOPY igs_pe_nonimg_form.prgm_end_date%TYPE,
641: p_prgm_start_date OUT NOCOPY igs_pe_nonimg_form.prgm_start_date%TYPE
642: ) IS
643: /******************************************************************

Line 640: p_prgm_end_date OUT NOCOPY igs_pe_nonimg_form.prgm_end_date%TYPE,

636:
637:
638: PROCEDURE GET_PROGRAM_DATES(
639: p_person_id IN igs_pe_nonimg_form.person_id%TYPE,
640: p_prgm_end_date OUT NOCOPY igs_pe_nonimg_form.prgm_end_date%TYPE,
641: p_prgm_start_date OUT NOCOPY igs_pe_nonimg_form.prgm_start_date%TYPE
642: ) IS
643: /******************************************************************
644: Created By : Preeti Bhardwaj

Line 641: p_prgm_start_date OUT NOCOPY igs_pe_nonimg_form.prgm_start_date%TYPE

637:
638: PROCEDURE GET_PROGRAM_DATES(
639: p_person_id IN igs_pe_nonimg_form.person_id%TYPE,
640: p_prgm_end_date OUT NOCOPY igs_pe_nonimg_form.prgm_end_date%TYPE,
641: p_prgm_start_date OUT NOCOPY igs_pe_nonimg_form.prgm_start_date%TYPE
642: ) IS
643: /******************************************************************
644: Created By : Preeti Bhardwaj
645:

Line 657: CURSOR c_prg_dates(cp_form_id igs_pe_nonimg_form.nonimg_form_id%TYPE) IS

653: Who When What
654: ------------------------------------------------------------------------
655:
656: ******************************************************************/
657: CURSOR c_prg_dates(cp_form_id igs_pe_nonimg_form.nonimg_form_id%TYPE) IS
658: SELECT prgm_start_date, prgm_end_date
659: FROM igs_pe_nonimg_form ipnf
660: WHERE ipnf.person_id = p_person_id AND
661: ipnf.nonimg_form_id = cp_form_id;

Line 659: FROM igs_pe_nonimg_form ipnf

655:
656: ******************************************************************/
657: CURSOR c_prg_dates(cp_form_id igs_pe_nonimg_form.nonimg_form_id%TYPE) IS
658: SELECT prgm_start_date, prgm_end_date
659: FROM igs_pe_nonimg_form ipnf
660: WHERE ipnf.person_id = p_person_id AND
661: ipnf.nonimg_form_id = cp_form_id;
662:
663:

Line 664: CURSOR c_action_date(cp_form_id igs_pe_nonimg_form.nonimg_form_id%TYPE) IS

660: WHERE ipnf.person_id = p_person_id AND
661: ipnf.nonimg_form_id = cp_form_id;
662:
663:
664: CURSOR c_action_date(cp_form_id igs_pe_nonimg_form.nonimg_form_id%TYPE) IS
665: SELECT prgm_start_date prgm_start_date,
666: prgm_end_date prgm_end_date
667: FROM igs_pe_nonimg_stat
668: WHERE nonimg_form_id = cp_form_id

Line 673: FROM igs_pe_nonimg_form

669: ORDER BY last_update_date DESC;
670:
671: CURSOR c_form_id IS
672: SELECT nonimg_form_id
673: FROM igs_pe_nonimg_form
674: WHERE person_id = p_person_id AND
675: form_status = 'A';
676:
677: l_prgm_end_date DATE;

Line 681: l_form_id igs_pe_nonimg_form.nonimg_form_id%TYPE := 0;

677: l_prgm_end_date DATE;
678: l_prgm_start_date DATE;
679: l_temp_end_date DATE;
680: l_temp_start_date DATE;
681: l_form_id igs_pe_nonimg_form.nonimg_form_id%TYPE := 0;
682:
683: BEGIN
684: OPEN c_form_id;
685: FETCH c_form_id INTO l_form_id;