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_SS_GEN_001 dependencies on IGS_AD_PRCS_CAT_STEP_ALL

Line 4913: CURSOR cpcs(cp_admission_cat IGS_AD_PRCS_CAT_STEP_ALL.admission_Cat%TYPE,

4909: Change History
4910: Who When What
4911: *****************************************************************************************/
4912:
4913: CURSOR cpcs(cp_admission_cat IGS_AD_PRCS_CAT_STEP_ALL.admission_Cat%TYPE,
4914: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP_ALL.s_admission_process_type%TYPE,
4915: cp_page_code IGS_AD_SS_APPL_CONF.page_code%TYPE,
4916: cp_comp_code IGS_AD_SS_APPL_CONF.component_code%TYPE) IS
4917: SELECT mandatory_step_ind, s_admission_step_type, step_group_type

Line 4914: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP_ALL.s_admission_process_type%TYPE,

4910: Who When What
4911: *****************************************************************************************/
4912:
4913: CURSOR cpcs(cp_admission_cat IGS_AD_PRCS_CAT_STEP_ALL.admission_Cat%TYPE,
4914: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP_ALL.s_admission_process_type%TYPE,
4915: cp_page_code IGS_AD_SS_APPL_CONF.page_code%TYPE,
4916: cp_comp_code IGS_AD_SS_APPL_CONF.component_code%TYPE) IS
4917: SELECT mandatory_step_ind, s_admission_step_type, step_group_type
4918: FROM IGS_AD_PRCS_CAT_STEP_ALL

Line 4918: FROM IGS_AD_PRCS_CAT_STEP_ALL

4914: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP_ALL.s_admission_process_type%TYPE,
4915: cp_page_code IGS_AD_SS_APPL_CONF.page_code%TYPE,
4916: cp_comp_code IGS_AD_SS_APPL_CONF.component_code%TYPE) IS
4917: SELECT mandatory_step_ind, s_admission_step_type, step_group_type
4918: FROM IGS_AD_PRCS_CAT_STEP_ALL
4919: WHERE admission_Cat = cp_admission_cat
4920: AND s_admission_process_type = cp_s_admission_process_type
4921: AND s_admission_step_type =
4922: (SELECT apc_step

Line 4945: lv_mand_ind IGS_AD_PRCS_CAT_STEP_ALL.mandatory_step_ind%TYPE;

4941:
4942: TYPE ApplCurType IS REF CURSOR;
4943: ssat_cv ApplCurType;
4944:
4945: lv_mand_ind IGS_AD_PRCS_CAT_STEP_ALL.mandatory_step_ind%TYPE;
4946: lv_step IGS_AD_PRCS_CAT_STEP_ALL.s_admission_step_type%TYPE;
4947: lv_step_grp IGS_AD_PRCS_CAT_STEP_ALL.step_group_type%TYPE;
4948: lv_include_flag IGS_AD_SS_APPL_COMPS.include_flag%TYPE;
4949: lv_required_flag IGS_AD_SS_APPL_COMPS.required_flag%TYPE;

Line 4946: lv_step IGS_AD_PRCS_CAT_STEP_ALL.s_admission_step_type%TYPE;

4942: TYPE ApplCurType IS REF CURSOR;
4943: ssat_cv ApplCurType;
4944:
4945: lv_mand_ind IGS_AD_PRCS_CAT_STEP_ALL.mandatory_step_ind%TYPE;
4946: lv_step IGS_AD_PRCS_CAT_STEP_ALL.s_admission_step_type%TYPE;
4947: lv_step_grp IGS_AD_PRCS_CAT_STEP_ALL.step_group_type%TYPE;
4948: lv_include_flag IGS_AD_SS_APPL_COMPS.include_flag%TYPE;
4949: lv_required_flag IGS_AD_SS_APPL_COMPS.required_flag%TYPE;
4950: appl_type_count NUMBER;

Line 4947: lv_step_grp IGS_AD_PRCS_CAT_STEP_ALL.step_group_type%TYPE;

4943: ssat_cv ApplCurType;
4944:
4945: lv_mand_ind IGS_AD_PRCS_CAT_STEP_ALL.mandatory_step_ind%TYPE;
4946: lv_step IGS_AD_PRCS_CAT_STEP_ALL.s_admission_step_type%TYPE;
4947: lv_step_grp IGS_AD_PRCS_CAT_STEP_ALL.step_group_type%TYPE;
4948: lv_include_flag IGS_AD_SS_APPL_COMPS.include_flag%TYPE;
4949: lv_required_flag IGS_AD_SS_APPL_COMPS.required_flag%TYPE;
4950: appl_type_count NUMBER;
4951: