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_SS_APPL_CONF

Line 4673: cp_page_code IGS_AD_SS_APPL_CONF.page_code%TYPE,

4669: */
4670:
4671: CURSOR cpcs (cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_Cat%TYPE,
4672: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE,
4673: cp_page_code IGS_AD_SS_APPL_CONF.page_code%TYPE,
4674: cp_comp_code IGS_AD_SS_APPL_CONF.component_code%TYPE) IS
4675: SELECT mandatory_step_ind --, s_admission_step_type --, step_group_type
4676: FROM IGS_AD_PRCS_CAT_STEP
4677: WHERE admission_Cat = cp_admission_cat

Line 4674: cp_comp_code IGS_AD_SS_APPL_CONF.component_code%TYPE) IS

4670:
4671: CURSOR cpcs (cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_Cat%TYPE,
4672: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE,
4673: cp_page_code IGS_AD_SS_APPL_CONF.page_code%TYPE,
4674: cp_comp_code IGS_AD_SS_APPL_CONF.component_code%TYPE) IS
4675: SELECT mandatory_step_ind --, s_admission_step_type --, step_group_type
4676: FROM IGS_AD_PRCS_CAT_STEP
4677: WHERE admission_Cat = cp_admission_cat
4678: AND s_admission_process_type = cp_s_admission_process_type

Line 4679: AND s_admission_step_type = (SELECT apc_step FROM igs_ad_ss_appl_conf

4675: SELECT mandatory_step_ind --, s_admission_step_type --, step_group_type
4676: FROM IGS_AD_PRCS_CAT_STEP
4677: WHERE admission_Cat = cp_admission_cat
4678: AND s_admission_process_type = cp_s_admission_process_type
4679: AND s_admission_step_type = (SELECT apc_step FROM igs_ad_ss_appl_conf
4680: WHERE page_code = cp_page_code
4681: AND component_code = cp_comp_code);
4682:
4683: CURSOR cpgs IS

Line 4687: FROM igs_ad_ss_appl_conf conf,

4683: CURSOR cpgs IS
4684: SELECT
4685: DISTINCT conf.page_code,
4686: lkv.meaning page_desc
4687: FROM igs_ad_ss_appl_conf conf,
4688: igs_lookup_values lkv
4689: WHERE
4690: lkv.lookup_type = 'SS_APPL_SELFSERVICE_PAGES'
4691: AND lkv.lookup_code = conf.page_code

Line 4695: CURSOR cpcomps (cp_page_code IGS_AD_SS_APPL_CONF.page_code%TYPE)

4691: AND lkv.lookup_code = conf.page_code
4692: AND lkv.ENABLED_FLAG = 'Y'
4693: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE) AND NVL(END_DATE_ACTIVE,SYSDATE) ;
4694:
4695: CURSOR cpcomps (cp_page_code IGS_AD_SS_APPL_CONF.page_code%TYPE)
4696: IS
4697: SELECT conf.page_code, conf.component_code,
4698: lkv.meaning component_desc,
4699: conf.include_flag, conf.apc_step

Line 4700: FROM IGS_AD_SS_APPL_CONF conf,

4696: IS
4697: SELECT conf.page_code, conf.component_code,
4698: lkv.meaning component_desc,
4699: conf.include_flag, conf.apc_step
4700: FROM IGS_AD_SS_APPL_CONF conf,
4701: igs_lookup_values lkv
4702: WHERE
4703: lkv.lookup_type = 'IGS_AD_SS_PG_COMPS'
4704: AND lkv.lookup_code = conf.component_code

Line 4915: cp_page_code IGS_AD_SS_APPL_CONF.page_code%TYPE,

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
4919: WHERE admission_Cat = cp_admission_cat

Line 4916: cp_comp_code IGS_AD_SS_APPL_CONF.component_code%TYPE) IS

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
4919: WHERE admission_Cat = cp_admission_cat
4920: AND s_admission_process_type = cp_s_admission_process_type

Line 4923: FROM IGS_AD_SS_APPL_CONF

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
4923: FROM IGS_AD_SS_APPL_CONF
4924: WHERE page_code = cp_page_code
4925: AND component_code = cp_comp_code
4926: AND apc_step IS NOT NULL);
4927: