APPS.IGS_PS_GEN_001 dependencies on IGS_PS_USEC_GRD_SCHM

Line 2271: FROM igs_ps_usec_grd_schm

2267:
2268: --17
2269: CURSOR usec_grdsch ( p_uoo_id NUMBER ) IS
2270: SELECT *
2271: FROM igs_ps_usec_grd_schm
2272: WHERE uoo_id = p_uoo_id;
2273:
2274: -- 18
2275: CURSOR c_unt_ofr_opt_n (cp_uoo_id NUMBER) IS

Line 3580: CURSOR cur_usec_grdsch_new (cp_uoo_id igs_ps_usec_grd_schm.uoo_id%TYPE,

3576:
3577: -- Rollover of unit section grading schema records
3578: FOR usec_grdsch_rec IN usec_grdsch (p_old_uoo_Id )LOOP
3579: DECLARE
3580: CURSOR cur_usec_grdsch_new (cp_uoo_id igs_ps_usec_grd_schm.uoo_id%TYPE,
3581: cp_grading_schema_code igs_ps_usec_grd_schm.grading_schema_code%TYPE,
3582: cp_grd_schm_version_number igs_ps_usec_grd_schm.grd_schm_version_number%TYPE) IS
3583: SELECT 'X'
3584: FROM igs_ps_usec_grd_schm

Line 3581: cp_grading_schema_code igs_ps_usec_grd_schm.grading_schema_code%TYPE,

3577: -- Rollover of unit section grading schema records
3578: FOR usec_grdsch_rec IN usec_grdsch (p_old_uoo_Id )LOOP
3579: DECLARE
3580: CURSOR cur_usec_grdsch_new (cp_uoo_id igs_ps_usec_grd_schm.uoo_id%TYPE,
3581: cp_grading_schema_code igs_ps_usec_grd_schm.grading_schema_code%TYPE,
3582: cp_grd_schm_version_number igs_ps_usec_grd_schm.grd_schm_version_number%TYPE) IS
3583: SELECT 'X'
3584: FROM igs_ps_usec_grd_schm
3585: WHERE uoo_id = cp_uoo_id

Line 3582: cp_grd_schm_version_number igs_ps_usec_grd_schm.grd_schm_version_number%TYPE) IS

3578: FOR usec_grdsch_rec IN usec_grdsch (p_old_uoo_Id )LOOP
3579: DECLARE
3580: CURSOR cur_usec_grdsch_new (cp_uoo_id igs_ps_usec_grd_schm.uoo_id%TYPE,
3581: cp_grading_schema_code igs_ps_usec_grd_schm.grading_schema_code%TYPE,
3582: cp_grd_schm_version_number igs_ps_usec_grd_schm.grd_schm_version_number%TYPE) IS
3583: SELECT 'X'
3584: FROM igs_ps_usec_grd_schm
3585: WHERE uoo_id = cp_uoo_id
3586: AND grading_schema_code = cp_grading_schema_code

Line 3584: FROM igs_ps_usec_grd_schm

3580: CURSOR cur_usec_grdsch_new (cp_uoo_id igs_ps_usec_grd_schm.uoo_id%TYPE,
3581: cp_grading_schema_code igs_ps_usec_grd_schm.grading_schema_code%TYPE,
3582: cp_grd_schm_version_number igs_ps_usec_grd_schm.grd_schm_version_number%TYPE) IS
3583: SELECT 'X'
3584: FROM igs_ps_usec_grd_schm
3585: WHERE uoo_id = cp_uoo_id
3586: AND grading_schema_code = cp_grading_schema_code
3587: AND grd_schm_version_number = cp_grd_schm_version_number
3588: AND ROWNUM = 1;

Line 3591: CURSOR cur_usec_gs_df(cp_uoo_id igs_ps_usec_grd_schm.uoo_id%TYPE) IS

3587: AND grd_schm_version_number = cp_grd_schm_version_number
3588: AND ROWNUM = 1;
3589: l_cur_usec_grdsch_new cur_usec_grdsch_new%ROWTYPE;
3590:
3591: CURSOR cur_usec_gs_df(cp_uoo_id igs_ps_usec_grd_schm.uoo_id%TYPE) IS
3592: SELECT grading_schema_code,grd_schm_version_number
3593: FROM igs_ps_usec_grd_schm
3594: WHERE uoo_id = cp_uoo_id
3595: AND default_flag = 'Y';

Line 3593: FROM igs_ps_usec_grd_schm

3589: l_cur_usec_grdsch_new cur_usec_grdsch_new%ROWTYPE;
3590:
3591: CURSOR cur_usec_gs_df(cp_uoo_id igs_ps_usec_grd_schm.uoo_id%TYPE) IS
3592: SELECT grading_schema_code,grd_schm_version_number
3593: FROM igs_ps_usec_grd_schm
3594: WHERE uoo_id = cp_uoo_id
3595: AND default_flag = 'Y';
3596: cur_usec_gs_df_rec cur_usec_gs_df%ROWTYPE;
3597:

Line 3619: igs_ps_usec_grd_schm_pkg.insert_row(

3615: CLOSE cur_usec_gs_df;
3616: OPEN cur_usec_grdsch_new(p_new_uoo_id,usec_grdsch_rec.grading_schema_code,usec_grdsch_rec.grd_schm_version_number );
3617: FETCH cur_usec_grdsch_new INTO l_cur_usec_grdsch_new;
3618: IF cur_usec_grdsch_new%NOTFOUND AND l_default_flag THEN
3619: igs_ps_usec_grd_schm_pkg.insert_row(
3620: x_rowid => lv_rowid,
3621: x_unit_section_grad_schema_id => l_usec_grdsch_id,
3622: x_uoo_id => p_new_uoo_id,
3623: x_grading_schema_code => usec_grdsch_rec.grading_schema_code ,