APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_GE_NOTE

Line 5310: l_n_reference_number igs_ge_note.reference_number%TYPE;

5306: Who When What
5307: ********************************************************************************************** */
5308: l_insert_update VARCHAR2(1);
5309: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
5310: l_n_reference_number igs_ge_note.reference_number%TYPE;
5311: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
5312: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
5313:
5314: /* Private Procedures for create_usec_notes */

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 5563: INSERT INTO IGS_GE_NOTE

5559:
5560: IF p_usec_notes_tbl(I).status = 'S' THEN
5561: IF l_insert_update = 'I' THEN
5562: /* Insert Record */
5563: INSERT INTO IGS_GE_NOTE
5564: (reference_number,
5565: s_note_format_type,
5566: note_text,
5567: created_by,

Line 5574: (IGS_GE_NOTE_RF_NUM_S.nextval,

5570: last_update_date,
5571: last_update_login
5572: )
5573: VALUES
5574: (IGS_GE_NOTE_RF_NUM_S.nextval,
5575: 'TEXT',
5576: p_usec_notes_tbl(I).note_text,
5577: g_n_user_id,
5578: SYSDATE,

Line 5633: UPDATE igs_ge_note

5629: last_update_date = SYSDATE,
5630: last_update_login = g_n_login_id
5631: WHERE reference_number = p_usec_notes_tbl(I).reference_number;
5632:
5633: UPDATE igs_ge_note
5634: SET note_text = p_usec_notes_tbl(I).note_text,
5635: last_updated_by = g_n_user_id,
5636: last_update_date = SYSDATE,
5637: last_update_login = g_n_login_id