APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_UNT_OFR_OPT_N

Line 5414: CURSOR cur_ref_num(cp_uoo_id igs_ps_unt_ofr_opt_n.uoo_id%TYPE,

5410: END validate_derivations;
5411:
5412: -- Validate Database Constraints
5413: PROCEDURE validate_db_cons ( p_usec_notes_rec IN OUT NOCOPY igs_ps_generic_pub.usec_notes_rec_type,p_insert_update VARCHAR2 ) AS
5414: CURSOR cur_ref_num(cp_uoo_id igs_ps_unt_ofr_opt_n.uoo_id%TYPE,
5415: cp_reference_number igs_ps_unt_ofr_opt_n.reference_number%TYPE) IS
5416: SELECT b.note_text
5417: FROM igs_ps_unt_ofr_opt_n a,igs_ge_note b
5418: WHERE a.uoo_id=cp_uoo_id

Line 5415: cp_reference_number igs_ps_unt_ofr_opt_n.reference_number%TYPE) IS

5411:
5412: -- Validate Database Constraints
5413: PROCEDURE validate_db_cons ( p_usec_notes_rec IN OUT NOCOPY igs_ps_generic_pub.usec_notes_rec_type,p_insert_update VARCHAR2 ) AS
5414: CURSOR cur_ref_num(cp_uoo_id igs_ps_unt_ofr_opt_n.uoo_id%TYPE,
5415: cp_reference_number igs_ps_unt_ofr_opt_n.reference_number%TYPE) IS
5416: SELECT b.note_text
5417: FROM igs_ps_unt_ofr_opt_n a,igs_ge_note b
5418: WHERE a.uoo_id=cp_uoo_id
5419: AND a.reference_number=cp_reference_number

Line 5417: FROM igs_ps_unt_ofr_opt_n a,igs_ge_note b

5413: PROCEDURE validate_db_cons ( p_usec_notes_rec IN OUT NOCOPY igs_ps_generic_pub.usec_notes_rec_type,p_insert_update VARCHAR2 ) AS
5414: CURSOR cur_ref_num(cp_uoo_id igs_ps_unt_ofr_opt_n.uoo_id%TYPE,
5415: cp_reference_number igs_ps_unt_ofr_opt_n.reference_number%TYPE) IS
5416: SELECT b.note_text
5417: FROM igs_ps_unt_ofr_opt_n a,igs_ge_note b
5418: WHERE a.uoo_id=cp_uoo_id
5419: AND a.reference_number=cp_reference_number
5420: AND a.reference_number=b.reference_number;
5421: l_cur_ref_num cur_ref_num%ROWTYPE;

Line 5584: INSERT INTO igs_ps_unt_ofr_opt_n

5580: SYSDATE,
5581: g_n_login_id
5582: )RETURNING reference_number INTO l_n_reference_number;
5583:
5584: INSERT INTO igs_ps_unt_ofr_opt_n
5585: (unit_cd,
5586: version_number,
5587: cal_type,
5588: ci_sequence_number,

Line 5626: UPDATE igs_ps_unt_ofr_opt_n

5622: END IF;
5623:
5624: ELSE
5625: /*Update record*/
5626: UPDATE igs_ps_unt_ofr_opt_n
5627: SET crs_note_type = p_usec_notes_tbl(I).crs_note_type,
5628: last_updated_by = g_n_user_id,
5629: last_update_date = SYSDATE,
5630: last_update_login = g_n_login_id