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.

[Home] [Help]

APPS.IGS_HE_EXTRACT_PKG dependencies on IGS_HE_EXT_RUN_PRMS

Line 212: FROM igs_he_ext_run_prms

208: IS
209:
210: CURSOR c_person(cp_person_id IN igs_en_stdnt_ps_att.person_id%TYPE) IS
211: SELECT 'X'
212: FROM igs_he_ext_run_prms
213: WHERE extract_run_id = p_extract_run_id
214: AND only = cp_person_id
215: AND param_type = 'RECALC-PERSON';
216:

Line 219: FROM igs_he_ext_run_prms

215: AND param_type = 'RECALC-PERSON';
216:
217: CURSOR c_program(cp_person_id IN igs_en_stdnt_ps_att.course_cd%TYPE) IS
218: SELECT 'X'
219: FROM igs_he_ext_run_prms
220: WHERE extract_run_id = p_extract_run_id
221: AND only = cp_person_id
222: AND param_type = 'RECALC-PROGRAM';
223:

Line 296: FROM igs_he_ext_run_prms

292: CURSOR c_prm IS
293: SELECT param_type,
294: exclude,
295: only
296: FROM igs_he_ext_run_prms
297: WHERE extract_run_id = p_extract_run_id
298: AND (exclude IS NOT NULL
299: OR only IS NOT NULL)
300: AND param_type IN ('PSN_IDENT_GROUP', 'PSN_ID')

Line 449: FROM igs_he_ext_run_prms

445: exclude) exclude,
446: DECODE(only, 'YES', 'Y',
447: 'NO', 'N',
448: only) only
449: FROM igs_he_ext_run_prms
450: WHERE extract_run_id = p_extract_run_id
451: AND (exclude IS NOT NULL
452: OR only IS NOT NULL)
453: AND param_type IN ('PROGRAM' ,'DORMANT','VISIT_EXCHANGE','POST_CODE' )

Line 480: FROM igs_he_ext_run_prms

476: --smaddali added these cursors for bug#3166126
477: -- check if exclude / only parameters are setup for Prog cat
478: CURSOR c_prg_cat_exst IS
479: SELECT exclude, only
480: FROM igs_he_ext_run_prms
481: WHERE extract_run_id = p_extract_run_id
482: AND param_type = 'PROGRAM_CATEGORY' ;
483: c_prg_cat_exst_rec c_prg_cat_exst%ROWTYPE ;
484:

Line 488: FROM igs_he_ext_run_prms

484:
485: -- check if exclude / only parameters are setup for Prog group
486: CURSOR c_prg_grp_exst IS
487: SELECT exclude, only
488: FROM igs_he_ext_run_prms
489: WHERE extract_run_id = p_extract_run_id
490: AND param_type = 'PROGRAM_GROUP' ;
491: c_prg_grp_exst_rec c_prg_grp_exst%ROWTYPE ;
492:

