APPS.IGS_PS_GEN_001 dependencies on IGS_PS_UNITASS_ITEM

Line 17: --Nalin Kumar 26-May-2003 Modified the call to the igs_ps_unitass_item_pkg.insert row;

13: -- in the call to igs_ps_usec_cps_pkg.insert_row
14: --jbegum 16-Jun-2003 Bug#2983445 .Obsoleted the column award_title from igs_ps_award table.
15: --smvk 09-Jun-2003 Bug # 2858436. Modified the procedure crsp_ins_crs_ver.
16: --shtatiko 03-JUN-2003 Enh# 2831572, Modified crsp_ins_unit_section and crsp_ins_crs_ver
17: --Nalin Kumar 26-May-2003 Modified the call to the igs_ps_unitass_item_pkg.insert row;
18: -- Passed the correct value to the newly added parameter (x_descroption) of the insert_row;
19: -- This is as per Assessment Item Build. Bug# 2829291;
20: --
21: --sarakshi 24-Apr-2003 Enh#2858431,added procedure change_unit_section_status ,also modified the call to igs_ps_usec_ocur_ref_pkg.insert_row

Line 2238: CURSOR usec_unitass ( cp_uoo_id igs_ps_unitass_item.uoo_id%TYPE,

2234: FROM igs_as_us_ai_group
2235: WHERE uoo_id = p_uoo_id;
2236:
2237: --13.2
2238: CURSOR usec_unitass ( cp_uoo_id igs_ps_unitass_item.uoo_id%TYPE,
2239: cp_us_ass_item_group_id igs_ps_unitass_item.us_ass_item_group_id%TYPE) IS
2240: SELECT *
2241: FROM igs_ps_unitass_item
2242: WHERE uoo_id = cp_uoo_id

Line 2239: cp_us_ass_item_group_id igs_ps_unitass_item.us_ass_item_group_id%TYPE) IS

2235: WHERE uoo_id = p_uoo_id;
2236:
2237: --13.2
2238: CURSOR usec_unitass ( cp_uoo_id igs_ps_unitass_item.uoo_id%TYPE,
2239: cp_us_ass_item_group_id igs_ps_unitass_item.us_ass_item_group_id%TYPE) IS
2240: SELECT *
2241: FROM igs_ps_unitass_item
2242: WHERE uoo_id = cp_uoo_id
2243: AND us_ass_item_group_id=cp_us_ass_item_group_id;

Line 2241: FROM igs_ps_unitass_item

2237: --13.2
2238: CURSOR usec_unitass ( cp_uoo_id igs_ps_unitass_item.uoo_id%TYPE,
2239: cp_us_ass_item_group_id igs_ps_unitass_item.us_ass_item_group_id%TYPE) IS
2240: SELECT *
2241: FROM igs_ps_unitass_item
2242: WHERE uoo_id = cp_uoo_id
2243: AND us_ass_item_group_id=cp_us_ass_item_group_id;
2244:
2245: --14

Line 2367: FROM igs_ps_unitass_item

2363: l_config_rec_found BOOLEAN;
2364:
2365: CURSOR cur_ass_item(cp_uoo_id IN NUMBER, cp_us_ass_item_group_id IN NUMBER) IS
2366: SELECT 'X'
2367: FROM igs_ps_unitass_item
2368: WHERE uoo_id = cp_uoo_id
2369: AND us_ass_item_group_id = cp_us_ass_item_group_id;
2370: l_c_var VARCHAR2(1);
2371:

Line 3411: igs_ps_unitass_item_pkg.insert_row(

3407: l_ci_start_dt DATE;
3408: l_ci_end_dt DATE;
3409: BEGIN
3410: -- Modification of the procedure call is done by DDEY as a part of Bug #2162831
3411: igs_ps_unitass_item_pkg.insert_row(
3412: x_rowid => lv_rowid,
3413: x_unit_section_ass_item_id => l_usec_assitem_id,
3414: x_uoo_id => p_new_uoo_id,
3415: x_ass_id => usec_unitass_rec.ass_id ,