DBA Data[Home] [Help]

APPS.IGS_PS_VAL_AM dependencies on IGS_PS_CATLG_NOTES_PKG

Line 217: igs_ps_catlg_notes_pkg.insert_row(

213: IF cur_sel_new_sch_notes%NOTFOUND THEN
214: DECLARE
215: lv_rowid VARCHAR2(25);
216: BEGIN
217: igs_ps_catlg_notes_pkg.insert_row(
218: x_rowid => lv_rowid,
219: x_catalog_note_id => lv_sch_note_id,
220: x_catalog_version_id => lv_new_sch_version_id,
221: x_note_type_id => v_sel_old_sch_notes.note_type_id,

Line 237: igs_ps_catlg_notes_pkg.update_row(

233: v_sel_old_sch_notes.note_text);
234: END IF;
235: ELSE
236: IF p_override_flag = 'Y' THEN
237: igs_ps_catlg_notes_pkg.update_row(
238: x_rowid => v_sel_new_sch_notes.ROWID,
239: x_catalog_note_id => v_sel_new_sch_notes.catalog_note_id,
240: x_catalog_version_id => v_sel_new_sch_notes.catalog_version_id,
241: x_note_type_id => v_sel_new_sch_notes.note_type_id,