Line 501: AND course_cat IN ( SELECT exclude FROM igs_he_ext_run_prms

497: SELECT 'X'
498: FROM igs_ps_categorise_all
499: WHERE course_cd = p_course_cd
500: AND version_number = p_version_number
501: AND course_cat IN ( SELECT exclude FROM igs_he_ext_run_prms
502: WHERE extract_run_id = p_extract_run_id
503: AND exclude IS NOT NULL
504: AND param_type ='PROGRAM_CATEGORY') ;
505: -- Check if the passed program belongs to any ONLY Program category

Line 513: AND course_cat IN ( SELECT only FROM igs_he_ext_run_prms

509: SELECT 'X'
510: FROM igs_ps_categorise_all
511: WHERE course_cd = p_course_cd
512: AND version_number = p_version_number
513: AND course_cat IN ( SELECT only FROM igs_he_ext_run_prms
514: WHERE extract_run_id = p_extract_run_id
515: AND only IS NOT NULL
516: AND param_type ='PROGRAM_CATEGORY') ;
517:

Line 526: AND course_group_cd IN ( SELECT exclude FROM igs_he_ext_run_prms

522: SELECT 'X'
523: FROM igs_ps_grp_mbr
524: WHERE course_cd = p_course_cd
525: AND version_number = p_version_number
526: AND course_group_cd IN ( SELECT exclude FROM igs_he_ext_run_prms
527: WHERE extract_run_id = p_extract_run_id
528: AND exclude IS NOT NULL
529: AND param_type ='PROGRAM_GROUP') ;
530: -- Check if the passed program belongs to any ONLY Program group

Line 538: AND course_group_cd IN ( SELECT only FROM igs_he_ext_run_prms

534: SELECT 'X'
535: FROM igs_ps_grp_mbr
536: WHERE course_cd = p_course_cd
537: AND version_number = p_version_number
538: AND course_group_cd IN ( SELECT only FROM igs_he_ext_run_prms
539: WHERE extract_run_id = p_extract_run_id
540: AND only IS NOT NULL
541: AND param_type ='PROGRAM_GROUP') ;
542: -- end bug#3166126

Line 787: FROM igs_he_ext_run_prms

783: exclude) exclude,
784: DECODE(only, 'YES', 'Y',
785: 'NO', 'N',
786: only) only
787: FROM igs_he_ext_run_prms
788: WHERE extract_run_id = p_extract_run_id
789: AND (exclude IS NOT NULL
790: OR only IS NOT NULL)
791: AND param_type IN ( 'ORG_UNIT' ,'PROGRAM_YEAR','OUTSIDE_UK','FE')

Line 1998: FROM igs_he_ext_run_prms

1994: CURSOR c_dlhe_prm IS
1995: SELECT param_type,
1996: exclude,
1997: only
1998: FROM igs_he_ext_run_prms
1999: WHERE extract_run_id = p_extract_run_id
2000: AND (exclude IS NOT NULL
2001: OR only IS NOT NULL)
2002: AND param_type IN ('DLHE','POPDLHE');

Line 2195: FROM igs_he_ext_run_prms

2191: ***************************************************************/
2192:
2193: CURSOR c_recalc_criteria IS
2194: SELECT 'X'
2195: FROM igs_he_ext_run_prms
2196: WHERE extract_run_id = p_extract_run_id
2197: AND param_type IN ('RECALC-PERSON', 'RECALC-PROGRAM');
2198:
2199: CURSOR c_mrk_row IS

Line 2215: OR person_id IN (SELECT only from igs_he_ext_run_prms WHERE param_type = 'RECALC-PERSON' AND extract_run_id = p_extract_run_id)

2211: FROM igs_he_ex_rn_dat_ln
2212: WHERE extract_run_id = p_extract_run_id
2213: AND manually_inserted = 'N'
2214: AND (recalculate_flag = 'Y'
2215: OR person_id IN (SELECT only from igs_he_ext_run_prms WHERE param_type = 'RECALC-PERSON' AND extract_run_id = p_extract_run_id)
2216: OR course_cd IN (SELECT only from igs_he_ext_run_prms WHERE param_type = 'RECALC-PROGRAM'AND extract_run_id = p_extract_run_id));
2217:
2218: l_he_ext_run_interim igs_he_ext_run_interim%ROWTYPE;
2219: l_rowid VARCHAR2(50);

Line 2216: OR course_cd IN (SELECT only from igs_he_ext_run_prms WHERE param_type = 'RECALC-PROGRAM'AND extract_run_id = p_extract_run_id));

2212: WHERE extract_run_id = p_extract_run_id
2213: AND manually_inserted = 'N'
2214: AND (recalculate_flag = 'Y'
2215: OR person_id IN (SELECT only from igs_he_ext_run_prms WHERE param_type = 'RECALC-PERSON' AND extract_run_id = p_extract_run_id)
2216: OR course_cd IN (SELECT only from igs_he_ext_run_prms WHERE param_type = 'RECALC-PROGRAM'AND extract_run_id = p_extract_run_id));
2217:
2218: l_he_ext_run_interim igs_he_ext_run_interim%ROWTYPE;
2219: l_rowid VARCHAR2(50);
2220: l_temp VARCHAR2(3);