APPS.IGS_PS_GEN_001 dependencies on IGS_PS_USEC_CATEGORY

Line 2290: FROM igs_ps_usec_category

2286:
2287: -- 20
2288: CURSOR usec_cat (cp_uoo_id NUMBER) IS
2289: SELECT *
2290: FROM igs_ps_usec_category
2291: WHERE uoo_id = cp_uoo_id;
2292:
2293: -- 21
2294: CURSOR usec_plushr (cp_uoo_id NUMBER) IS

Line 3779: CURSOR cur_usec_cat_new (cp_uoo_id igs_ps_usec_category.uoo_id%TYPE,

3775:
3776: -- Rollover of unit section categories record
3777: FOR usec_cat_rec IN usec_cat (p_old_uoo_id ) LOOP
3778: DECLARE
3779: CURSOR cur_usec_cat_new (cp_uoo_id igs_ps_usec_category.uoo_id%TYPE,
3780: cp_unit_cat igs_ps_usec_category.unit_cat%TYPE) IS
3781: SELECT 'X'
3782: FROM igs_ps_usec_category
3783: WHERE uoo_id = cp_uoo_id

Line 3780: cp_unit_cat igs_ps_usec_category.unit_cat%TYPE) IS

3776: -- Rollover of unit section categories record
3777: FOR usec_cat_rec IN usec_cat (p_old_uoo_id ) LOOP
3778: DECLARE
3779: CURSOR cur_usec_cat_new (cp_uoo_id igs_ps_usec_category.uoo_id%TYPE,
3780: cp_unit_cat igs_ps_usec_category.unit_cat%TYPE) IS
3781: SELECT 'X'
3782: FROM igs_ps_usec_category
3783: WHERE uoo_id = cp_uoo_id
3784: AND unit_cat = cp_unit_cat

Line 3782: FROM igs_ps_usec_category

3778: DECLARE
3779: CURSOR cur_usec_cat_new (cp_uoo_id igs_ps_usec_category.uoo_id%TYPE,
3780: cp_unit_cat igs_ps_usec_category.unit_cat%TYPE) IS
3781: SELECT 'X'
3782: FROM igs_ps_usec_category
3783: WHERE uoo_id = cp_uoo_id
3784: AND unit_cat = cp_unit_cat
3785: AND ROWNUM = 1;
3786: l_cur_usec_cat_new cur_usec_cat_new%ROWTYPE;

Line 3795: igs_ps_usec_category_pkg.insert_row (

3791:
3792: OPEN cur_usec_cat_new(p_new_uoo_id,usec_cat_rec.unit_cat);
3793: FETCH cur_usec_cat_new INTO l_cur_usec_cat_new;
3794: IF cur_usec_cat_new%NOTFOUND THEN
3795: igs_ps_usec_category_pkg.insert_row (
3796: x_rowid => lv_rowid,
3797: x_usec_cat_id => l_usec_cat_id,
3798: x_uoo_id => p_new_uoo_id,
3799: x_unit_cat => usec_cat_rec.unit_cat,