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_EN_NSC_PKG dependencies on IGS_PS_VER

Line 276: FROM igs_en_stdnt_ps_Att spa , igs_ps_ver vers, hz_parties hp, igs_pe_hz_parties ihp,

272: --such that they belong to the local institution .
273:
274: CURSOR c_course (cp_nslc_condition VARCHAR2 )IS
275: SELECT DISTINCT spa.course_cd, spa.version_number, hp.party_id org_id, ihp.oss_org_unit_cd org_unit_cd
276: FROM igs_en_stdnt_ps_Att spa , igs_ps_ver vers, hz_parties hp, igs_pe_hz_parties ihp,
277: igs_or_status os
278: WHERE vers.course_cd=spa.course_cd
279: AND vers.version_number=spa.version_number
280: AND spa.cal_type = l_acad_cal_type

Line 308: CURSOR c_persons_for_course (cp_course_cd igs_ps_ver.course_cd%TYPE,cp_course_ver igs_ps_ver.version_number%TYPE, cp_nslc_condition VARCHAR2, l_grd_type VARCHAR2) IS

304: --or a unit_attempt exists for a given term, or a lapsed date exists within the
305: --term. The inactive and intermit status records are fetched irrespective of
306: --the d.ates
307:
308: CURSOR c_persons_for_course (cp_course_cd igs_ps_ver.course_cd%TYPE,cp_course_ver igs_ps_ver.version_number%TYPE, cp_nslc_condition VARCHAR2, l_grd_type VARCHAR2) IS
309: SELECT spa.person_id FROM igs_en_stdnt_ps_att spa
310: WHERE course_cd=cp_course_cd
311: AND version_number=cp_course_ver
312: AND spa.cal_type = l_acad_cal_type

Line 466: l_course_cd igs_ps_ver.course_cd%TYPE;

462: l_check VARCHAR2(20);
463: l_succ_orgs VARCHAR2(32000):=NULL;
464: l_fail_orgs VARCHAR2(32000):=NULL;
465: l_per_done BOOLEAN:=FALSE;
466: l_course_cd igs_ps_ver.course_cd%TYPE;
467: l_version_number igs_ps_ver.version_number%TYPE;
468:
469: CURSOR c_rowid(p_inst_id IGS_EN_DOC_INSTANCES.doc_inst_id%TYPE) IS
470: SELECT rowid

Line 467: l_version_number igs_ps_ver.version_number%TYPE;

463: l_succ_orgs VARCHAR2(32000):=NULL;
464: l_fail_orgs VARCHAR2(32000):=NULL;
465: l_per_done BOOLEAN:=FALSE;
466: l_course_cd igs_ps_ver.course_cd%TYPE;
467: l_version_number igs_ps_ver.version_number%TYPE;
468:
469: CURSOR c_rowid(p_inst_id IGS_EN_DOC_INSTANCES.doc_inst_id%TYPE) IS
470: SELECT rowid
471: FROM igs_en_doc_instances

Line 1855: FROM igs_ps_ver_all

1851: FROM igs_en_nsc_options
1852: WHERE opt_type='GR_LVL_IND'
1853: AND opt_val IN (SELECT course_type_group_cd FROM igs_ps_type
1854: WHERE course_type = ( SELECT course_type
1855: FROM igs_ps_ver_all
1856: WHERE course_cd = p_course_cd
1857: AND version_number = p_version_number
1858: )
1859: );

Line 1873: FROM igs_ps_ver_all

1869: FROM igs_en_nsc_options
1870: WHERE opt_type='CO_PRG_TG'
1871: AND opt_val IN (SELECT course_type_group_cd FROM igs_ps_type
1872: WHERE course_type = (SELECT course_type
1873: FROM igs_ps_ver_all
1874: WHERE course_cd = p_course_cd
1875: AND version_number=p_version_number
1876: )
1877: );

Line 1887: igs_en_stdnt_ps_att pr,igs_ps_ver vers,igs_ca_load_to_teach_v lt

1883: -- smaddali modified for performance bug#4914052
1884: CURSOR c_outcome_dt(p_corresp_prg VARCHAR2) IS
1885: SELECT DISTINCT asv.outcome_dt
1886: FROM igs_as_su_atmpt_itm asv, igs_en_su_attempt asav,
1887: igs_en_stdnt_ps_att pr,igs_ps_ver vers,igs_ca_load_to_teach_v lt
1888: WHERE asv.person_id = asav.person_id
1889: AND asv.course_cd = asav.course_cd
1890: AND asv.uoo_id = asav.uoo_id
1891: AND asav.person_id = pr.person_id

Line 1925: igs_ps_ver vers

1921: pr.version_number vers,
1922: pr.course_attempt_status status,
1923: pr.lapsed_dt lapsed_dt
1924: FROM igs_en_stdnt_ps_att pr,
1925: igs_ps_ver vers
1926: WHERE pr.person_id = p_student_id
1927: AND pr.cal_type = p_acad_cal_type
1928: AND
1929: (

Line 2680: igs_ps_ver vers

2676: ut.override_enrolled_cp override_enrolled_cp,
2677: ut.override_eftsu override_eftsu
2678: FROM igs_en_su_attempt ut,
2679: igs_en_stdnt_ps_att pr,
2680: igs_ps_ver vers
2681: WHERE (ut.cal_type,ut.ci_sequence_number) IN
2682: (SELECT teach_cal_type,
2683: teach_ci_sequence_number
2684: FROM igs_ca_load_to_teach_v

Line 2728: igs_ps_ver vers

2724: ut.unit_attempt_status,
2725: ut.discontinued_dt
2726: FROM igs_en_su_attempt_h ut,
2727: igs_en_stdnt_ps_att pr,
2728: igs_ps_ver vers
2729: WHERE ut.cal_type = p_teach_cal_type
2730: AND ut.ci_sequence_number = p_teach_ci_sequence_number
2731: AND ut.person_id = p_student_id
2732: AND ut.course_cd = pr.course_cd