eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_GEN_016 dependencies on IGS_AD_PRCS_CAT

Line 746: lv_admission_cat igs_ad_prcs_cat.admission_cat%TYPE;

742: -- Application Type to Admission Process Category
743: FUNCTION get_appl_type_apc (p_application_type IN VARCHAR2)
744: RETURN VARCHAR2 -- Returns TRUE/FALSE
745: IS
746: lv_admission_cat igs_ad_prcs_cat.admission_cat%TYPE;
747: lv_s_admission_process_type igs_ad_prcs_cat.s_admission_process_type%TYPE;
748: BEGIN
749: RETURN (get_appl_type_apc (p_application_type => p_application_type,
750: p_admission_cat => lv_admission_cat,

Line 747: lv_s_admission_process_type igs_ad_prcs_cat.s_admission_process_type%TYPE;

743: FUNCTION get_appl_type_apc (p_application_type IN VARCHAR2)
744: RETURN VARCHAR2 -- Returns TRUE/FALSE
745: IS
746: lv_admission_cat igs_ad_prcs_cat.admission_cat%TYPE;
747: lv_s_admission_process_type igs_ad_prcs_cat.s_admission_process_type%TYPE;
748: BEGIN
749: RETURN (get_appl_type_apc (p_application_type => p_application_type,
750: p_admission_cat => lv_admission_cat,
751: p_s_admission_process_type => lv_s_admission_process_type));

Line 829: lv_mandatory_step_ind igs_ad_prcs_cat_step_all.mandatory_step_ind%TYPE;

825: p_s_admission_process_type IN VARCHAR2,
826: p_s_admission_step_type IN VARCHAR2)
827: RETURN VARCHAR2 -- Returns TRUE/FALSE
828: IS
829: lv_mandatory_step_ind igs_ad_prcs_cat_step_all.mandatory_step_ind%TYPE;
830: ln_step_type_restriction_num igs_ad_prcs_cat_step_all.step_type_restriction_num%TYPE;
831: BEGIN
832: RETURN (get_apcs (p_admission_cat => p_admission_cat,
833: p_s_admission_process_type => p_s_admission_process_type,

Line 830: ln_step_type_restriction_num igs_ad_prcs_cat_step_all.step_type_restriction_num%TYPE;

826: p_s_admission_step_type IN VARCHAR2)
827: RETURN VARCHAR2 -- Returns TRUE/FALSE
828: IS
829: lv_mandatory_step_ind igs_ad_prcs_cat_step_all.mandatory_step_ind%TYPE;
830: ln_step_type_restriction_num igs_ad_prcs_cat_step_all.step_type_restriction_num%TYPE;
831: BEGIN
832: RETURN (get_apcs (p_admission_cat => p_admission_cat,
833: p_s_admission_process_type => p_s_admission_process_type,
834: p_s_admission_step_type => p_s_admission_step_type,

Line 844: lv_mandatory_step_ind igs_ad_prcs_cat_step_all.mandatory_step_ind%TYPE;

840: p_s_admission_process_type IN VARCHAR2,
841: p_s_admission_step_type IN VARCHAR2)
842: RETURN VARCHAR2 -- Returns TRUE/FALSE
843: IS
844: lv_mandatory_step_ind igs_ad_prcs_cat_step_all.mandatory_step_ind%TYPE;
845: ln_step_type_restriction_num igs_ad_prcs_cat_step_all.step_type_restriction_num%TYPE;
846: BEGIN
847: lv_mandatory_step_ind := 'Y';
848: RETURN (get_apcs (p_admission_cat => p_admission_cat,

Line 845: ln_step_type_restriction_num igs_ad_prcs_cat_step_all.step_type_restriction_num%TYPE;

841: p_s_admission_step_type IN VARCHAR2)
842: RETURN VARCHAR2 -- Returns TRUE/FALSE
843: IS
844: lv_mandatory_step_ind igs_ad_prcs_cat_step_all.mandatory_step_ind%TYPE;
845: ln_step_type_restriction_num igs_ad_prcs_cat_step_all.step_type_restriction_num%TYPE;
846: BEGIN
847: lv_mandatory_step_ind := 'Y';
848: RETURN (get_apcs (p_admission_cat => p_admission_cat,
849: p_s_admission_process_type => p_s_admission_process_type,

Line 861: ln_step_type_restriction_num igs_ad_prcs_cat_step_all.step_type_restriction_num%TYPE;

857: p_s_admission_step_type IN VARCHAR2,
858: p_mandatory_step_ind IN OUT NOCOPY VARCHAR2)
859: RETURN VARCHAR2 -- Returns TRUE/FALSE
860: IS
861: ln_step_type_restriction_num igs_ad_prcs_cat_step_all.step_type_restriction_num%TYPE;
862: BEGIN
863: RETURN (get_apcs (p_admission_cat => p_admission_cat,
864: p_s_admission_process_type => p_s_admission_process_type,
865: p_s_admission_step_type => p_s_admission_step_type,

Line 881: lv_step_group_type_excl igs_ad_prcs_cat_step_all.step_group_type%TYPE;

877: lv_ret_success VARCHAR2(5);
878: ln_hash_apcs_idx NUMBER;
879: ln_hash_apc_idx NUMBER;
880: lb_is_apc_cached BOOLEAN;
881: lv_step_group_type_excl igs_ad_prcs_cat_step_all.step_group_type%TYPE;
882:
883: CURSOR c_apcs (lv_admission_cat VARCHAR2, lv_s_admission_process_type VARCHAR2)
884: IS
885: SELECT s_admission_step_type, mandatory_step_ind, step_type_restriction_num

Line 886: FROM igs_ad_prcs_cat_step_all

882:
883: CURSOR c_apcs (lv_admission_cat VARCHAR2, lv_s_admission_process_type VARCHAR2)
884: IS
885: SELECT s_admission_step_type, mandatory_step_ind, step_type_restriction_num
886: FROM igs_ad_prcs_cat_step_all
887: WHERE admission_cat = lv_admission_cat
888: AND s_admission_process_type = lv_s_admission_process_type
889: AND step_group_type <> lv_step_group_type_excl;
890: