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_COMPS

Line 3969: CURSOR c_pgcomps(cp_Appl_Type IGS_AD_SS_APPL_COMPS.Admission_application_type%TYPE, cp_page_Name IGS_AD_SS_APPL_COMPS.page_name%TYPE) IS

3965: CURSOR c_emp_hist(cp_person_id igs_ad_appl.person_id%TYPE) IS
3966: SELECT 'x' FROM HZ_EMPLOYMENT_HISTORY WHERE party_id = cp_person_id;
3967:
3968: -- Cursor for selecting components for a given page.
3969: CURSOR c_pgcomps(cp_Appl_Type IGS_AD_SS_APPL_COMPS.Admission_application_type%TYPE, cp_page_Name IGS_AD_SS_APPL_COMPS.page_name%TYPE) IS
3970: SELECT Admission_application_type ApplType,
3971: page_name PageName,
3972: component_code Component,
3973: comp_disp_name ComponentDesc,

Line 3975: FROM IGS_AD_SS_APPL_COMPS

3971: page_name PageName,
3972: component_code Component,
3973: comp_disp_name ComponentDesc,
3974: required_flag
3975: FROM IGS_AD_SS_APPL_COMPS
3976: WHERE Admission_application_type = cp_Appl_Type
3977: AND page_name = cp_page_Name
3978: AND include_flag = 'Y';
3979:

Line 3981: CURSOR c_req_comps_exist(cp_Appl_Type IGS_AD_SS_APPL_COMPS.Admission_application_type%TYPE, cp_page_Name IGS_AD_SS_APPL_COMPS.page_name%TYPE) IS

3977: AND page_name = cp_page_Name
3978: AND include_flag = 'Y';
3979:
3980: -- Cursor to check whether AppType has required components for a given page.
3981: CURSOR c_req_comps_exist(cp_Appl_Type IGS_AD_SS_APPL_COMPS.Admission_application_type%TYPE, cp_page_Name IGS_AD_SS_APPL_COMPS.page_name%TYPE) IS
3982: SELECT 'x'
3983: FROM IGS_AD_SS_APPL_COMPS
3984: WHERE Admission_application_type = cp_Appl_Type
3985: AND page_name = cp_page_Name

Line 3983: FROM IGS_AD_SS_APPL_COMPS

3979:
3980: -- Cursor to check whether AppType has required components for a given page.
3981: CURSOR c_req_comps_exist(cp_Appl_Type IGS_AD_SS_APPL_COMPS.Admission_application_type%TYPE, cp_page_Name IGS_AD_SS_APPL_COMPS.page_name%TYPE) IS
3982: SELECT 'x'
3983: FROM IGS_AD_SS_APPL_COMPS
3984: WHERE Admission_application_type = cp_Appl_Type
3985: AND page_name = cp_page_Name
3986: AND include_flag = 'Y'
3987: AND required_flag = 'Y';

Line 4720: lv_req_flag igs_ad_ss_appl_comps.required_flag%type;

4716: lv_mand_ind VARCHAR2(1);
4717: lv_cond_disp_name igs_ad_ss_terms.COND_DISP_NAME%type;
4718: lv_cond_disp_txt igs_ad_ss_terms.COND_DISP_TEXT%type;
4719: lv_incl_flag igs_ad_ss_terms.INCLUDE_FLAG%type;
4720: lv_req_flag igs_ad_ss_appl_comps.required_flag%type;
4721: lv_appl_type igs_ad_ss_appl_typ.admission_application_type%TYPE;
4722:
4723: BEGIN
4724:

Line 4794: igs_ad_ss_appl_comps_pkg.add_row (

4790: END IF;
4791: lv_appl_type := p_appl_type;
4792:
4793: -- dbms_output.put_line('Satya - Before Inserting component : '||cpcomps_rec.component_code);
4794: igs_ad_ss_appl_comps_pkg.add_row (
4795: x_mode => 'R',
4796: x_rowid => lv_rowid,
4797: x_admission_application_type => lv_appl_type,
4798: x_page_name => cpcomps_rec.page_code,

Line 4863: p_Appl_type IGS_AD_SS_APPL_COMPS.Admission_application_type%TYPE,

4859:
4860: /* Local function to check if component is included in an Application Type for a Page */
4861: FUNCTION isPgCompIncluded
4862: (
4863: p_Appl_type IGS_AD_SS_APPL_COMPS.Admission_application_type%TYPE,
4864: p_page_code IGS_AD_SS_APPL_COMPS.Page_name%TYPE,
4865: p_comp_code IGS_AD_SS_APPL_COMPS.component_code%TYPE
4866: ) RETURN BOOLEAN IS
4867:

Line 4864: p_page_code IGS_AD_SS_APPL_COMPS.Page_name%TYPE,

4860: /* Local function to check if component is included in an Application Type for a Page */
4861: FUNCTION isPgCompIncluded
4862: (
4863: p_Appl_type IGS_AD_SS_APPL_COMPS.Admission_application_type%TYPE,
4864: p_page_code IGS_AD_SS_APPL_COMPS.Page_name%TYPE,
4865: p_comp_code IGS_AD_SS_APPL_COMPS.component_code%TYPE
4866: ) RETURN BOOLEAN IS
4867:
4868: CURSOR sspc (cp_p_Appl_type IGS_AD_SS_APPL_COMPS.Admission_application_type%TYPE,

Line 4865: p_comp_code IGS_AD_SS_APPL_COMPS.component_code%TYPE

4861: FUNCTION isPgCompIncluded
4862: (
4863: p_Appl_type IGS_AD_SS_APPL_COMPS.Admission_application_type%TYPE,
4864: p_page_code IGS_AD_SS_APPL_COMPS.Page_name%TYPE,
4865: p_comp_code IGS_AD_SS_APPL_COMPS.component_code%TYPE
4866: ) RETURN BOOLEAN IS
4867:
4868: CURSOR sspc (cp_p_Appl_type IGS_AD_SS_APPL_COMPS.Admission_application_type%TYPE,
4869: cp_page_code IGS_AD_SS_APPL_COMPS.Page_name%TYPE,

Line 4868: CURSOR sspc (cp_p_Appl_type IGS_AD_SS_APPL_COMPS.Admission_application_type%TYPE,

4864: p_page_code IGS_AD_SS_APPL_COMPS.Page_name%TYPE,
4865: p_comp_code IGS_AD_SS_APPL_COMPS.component_code%TYPE
4866: ) RETURN BOOLEAN IS
4867:
4868: CURSOR sspc (cp_p_Appl_type IGS_AD_SS_APPL_COMPS.Admission_application_type%TYPE,
4869: cp_page_code IGS_AD_SS_APPL_COMPS.Page_name%TYPE,
4870: cp_comp_code IGS_AD_SS_APPL_COMPS.component_code%TYPE ) IS
4871: SELECT 'x'
4872: FROM IGS_AD_SS_APPL_COMPS

Line 4869: cp_page_code IGS_AD_SS_APPL_COMPS.Page_name%TYPE,

4865: p_comp_code IGS_AD_SS_APPL_COMPS.component_code%TYPE
4866: ) RETURN BOOLEAN IS
4867:
4868: CURSOR sspc (cp_p_Appl_type IGS_AD_SS_APPL_COMPS.Admission_application_type%TYPE,
4869: cp_page_code IGS_AD_SS_APPL_COMPS.Page_name%TYPE,
4870: cp_comp_code IGS_AD_SS_APPL_COMPS.component_code%TYPE ) IS
4871: SELECT 'x'
4872: FROM IGS_AD_SS_APPL_COMPS
4873: WHERE Admission_application_type = cp_p_Appl_type

Line 4870: cp_comp_code IGS_AD_SS_APPL_COMPS.component_code%TYPE ) IS

4866: ) RETURN BOOLEAN IS
4867:
4868: CURSOR sspc (cp_p_Appl_type IGS_AD_SS_APPL_COMPS.Admission_application_type%TYPE,
4869: cp_page_code IGS_AD_SS_APPL_COMPS.Page_name%TYPE,
4870: cp_comp_code IGS_AD_SS_APPL_COMPS.component_code%TYPE ) IS
4871: SELECT 'x'
4872: FROM IGS_AD_SS_APPL_COMPS
4873: WHERE Admission_application_type = cp_p_Appl_type
4874: AND Page_name = cp_page_code

Line 4872: FROM IGS_AD_SS_APPL_COMPS

4868: CURSOR sspc (cp_p_Appl_type IGS_AD_SS_APPL_COMPS.Admission_application_type%TYPE,
4869: cp_page_code IGS_AD_SS_APPL_COMPS.Page_name%TYPE,
4870: cp_comp_code IGS_AD_SS_APPL_COMPS.component_code%TYPE ) IS
4871: SELECT 'x'
4872: FROM IGS_AD_SS_APPL_COMPS
4873: WHERE Admission_application_type = cp_p_Appl_type
4874: AND Page_name = cp_page_code
4875: AND component_code = cp_comp_code
4876: AND Include_flag = 'Y';

Line 4933: CURSOR sspc_upd(cp_Admission_application_type IGS_AD_SS_APPL_COMPS.Admission_application_type%TYPE, cp_page_code IGS_AD_SS_APPL_COMPS.Page_name%TYPE) IS

4929: SELECT Admission_application_type, Page_name, Include_Ind
4930: FROM IGS_AD_SS_APPL_PGS
4931: WHERE Admission_application_type = cp_Admission_application_type;
4932:
4933: CURSOR sspc_upd(cp_Admission_application_type IGS_AD_SS_APPL_COMPS.Admission_application_type%TYPE, cp_page_code IGS_AD_SS_APPL_COMPS.Page_name%TYPE) IS
4934: SELECT Admission_application_type, Page_name,component_code, Include_flag, Required_flag
4935: FROM IGS_AD_SS_APPL_COMPS
4936: WHERE Admission_application_type = cp_Admission_application_type
4937: AND Page_name = cp_page_code;

Line 4935: FROM IGS_AD_SS_APPL_COMPS

4931: WHERE Admission_application_type = cp_Admission_application_type;
4932:
4933: CURSOR sspc_upd(cp_Admission_application_type IGS_AD_SS_APPL_COMPS.Admission_application_type%TYPE, cp_page_code IGS_AD_SS_APPL_COMPS.Page_name%TYPE) IS
4934: SELECT Admission_application_type, Page_name,component_code, Include_flag, Required_flag
4935: FROM IGS_AD_SS_APPL_COMPS
4936: WHERE Admission_application_type = cp_Admission_application_type
4937: AND Page_name = cp_page_code;
4938:
4939: TYPE appl_type IS TABLE OF IGS_AD_SS_APPL_TYP.admission_application_type%TYPE INDEX BY BINARY_INTEGER;

Line 4948: lv_include_flag IGS_AD_SS_APPL_COMPS.include_flag%TYPE;

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:
4952: BEGIN

Line 4949: lv_required_flag IGS_AD_SS_APPL_COMPS.required_flag%TYPE;

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:
4952: BEGIN
4953:

Line 4997: UPDATE igs_ad_ss_appl_comps

4993:
4994: -- Upadate the compoents table with Required_ind = Y and Include_ind = Y for the page=component.page_name
4995: -- and component =component.comp_name
4996:
4997: UPDATE igs_ad_ss_appl_comps
4998: SET include_flag = 'Y' , required_flag = 'Y'
4999: WHERE Admission_application_type =
5000: appl_pg_comps_rec.Admission_application_type
5001: AND page_name = appl_pg_comps_rec.page_name

Line 5019: UPDATE igs_ad_ss_appl_comps

5015: appl_pg_comps_rec.Include_flag = 'Y' THEN
5016: IF appl_pg_comps_rec.Required_flag <> 'Y' THEN
5017: -- Upadate the compoents table with Required_ind = Y for the page=component.page_name
5018: -- and component =component.comp_name
5019: UPDATE igs_ad_ss_appl_comps
5020: SET required_flag = 'Y'
5021: WHERE Admission_application_type =
5022: appl_pg_comps_rec.Admission_application_type
5023: AND page_name = appl_pg_comps_rec.page_name

Line 5031: UPDATE igs_ad_ss_appl_comps

5027:
5028: ELSIF (appl_pg_comps_rec.page_name = 'PERSONAL_INFO' AND
5029: NOT isPgCompIncluded(appl_pg_comps_rec.Admission_application_type,'FURTHER_INFO',appl_pg_comps_rec.component_code))
5030: THEN
5031: UPDATE igs_ad_ss_appl_comps
5032: SET include_flag = 'Y' , required_flag = 'Y'
5033: WHERE Admission_application_type =
5034: appl_pg_comps_rec.Admission_application_type
5035: AND page_name = appl_pg_comps_rec.page_name

Line 5049: UPDATE igs_ad_ss_appl_comps

5045:
5046: -- Upadate the compoents table with Required_ind = Y for the page=component.page_name
5047: -- and component =component.comp_name and application_type = component.application_type
5048:
5049: UPDATE igs_ad_ss_appl_comps
5050: SET required_flag = 'Y'
5051: WHERE Admission_application_type =
5052: appl_pg_comps_rec.Admission_application_type
5053: AND page_name = appl_pg_comps_rec.page_name

Line 5060: UPDATE igs_ad_ss_appl_comps

5056: END IF;
5057: ELSIF (appl_pg_comps_rec.page_name = 'ADDRESS_INFO' AND
5058: NOT isPgCompIncluded(appl_pg_comps_rec.Admission_application_type,'PERSONAL_INFO',appl_pg_comps_rec.component_code)) THEN
5059:
5060: UPDATE igs_ad_ss_appl_comps
5061: SET include_flag = 'Y' , required_flag = 'Y'
5062: WHERE Admission_application_type =
5063: appl_pg_comps_rec.Admission_application_type
5064: AND page_name = appl_pg_comps_rec.page_name

Line 5073: UPDATE igs_ad_ss_appl_comps

5069: IF appl_pg_comps_rec.include_flag <> 'Y' OR
5070: appl_pg_comps_rec.required_flag <> 'Y' THEN
5071:
5072: IF appl_pg_comps_rec.component_code IN ('MILITARY','FIN_VER') THEN
5073: UPDATE igs_ad_ss_appl_comps
5074: SET include_flag = 'Y' , required_flag = 'N'
5075: WHERE Admission_application_type = appl_pg_comps_rec.Admission_application_type
5076: AND page_name = appl_pg_comps_rec.page_name
5077: AND component_code = appl_pg_comps_rec.component_code;

Line 5079: UPDATE igs_ad_ss_appl_comps

5075: WHERE Admission_application_type = appl_pg_comps_rec.Admission_application_type
5076: AND page_name = appl_pg_comps_rec.page_name
5077: AND component_code = appl_pg_comps_rec.component_code;
5078: ELSE
5079: UPDATE igs_ad_ss_appl_comps
5080: SET include_flag = 'Y' , required_flag = 'Y'
5081: WHERE Admission_application_type = appl_pg_comps_rec.Admission_application_type
5082: AND page_name = appl_pg_comps_rec.page_name
5083: AND component_code = appl_pg_comps_rec.component_code;

Line 5104: EXISTS (SELECT 'x' FROM IGS_AD_SS_APPL_COMPS comps WHERE

5100: -- and page_name = page.page_name;
5101: FORALL i IN 1 .. appl_type_count
5102: UPDATE IGS_AD_SS_APPL_PGS pgs SET Include_ind = 'Y' WHERE
5103: pgs.ADMISSION_APPLICATION_TYPE = appl_type_table(i) AND
5104: EXISTS (SELECT 'x' FROM IGS_AD_SS_APPL_COMPS comps WHERE
5105: comps.ADMISSION_APPLICATION_TYPE = appl_type_table(i)
5106: AND comps.Page_name = pgs.page_name
5107: AND comps.Include_flag = 'Y');
5108: