APPS.IGS_AD_SS_GEN_001 dependencies on IGS_AD_SS_APPL_PGS

Line 3181: FROM igs_ad_ss_appl_pgs pgs

3177: *****************************************************************************************/
3178:
3179: CURSOR c_chklist(cp_ApplNum igs_ss_Adm_appl_stg.SS_ADM_APPL_ID%TYPE, cp_person_id igs_ss_Adm_appl_stg.PERSON_ID%TYPE) IS
3180: SELECT pgs.page_name section
3181: FROM igs_ad_ss_appl_pgs pgs
3182: WHERE pgs.admission_application_type =
3183: (SELECT admission_application_type
3184: FROM igs_ss_adm_appl_stg
3185: WHERE ss_adm_appl_id = cp_ApplNum)

Line 4599: FROM igs_ad_ss_appl_pgs

4595: Who When What
4596: *****************************************************************************************/
4597: CURSOR c_NoPgs(cp_ApplType igs_ss_Adm_appl_stg.ADMISSION_APPLICATION_TYPE%TYPE) IS
4598: SELECT count(*)
4599: FROM igs_ad_ss_appl_pgs
4600: WHERE admission_application_type = cp_ApplType
4601: AND include_ind = 'Y';
4602:
4603: BEGIN

Line 4709: CURSOR c_app_pgs (cp_appl_type igs_ad_ss_appl_pgs.admission_application_type%TYPE)

4705: AND conf.page_code = cp_page_code
4706: AND lkv.ENABLED_FLAG = 'Y'
4707: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE) AND NVL(END_DATE_ACTIVE,SYSDATE);
4708:
4709: CURSOR c_app_pgs (cp_appl_type igs_ad_ss_appl_pgs.admission_application_type%TYPE)
4710: IS
4711: SELECT page_name FROM igs_ad_ss_appl_pgs WHERE
4712: admission_application_type = cp_appl_type;
4713:

Line 4711: SELECT page_name FROM igs_ad_ss_appl_pgs WHERE

4707: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE) AND NVL(END_DATE_ACTIVE,SYSDATE);
4708:
4709: CURSOR c_app_pgs (cp_appl_type igs_ad_ss_appl_pgs.admission_application_type%TYPE)
4710: IS
4711: SELECT page_name FROM igs_ad_ss_appl_pgs WHERE
4712: admission_application_type = cp_appl_type;
4713:
4714: lv_order igs_ad_ss_appl_pgs.disp_order%type;
4715: lv_rowid VARCHAR2(25);

Line 4714: lv_order igs_ad_ss_appl_pgs.disp_order%type;

4710: IS
4711: SELECT page_name FROM igs_ad_ss_appl_pgs WHERE
4712: admission_application_type = cp_appl_type;
4713:
4714: lv_order igs_ad_ss_appl_pgs.disp_order%type;
4715: lv_rowid VARCHAR2(25);
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;

Line 4753: igs_ad_ss_appl_pgs_pkg.add_row (

4749: lv_order := 16;
4750: END IF;
4751: lv_appl_type := p_appl_type;
4752: -- dbms_output.put_line('Satya - Before Inserting Page : '||cpgs_rec.page_code);
4753: igs_ad_ss_appl_pgs_pkg.add_row (
4754: x_mode => 'R',
4755: x_rowid => lv_rowid,
4756: x_admission_application_type => lv_appl_type,
4757: x_page_name => cpgs_rec.page_code,

Line 4928: CURSOR sspg_upd(cp_Admission_application_type IGS_AD_SS_APPL_PGS.Admission_application_type%TYPE) IS

4924: WHERE page_code = cp_page_code
4925: AND component_code = cp_comp_code
4926: AND apc_step IS NOT NULL);
4927:
4928: CURSOR sspg_upd(cp_Admission_application_type IGS_AD_SS_APPL_PGS.Admission_application_type%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:

Line 4930: FROM IGS_AD_SS_APPL_PGS

4926: AND apc_step IS NOT NULL);
4927:
4928: CURSOR sspg_upd(cp_Admission_application_type IGS_AD_SS_APPL_PGS.Admission_application_type%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

Line 5099: -- Update the pages table IGS_AD_SS_APPL_PGS set Include_ind = Y where application_type = page.application_type

5095: END LOOP; -- Application Types
5096:
5097:
5098: -- Include the page if the component for the page is included.
5099: -- Update the pages table IGS_AD_SS_APPL_PGS set Include_ind = Y where application_type = page.application_type
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

Line 5102: UPDATE IGS_AD_SS_APPL_PGS pgs SET Include_ind = 'Y' WHERE

5098: -- Include the page if the component for the page is included.
5099: -- Update the pages table IGS_AD_SS_APPL_PGS set Include_ind = Y where application_type = page.application_type
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