APPS.IGS_PS_GEN_001 dependencies on IGS_AS_US_AI_GROUP

Line 2234: FROM igs_as_us_ai_group

2230:
2231: --13.1
2232: CURSOR usec_unitassgrp ( p_uoo_id NUMBER) IS
2233: SELECT *
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,

Line 3367: CURSOR cur_unitassgrp_new (cp_uoo_id igs_as_us_ai_group.uoo_id%TYPE,

3363:
3364: --ijeddy, Grade Book Enh build, bug no 3201661, Dec 3, 2003.
3365: FOR usec_unitassgrp_rec IN usec_unitassgrp (p_old_uoo_id) LOOP
3366: DECLARE
3367: CURSOR cur_unitassgrp_new (cp_uoo_id igs_as_us_ai_group.uoo_id%TYPE,
3368: cp_group_name igs_as_us_ai_group.group_name%TYPE) IS
3369: SELECT us_ass_item_group_id
3370: FROM igs_as_us_ai_group
3371: WHERE uoo_id = cp_uoo_id

Line 3368: cp_group_name igs_as_us_ai_group.group_name%TYPE) IS

3364: --ijeddy, Grade Book Enh build, bug no 3201661, Dec 3, 2003.
3365: FOR usec_unitassgrp_rec IN usec_unitassgrp (p_old_uoo_id) LOOP
3366: DECLARE
3367: CURSOR cur_unitassgrp_new (cp_uoo_id igs_as_us_ai_group.uoo_id%TYPE,
3368: cp_group_name igs_as_us_ai_group.group_name%TYPE) IS
3369: SELECT us_ass_item_group_id
3370: FROM igs_as_us_ai_group
3371: WHERE uoo_id = cp_uoo_id
3372: AND group_name = cp_group_name;

Line 3370: FROM igs_as_us_ai_group

3366: DECLARE
3367: CURSOR cur_unitassgrp_new (cp_uoo_id igs_as_us_ai_group.uoo_id%TYPE,
3368: cp_group_name igs_as_us_ai_group.group_name%TYPE) IS
3369: SELECT us_ass_item_group_id
3370: FROM igs_as_us_ai_group
3371: WHERE uoo_id = cp_uoo_id
3372: AND group_name = cp_group_name;
3373: l_rowid VARCHAR2(25);
3374: l_us_ass_item_group_id NUMBER;

Line 3381: igs_as_us_ai_group_pkg.insert_row (

3377: l_us_ass_item_group_id := NULL;
3378: OPEN cur_unitassgrp_new(p_new_uoo_id,usec_unitassgrp_rec.group_name);
3379: FETCH cur_unitassgrp_new INTO l_us_ass_item_group_id;
3380: IF cur_unitassgrp_new%NOTFOUND THEN
3381: igs_as_us_ai_group_pkg.insert_row (
3382: x_rowid => l_rowid,
3383: x_us_ass_item_group_id => l_us_ass_item_group_id,
3384: x_uoo_id => p_new_uoo_id,
3385: x_group_name => usec_unitassgrp_rec.group_name,