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

Line 1795: From igs_ad_prcs_cat_step

1791:
1792:
1793: Select 'X'
1794: Into l_accept
1795: From igs_ad_prcs_cat_step
1796: Where S_ADMISSION_STEP_TYPE = 'AUTO-ACCEPT'
1797: And ADMISSION_CAT = p_admission_cat
1798: And S_ADMISSION_PROCESS_TYPE = p_admission_process_type
1799: And STEP_GROUP_TYPE <> 'TRACK'; --2402377

Line 1810: From igs_ad_prcs_cat_step

1806: END IF;
1807:
1808: Select 'X'
1809: Into l_offer
1810: From igs_ad_prcs_cat_step
1811: Where S_ADMISSION_STEP_TYPE = 'AUTO-OFFER'
1812: And ADMISSION_CAT = p_admission_cat
1813: And S_ADMISSION_PROCESS_TYPE = p_admission_process_type
1814: And STEP_GROUP_TYPE <> 'TRACK'; -- 2402377

Line 3247: FROM igs_ad_prcs_cat_step

3243: p_message_name OUT NOCOPY VARCHAR2,
3244: p_return_type OUT NOCOPY VARCHAR2) IS
3245: CURSOR c_apcs IS
3246: SELECT s_admission_step_type, step_type_restriction_num
3247: FROM igs_ad_prcs_cat_step
3248: WHERE admission_cat = p_admission_cat
3249: AND s_admission_process_type = p_s_admission_process_type
3250: AND step_group_type <> 'TRACK';
3251:

Line 4671: CURSOR cpcs (cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_Cat%TYPE,

4667: -- Cursor To retrieve the SS Pages from Application Type Configuration Setup table.
4668: -- Cursor to retrieve the SS page Components from Application Type Configuration Setup table
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

Line 4672: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE,

4668: -- Cursor to retrieve the SS page Components from Application Type Configuration Setup table
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

Line 4676: FROM IGS_AD_PRCS_CAT_STEP

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
4679: AND s_admission_step_type = (SELECT apc_step FROM igs_ad_ss_appl_conf
4680: WHERE page_code = cp_page_code

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:

Line 5146: FROM igs_ad_prcs_cat_step

5142: WHERE ss_adm_appl_id = cp_ss_adm_appl_id;
5143:
5144: CURSOR c_apcs (cp_step_type VARCHAR2, cp_admission_cat VARCHAR2, cp_s_admission_process_type VARCHAR2) IS
5145: SELECT s_admission_step_type, step_type_restriction_num
5146: FROM igs_ad_prcs_cat_step
5147: WHERE admission_cat = cp_admission_cat
5148: AND s_admission_process_type = cp_s_admission_process_type
5149: AND s_admission_step_type = cp_step_type
5150: AND step_group_type <> 'TRACK';

Line 5317: FROM igs_ad_prcs_cat_step

5313: WHERE ss_adm_appl_id = cp_ss_adm_appl_id;
5314:
5315: CURSOR c_apcs (cp_step_type VARCHAR2, cp_admission_cat VARCHAR2, cp_s_admission_process_type VARCHAR2) IS
5316: SELECT s_admission_step_type, step_type_restriction_num
5317: FROM igs_ad_prcs_cat_step
5318: WHERE admission_cat = cp_admission_cat
5319: AND s_admission_process_type = cp_s_admission_process_type
5320: AND s_admission_step_type = cp_step_type
5321: AND step_group_type <> 'TRACK';