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_AS_GEN_003 dependencies on IGS_PS_UNITASS_ITEM

Line 874: igs_ps_unitass_item usai

870: -- the student where logical date is null.
871: CURSOR c_sus IS
872: SELECT usai.due_dt
873: FROM igs_en_su_attempt sua,
874: igs_ps_unitass_item usai
875: WHERE sua.person_id = p_person_id AND
876: sua.course_cd = p_course_cd AND
877: -- anilk, 22-Apr-2003, Bug# 2829262
878: sua.uoo_id = p_uoo_id AND

Line 893: igs_ps_unitass_item usai

889: -- maximum.
890: CURSOR c_sus_del IS
891: SELECT usai.due_dt
892: FROM igs_en_su_attempt sua,
893: igs_ps_unitass_item usai
894: WHERE sua.person_id = p_person_id AND
895: sua.course_cd = p_course_cd AND
896: -- anilk, 22-Apr-2003, Bug# 2829262
897: sua.uoo_id = p_uoo_id AND

Line 902: FROM igs_ps_unitass_item usai1

898: usai.ass_id = p_ass_id AND
899: sua.uoo_id = usai.uoo_id AND
900: usai.logical_delete_dt = (
901: SELECT MAX(usai1.logical_delete_dt)
902: FROM igs_ps_unitass_item usai1
903: WHERE usai1.uoo_id = sua.uoo_id and
904: usai1.ass_id = usai.ass_id) AND
905: IGS_AS_VAL_UAI.assp_val_sua_ai_acot(usai.ass_id,
906: sua.person_id,

Line 1022: igs_ps_unitass_item usai

1018: -- the student where logical date is null.
1019: CURSOR c_sus IS
1020: SELECT usai.reference
1021: FROM igs_en_su_attempt sua,
1022: igs_ps_unitass_item usai
1023: WHERE sua.person_id = p_person_id AND
1024: sua.course_cd = p_course_cd AND
1025: -- anilk, 22-Apr-2003, Bug# 2829262
1026: sua.uoo_id = p_uoo_id AND

Line 1041: igs_ps_unitass_item usai

1037: -- maximum.
1038: CURSOR c_sus_del IS
1039: SELECT usai.reference
1040: FROM igs_en_su_attempt sua,
1041: igs_ps_unitass_item usai
1042: WHERE sua.person_id = p_person_id AND
1043: sua.course_cd = p_course_cd AND
1044: -- anilk, 22-Apr-2003, Bug# 2829262
1045: sua.uoo_id = p_uoo_id AND

Line 1050: FROM igs_ps_unitass_item usai1

1046: usai.ass_id = p_ass_id AND
1047: sua.uoo_id = usai.uoo_id AND
1048: usai.logical_delete_dt = (
1049: SELECT MAX(usai1.logical_delete_dt)
1050: FROM igs_ps_unitass_item usai1
1051: WHERE usai1.uoo_id = sua.uoo_id and
1052: usai1.ass_id = usai.ass_id) AND
1053: IGS_AS_VAL_UAI.assp_val_sua_ai_acot(usai.ass_id,
1054: sua.person_id,

Line 1291: FROM igs_ps_unitass_item

1287: -- anilk, 22-Apr-2003, Bug# 2829262
1288: uoo_id = p_uoo_id;
1289: CURSOR c_us_grad_ver( l_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
1290: SELECT grading_schema_cd, gs_version_number
1291: FROM igs_ps_unitass_item
1292: WHERE uoo_id = l_uoo_id AND
1293: ass_id = p_ass_id AND
1294: logical_delete_dt IS NULL;
1295: CURSOR c_u_grad_ver ( l_version_number igs_en_su_attempt.version_number%TYPE) IS

Line 1948: usaii in igs_ps_unitass_item.unit_section_ass_item_id%type,

1944: END;
1945: END assp_get_sua_rel_marks;
1946:
1947: FUNCTION assp_get_ai_ref(
1948: usaii in igs_ps_unitass_item.unit_section_ass_item_id%type,
1949: uaii in igs_as_unitass_item.unit_ass_item_id%type
1950: )
1951: RETURN VARCHAR2 IS
1952: BEGIN

Line 1954: CURSOR c_ref_ps (usaid igs_ps_unitass_item.unit_section_ass_item_id%TYPE)IS

1950: )
1951: RETURN VARCHAR2 IS
1952: BEGIN
1953: DECLARE
1954: CURSOR c_ref_ps (usaid igs_ps_unitass_item.unit_section_ass_item_id%TYPE)IS
1955: SELECT reference, release_date
1956: FROM igs_ps_unitass_item
1957: WHERE unit_section_ass_item_id = usaid;
1958: CURSOR c_ref_as (uaid igs_as_unitass_item.unit_ass_item_id%TYPE)IS

Line 1956: FROM igs_ps_unitass_item

1952: BEGIN
1953: DECLARE
1954: CURSOR c_ref_ps (usaid igs_ps_unitass_item.unit_section_ass_item_id%TYPE)IS
1955: SELECT reference, release_date
1956: FROM igs_ps_unitass_item
1957: WHERE unit_section_ass_item_id = usaid;
1958: CURSOR c_ref_as (uaid igs_as_unitass_item.unit_ass_item_id%TYPE)IS
1959: SELECT reference, release_date
1960: FROM igs_as_unitass_item

Line 1982: usaii in igs_ps_unitass_item.unit_section_ass_item_id%type,

1978: RAISE;
1979: END assp_get_ai_ref;
1980:
1981: FUNCTION assp_get_ai_reldate(
1982: usaii in igs_ps_unitass_item.unit_section_ass_item_id%type,
1983: uaii in igs_as_unitass_item.unit_ass_item_id%type
1984: )
1985: RETURN DATE IS
1986: BEGIN

Line 1988: CURSOR c_ref_ps (usaid igs_ps_unitass_item.unit_section_ass_item_id%TYPE)IS

1984: )
1985: RETURN DATE IS
1986: BEGIN
1987: DECLARE
1988: CURSOR c_ref_ps (usaid igs_ps_unitass_item.unit_section_ass_item_id%TYPE)IS
1989: SELECT reference, release_date
1990: FROM igs_ps_unitass_item
1991: WHERE unit_section_ass_item_id = usaid;
1992: CURSOR c_ref_as (uaid igs_as_unitass_item.unit_ass_item_id%TYPE)IS

Line 1990: FROM igs_ps_unitass_item

1986: BEGIN
1987: DECLARE
1988: CURSOR c_ref_ps (usaid igs_ps_unitass_item.unit_section_ass_item_id%TYPE)IS
1989: SELECT reference, release_date
1990: FROM igs_ps_unitass_item
1991: WHERE unit_section_ass_item_id = usaid;
1992: CURSOR c_ref_as (uaid igs_as_unitass_item.unit_ass_item_id%TYPE)IS
1993: SELECT reference, release_date
1994: FROM igs_as_unitass_item