APPS.IGS_AS_GEN_004 dependencies on IGS_PS_UNITASS_ITEM

Line 1428: -- l_grading_schema_cd igs_ps_unitass_item.grading_schema_cd%TYPE;

1424: v_attempt_number igs_as_su_atmpt_itm.attempt_number%TYPE;
1425: v_course_type igs_ps_ver.course_type%TYPE;
1426: v_creation_dt DATE;
1427: l_update_flag VARCHAR2 (20) := 'FALSE';
1428: -- l_grading_schema_cd igs_ps_unitass_item.grading_schema_cd%TYPE;
1429: -- l_gs_version_number igs_ps_unitass_item.gs_version_number%TYPE;
1430: --
1431: -- Get the Unit Section ID
1432: --

Line 1429: -- l_gs_version_number igs_ps_unitass_item.gs_version_number%TYPE;

1425: v_course_type igs_ps_ver.course_type%TYPE;
1426: v_creation_dt DATE;
1427: l_update_flag VARCHAR2 (20) := 'FALSE';
1428: -- l_grading_schema_cd igs_ps_unitass_item.grading_schema_cd%TYPE;
1429: -- l_gs_version_number igs_ps_unitass_item.gs_version_number%TYPE;
1430: --
1431: -- Get the Unit Section ID
1432: --
1433: /* CURSOR cur_uoo_id IS

Line 1501: CURSOR c_suaai_upd (cp_ass_id igs_ps_unitass_item.ass_id%TYPE, cp_uoo_id igs_en_su_attempt.uoo_id%TYPE , cp_ass_item_id igs_as_su_atmpt_itm.unit_section_ass_item_id%TYPE ) IS

1497: -- This cursor is declared to fetch the Assessment Items which are are attached to the
1498: -- Assessment Pattern , but already logically deleted. This would enable the logical deleted
1499: -- record to be back in the system.
1500: --
1501: CURSOR c_suaai_upd (cp_ass_id igs_ps_unitass_item.ass_id%TYPE, cp_uoo_id igs_en_su_attempt.uoo_id%TYPE , cp_ass_item_id igs_as_su_atmpt_itm.unit_section_ass_item_id%TYPE ) IS
1502: SELECT suaai.ROWID,
1503: suaai.*,
1504: sag.unit_ass_item_group_id,
1505: sag.us_ass_item_group_id

Line 1687: FROM igs_ps_unitass_item

1683: CURSOR cur_usec_ass_items_exist (
1684: cp_uoo_id NUMBER
1685: ) IS
1686: SELECT 'Y' ass_item_exists
1687: FROM igs_ps_unitass_item
1688: WHERE uoo_id = cp_uoo_id
1689: AND logical_delete_dt IS NULL;
1690: --
1691: rec_usec_ass_items_exist cur_usec_ass_items_exist%ROWTYPE;

Line 1778: /* l_unit_section_ass_item_id igs_ps_unitass_item.unit_section_ass_item_id%TYPE;

1774: rec_suaig cur_unit_suaig_exists%ROWTYPE;
1775: l_group_name VARCHAR2(30);
1776: -- Bug # 3749413
1777:
1778: /* l_unit_section_ass_item_id igs_ps_unitass_item.unit_section_ass_item_id%TYPE;
1779: l_unit_ass_item_id igs_as_unitass_item_all.unit_ass_item_id%TYPE;
1780: l_midterm_mandatory_type_code VARCHAR2(30);
1781: l_midterm_weight_qty NUMBER(6,3);
1782: l_final_mandatory_type_code VARCHAR2(30);

Line 1790: l_unit_assessment_id igs_ps_unitass_item.unit_section_ass_item_id%TYPE;

1786:
1787: -- Bug # 3749413
1788:
1789: l_return_pk_id NUMBER;
1790: l_unit_assessment_id igs_ps_unitass_item.unit_section_ass_item_id%TYPE;
1791: l_us_assessment_id igs_ps_unitass_item.unit_section_ass_item_id%TYPE;
1792:
1793: -- End of new code added as per Bug# 2829291;
1794: BEGIN

Line 1791: l_us_assessment_id igs_ps_unitass_item.unit_section_ass_item_id%TYPE;

1787: -- Bug # 3749413
1788:
1789: l_return_pk_id NUMBER;
1790: l_unit_assessment_id igs_ps_unitass_item.unit_section_ass_item_id%TYPE;
1791: l_us_assessment_id igs_ps_unitass_item.unit_section_ass_item_id%TYPE;
1792:
1793: -- End of new code added as per Bug# 2829291;
1794: BEGIN
1795: --