APPS.IGS_PS_VAL_AM dependencies on IGS_PS_CATLG_NOTES

Line 91: CURSOR cur_sel_old_sch_notes(p_sch_version_id IGS_PS_CATLG_NOTES.CATALOG_VERSION_ID%TYPE) IS

87: FROM IGS_PS_CATLG_VERS
88: WHERE catalog_version = p_sch_version
89: AND catalog_schedule = 'SCHEDULE';
90:
91: CURSOR cur_sel_old_sch_notes(p_sch_version_id IGS_PS_CATLG_NOTES.CATALOG_VERSION_ID%TYPE) IS
92: SELECT catalog_note_id,
93: catalog_version_id,
94: note_type_id,
95: create_date,

Line 104: FROM IGS_PS_CATLG_NOTES

100: creation_date,
101: last_update_date,
102: last_update_login,
103: last_updated_by
104: FROM IGS_PS_CATLG_NOTES
105: WHERE catalog_version_id = p_sch_version_id;
106:
107: CURSOR cur_sel_new_sch_notes(p_sch_version_id IGS_PS_CATLG_NOTES.CATALOG_VERSION_ID%TYPE,
108: p_note_type_id IGS_PS_CATLG_NOTES.NOTE_TYPE_ID%TYPE,

Line 107: CURSOR cur_sel_new_sch_notes(p_sch_version_id IGS_PS_CATLG_NOTES.CATALOG_VERSION_ID%TYPE,

103: last_updated_by
104: FROM IGS_PS_CATLG_NOTES
105: WHERE catalog_version_id = p_sch_version_id;
106:
107: CURSOR cur_sel_new_sch_notes(p_sch_version_id IGS_PS_CATLG_NOTES.CATALOG_VERSION_ID%TYPE,
108: p_note_type_id IGS_PS_CATLG_NOTES.NOTE_TYPE_ID%TYPE,
109: p_sequence IGS_PS_CATLG_NOTES.SEQUENCE%TYPE) IS
110: SELECT ROWID,
111: catalog_note_id,

Line 108: p_note_type_id IGS_PS_CATLG_NOTES.NOTE_TYPE_ID%TYPE,

104: FROM IGS_PS_CATLG_NOTES
105: WHERE catalog_version_id = p_sch_version_id;
106:
107: CURSOR cur_sel_new_sch_notes(p_sch_version_id IGS_PS_CATLG_NOTES.CATALOG_VERSION_ID%TYPE,
108: p_note_type_id IGS_PS_CATLG_NOTES.NOTE_TYPE_ID%TYPE,
109: p_sequence IGS_PS_CATLG_NOTES.SEQUENCE%TYPE) IS
110: SELECT ROWID,
111: catalog_note_id,
112: catalog_version_id,

Line 109: p_sequence IGS_PS_CATLG_NOTES.SEQUENCE%TYPE) IS

105: WHERE catalog_version_id = p_sch_version_id;
106:
107: CURSOR cur_sel_new_sch_notes(p_sch_version_id IGS_PS_CATLG_NOTES.CATALOG_VERSION_ID%TYPE,
108: p_note_type_id IGS_PS_CATLG_NOTES.NOTE_TYPE_ID%TYPE,
109: p_sequence IGS_PS_CATLG_NOTES.SEQUENCE%TYPE) IS
110: SELECT ROWID,
111: catalog_note_id,
112: catalog_version_id,
113: note_type_id,

Line 123: FROM IGS_PS_CATLG_NOTES

119: creation_date,
120: last_update_date,
121: last_update_login,
122: last_updated_by
123: FROM IGS_PS_CATLG_NOTES
124: WHERE catalog_version_id = p_sch_version_id
125: AND note_type_id = p_note_type_id
126: AND SEQUENCE = p_sequence
127: FOR UPDATE NOWAIT;

Line 137: lv_sch_note_id IGS_PS_CATLG_NOTES.CATALOG_NOTE_ID%TYPE;

133:
134:
135: lv_new_sch_version_id IGS_PS_CATLG_VERS.CATALOG_VERSION_ID%TYPE;
136: lv_old_sch_version_id IGS_PS_CATLG_VERS.CATALOG_VERSION_ID%TYPE;
137: lv_sch_note_id IGS_PS_CATLG_NOTES.CATALOG_NOTE_ID%TYPE;
138:
139: INVALID EXCEPTION;
140:
141: BEGIN

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,