APPS.IGS_PS_GEN_001 dependencies on IGS_PS_UNT_OFR_OPT_N

Line 2277: FROM igs_ps_unt_ofr_opt_n snote, igs_ge_note genote

2273:
2274: -- 18
2275: CURSOR c_unt_ofr_opt_n (cp_uoo_id NUMBER) IS
2276: SELECT snote.*, genote.s_note_format_type, genote.note_text
2277: FROM igs_ps_unt_ofr_opt_n snote, igs_ge_note genote
2278: WHERE uoo_id = cp_uoo_id
2279: AND snote.reference_number = geNote.reference_number;
2280:
2281: -- 19

Line 3646: CURSOR cur_c_unt_ofr_opt_n_new (cp_uoo_id igs_ps_unt_ofr_opt_n.uoo_id%TYPE,

3642: -- Enhancement bug no 1800179 , pmarada
3643: -- Rollover of unit section note records
3644: FOR c_unt_ofr_opt_n_rec IN c_unt_ofr_opt_n( p_old_uoo_id ) LOOP
3645: DECLARE
3646: CURSOR cur_c_unt_ofr_opt_n_new (cp_uoo_id igs_ps_unt_ofr_opt_n.uoo_id%TYPE,
3647: cp_crs_note_type igs_ps_unt_ofr_opt_n.crs_note_type%TYPE) IS
3648: SELECT 'X'
3649: FROM igs_ps_unt_ofr_opt_n
3650: WHERE uoo_id = cp_uoo_id

Line 3647: cp_crs_note_type igs_ps_unt_ofr_opt_n.crs_note_type%TYPE) IS

3643: -- Rollover of unit section note records
3644: FOR c_unt_ofr_opt_n_rec IN c_unt_ofr_opt_n( p_old_uoo_id ) LOOP
3645: DECLARE
3646: CURSOR cur_c_unt_ofr_opt_n_new (cp_uoo_id igs_ps_unt_ofr_opt_n.uoo_id%TYPE,
3647: cp_crs_note_type igs_ps_unt_ofr_opt_n.crs_note_type%TYPE) IS
3648: SELECT 'X'
3649: FROM igs_ps_unt_ofr_opt_n
3650: WHERE uoo_id = cp_uoo_id
3651: AND crs_note_type = cp_crs_note_type

Line 3649: FROM igs_ps_unt_ofr_opt_n

3645: DECLARE
3646: CURSOR cur_c_unt_ofr_opt_n_new (cp_uoo_id igs_ps_unt_ofr_opt_n.uoo_id%TYPE,
3647: cp_crs_note_type igs_ps_unt_ofr_opt_n.crs_note_type%TYPE) IS
3648: SELECT 'X'
3649: FROM igs_ps_unt_ofr_opt_n
3650: WHERE uoo_id = cp_uoo_id
3651: AND crs_note_type = cp_crs_note_type
3652: AND ROWNUM = 1;
3653: l_cur_c_unt_ofr_opt_n_new cur_c_unt_ofr_opt_n_new%ROWTYPE;

Line 3675: igs_ps_unt_ofr_opt_n_pkg.insert_row(

3671: x_s_note_format_type => c_unt_ofr_opt_n_rec.s_note_format_type,
3672: x_note_text => c_unt_ofr_opt_n_rec.Note_text,
3673: x_mode => 'R' );
3674:
3675: igs_ps_unt_ofr_opt_n_pkg.insert_row(
3676: x_rowid => lv_usrowid,
3677: x_unit_cd => gv_new_usec_rec.unit_cd,
3678: x_version_number => gv_new_usec_rec.version_number,
3679: x_ci_sequence_number => gv_new_usec_rec.ci_sequence_number,