APPS.IGS_PS_VALIDATE_GENERIC_PKG dependencies on IGS_PS_UNITASS_ITEM

Line 337: FROM igs_ps_unitass_item

333: cp_st_en_dt_rec cp_st_en_dt%ROWTYPE;
334:
335: CURSOR c_reference(cp_n_uoo_id NUMBER,cp_reference VARCHAR2) IS
336: SELECT 'X'
337: FROM igs_ps_unitass_item
338: WHERE uoo_id = cp_n_uoo_id
339: AND reference = cp_reference
340: AND logical_delete_dt IS NULL;
341:

Line 353: FROM igs_ps_unitass_item

349: c_usec_rec c_usec%ROWTYPE;
350:
351: CURSOR c_action_dt(cp_assessment_id igs_as_assessmnt_itm.ass_id%TYPE,cp_uoo_id NUMBER,cp_sequence_number NUMBER) IS
352: SELECT *
353: FROM igs_ps_unitass_item
354: WHERE ass_id =cp_assessment_id
355: AND uoo_id =cp_uoo_id
356: AND sequence_number =cp_sequence_number ;
357:

Line 368: l_grading_schema_cd igs_ps_unitass_item.grading_schema_cd%TYPE;

364: FROM igs_as_assessmnt_itm
365: WHERE ass_id = cp_assessment_id;
366: l_cur_assessment_id cur_assessment_id%ROWTYPE;
367:
368: l_grading_schema_cd igs_ps_unitass_item.grading_schema_cd%TYPE;
369: l_gs_version_number igs_ps_unitass_item.gs_version_number%TYPE;
370: l_description igs_as_grd_schema.description%TYPE;
371: l_approved VARCHAR2 (1);
372:

Line 369: l_gs_version_number igs_ps_unitass_item.gs_version_number%TYPE;

365: WHERE ass_id = cp_assessment_id;
366: l_cur_assessment_id cur_assessment_id%ROWTYPE;
367:
368: l_grading_schema_cd igs_ps_unitass_item.grading_schema_cd%TYPE;
369: l_gs_version_number igs_ps_unitass_item.gs_version_number%TYPE;
370: l_description igs_as_grd_schema.description%TYPE;
371: l_approved VARCHAR2 (1);
372:
373: CURSOR cur_grading_approved(cp_unit_cd VARCHAR2,cp_version_number NUMBER,cp_assessment_type VARCHAR2,cp_grading_schema_cd VARCHAR2,cp_gs_version_number NUMBER) IS

Line 1819: FROM igs_ps_unitass_item

1815: SELECT NVL (SUM (final_weight_qty), 0) sum_final_weight_qty,
1816: NVL (SUM (midterm_weight_qty), 0) sum_midterm_weight_qty,
1817: COUNT (us_ass_item_group_id) number_of_ai,
1818: COUNT (DECODE (dflt_item_ind, 'Y', 1, NULL)) number_of_default_ai
1819: FROM igs_ps_unitass_item
1820: WHERE us_ass_item_group_id = cp_us_ass_item_group_id
1821: AND logical_delete_dt IS NULL;
1822:
1823: CURSOR cur_group (cp_rec_as_us_ai igs_ps_generic_pub.usec_ass_item_grp_rec_type) IS