APPS.IGS_PS_GEN_001 dependencies on IGS_PS_USEC_SPNSRSHP

Line 2216: FROM igs_ps_usec_spnsrshp

2212:
2213: -- 10
2214: CURSOR usec_spn ( p_uoo_id NUMBER) IS
2215: SELECT *
2216: FROM igs_ps_usec_spnsrshp
2217: WHERE uoo_id = p_uoo_id;
2218:
2219: --11
2220: CURSOR usec_tchr ( p_uoo_id NUMBER) IS

Line 3221: CURSOR cur_usec_spn_new (cp_uoo_id igs_ps_usec_spnsrshp.uoo_id%TYPE,

3217: --Enhancement bug no 1800179, pmarada
3218: -- Rollover of unit section sponsorship records
3219: FOR usec_spn_rec IN usec_spn (p_old_uoo_Id ) LOOP
3220: DECLARE
3221: CURSOR cur_usec_spn_new (cp_uoo_id igs_ps_usec_spnsrshp.uoo_id%TYPE,
3222: cp_organization_code igs_ps_usec_spnsrshp.organization_code%TYPE) IS
3223: SELECT 'X'
3224: FROM igs_ps_usec_spnsrshp
3225: WHERE uoo_id = cp_uoo_id

Line 3222: cp_organization_code igs_ps_usec_spnsrshp.organization_code%TYPE) IS

3218: -- Rollover of unit section sponsorship records
3219: FOR usec_spn_rec IN usec_spn (p_old_uoo_Id ) LOOP
3220: DECLARE
3221: CURSOR cur_usec_spn_new (cp_uoo_id igs_ps_usec_spnsrshp.uoo_id%TYPE,
3222: cp_organization_code igs_ps_usec_spnsrshp.organization_code%TYPE) IS
3223: SELECT 'X'
3224: FROM igs_ps_usec_spnsrshp
3225: WHERE uoo_id = cp_uoo_id
3226: AND organization_code = cp_organization_code

Line 3224: FROM igs_ps_usec_spnsrshp

3220: DECLARE
3221: CURSOR cur_usec_spn_new (cp_uoo_id igs_ps_usec_spnsrshp.uoo_id%TYPE,
3222: cp_organization_code igs_ps_usec_spnsrshp.organization_code%TYPE) IS
3223: SELECT 'X'
3224: FROM igs_ps_usec_spnsrshp
3225: WHERE uoo_id = cp_uoo_id
3226: AND organization_code = cp_organization_code
3227: AND ROWNUM = 1;
3228: l_cur_usec_spn_new cur_usec_spn_new%ROWTYPE;

Line 3237: igs_ps_usec_spnsrshp_pkg.insert_row (

3233:
3234: OPEN cur_usec_spn_new(p_new_uoo_id,usec_spn_rec.organization_code);
3235: FETCH cur_usec_spn_new INTO l_cur_usec_spn_new;
3236: IF cur_usec_spn_new%NOTFOUND THEN
3237: igs_ps_usec_spnsrshp_pkg.insert_row (
3238: x_rowid => lv_rowid,
3239: x_unit_section_sponsorship_id => l_usec_spn_id,
3240: x_uoo_id => p_new_uoo_id,
3241: x_organization_code => usec_spn_rec.organization_code ,