APPS.IGS_PS_CATALOG_ROLLOVER dependencies on IGS_PS_CATLG_NOTES

Line 41: CURSOR cur_sel_old_catalog_notes(p_catalog_version_id IGS_PS_CATLG_NOTES.CATALOG_VERSION_ID%TYPE) IS

37: FROM IGS_PS_CATLG_VERS
38: WHERE catalog_version = p_catalog_version
39: AND catalog_schedule = 'CATALOG';
40:
41: CURSOR cur_sel_old_catalog_notes(p_catalog_version_id IGS_PS_CATLG_NOTES.CATALOG_VERSION_ID%TYPE) IS
42: SELECT catalog_note_id,
43: catalog_version_id,
44: note_type_id,
45: create_date,

Line 54: FROM IGS_PS_CATLG_NOTES

50: creation_date,
51: last_update_date,
52: last_update_login,
53: last_updated_by
54: FROM IGS_PS_CATLG_NOTES
55: WHERE catalog_version_id = p_catalog_version_id;
56:
57: CURSOR cur_sel_new_catalog_notes(p_catalog_version_id IGS_PS_CATLG_NOTES.CATALOG_VERSION_ID%TYPE,
58: p_note_type_id IGS_PS_CATLG_NOTES.NOTE_TYPE_ID%TYPE,

Line 57: CURSOR cur_sel_new_catalog_notes(p_catalog_version_id IGS_PS_CATLG_NOTES.CATALOG_VERSION_ID%TYPE,

53: last_updated_by
54: FROM IGS_PS_CATLG_NOTES
55: WHERE catalog_version_id = p_catalog_version_id;
56:
57: CURSOR cur_sel_new_catalog_notes(p_catalog_version_id IGS_PS_CATLG_NOTES.CATALOG_VERSION_ID%TYPE,
58: p_note_type_id IGS_PS_CATLG_NOTES.NOTE_TYPE_ID%TYPE,
59: p_sequence IGS_PS_CATLG_NOTES.SEQUENCE%TYPE ) IS
60: SELECT ROWID, -- included
61: catalog_note_id,

Line 58: p_note_type_id IGS_PS_CATLG_NOTES.NOTE_TYPE_ID%TYPE,

54: FROM IGS_PS_CATLG_NOTES
55: WHERE catalog_version_id = p_catalog_version_id;
56:
57: CURSOR cur_sel_new_catalog_notes(p_catalog_version_id IGS_PS_CATLG_NOTES.CATALOG_VERSION_ID%TYPE,
58: p_note_type_id IGS_PS_CATLG_NOTES.NOTE_TYPE_ID%TYPE,
59: p_sequence IGS_PS_CATLG_NOTES.SEQUENCE%TYPE ) IS
60: SELECT ROWID, -- included
61: catalog_note_id,
62: catalog_version_id,

Line 59: p_sequence IGS_PS_CATLG_NOTES.SEQUENCE%TYPE ) IS

55: WHERE catalog_version_id = p_catalog_version_id;
56:
57: CURSOR cur_sel_new_catalog_notes(p_catalog_version_id IGS_PS_CATLG_NOTES.CATALOG_VERSION_ID%TYPE,
58: p_note_type_id IGS_PS_CATLG_NOTES.NOTE_TYPE_ID%TYPE,
59: p_sequence IGS_PS_CATLG_NOTES.SEQUENCE%TYPE ) IS
60: SELECT ROWID, -- included
61: catalog_note_id,
62: catalog_version_id,
63: note_type_id,

Line 73: FROM IGS_PS_CATLG_NOTES

69: creation_date,
70: last_update_date,
71: last_update_login,
72: last_updated_by
73: FROM IGS_PS_CATLG_NOTES
74: WHERE catalog_version_id = p_catalog_version_id
75: AND note_type_id = p_note_type_id
76: AND SEQUENCE = p_sequence
77: FOR UPDATE NOWAIT;

Line 86: lv_catalog_note_id IGS_PS_CATLG_NOTES.CATALOG_NOTE_ID%TYPE;

82:
83:
84: lv_new_catalog_version_id IGS_PS_CATLG_VERS.CATALOG_VERSION_ID%TYPE;
85: lv_old_catalog_version_id IGS_PS_CATLG_VERS.CATALOG_VERSION_ID%TYPE;
86: lv_catalog_note_id IGS_PS_CATLG_NOTES.CATALOG_NOTE_ID%TYPE;
87:
88: BEGIN
89: igs_ge_gen_003.set_org_id(p_org_id);
90: retcode:=0;

Line 160: igs_ps_catlg_notes_pkg.insert_row(

156:
157: DECLARE
158: lv_rowid VARCHAR2(25);
159: BEGIN
160: igs_ps_catlg_notes_pkg.insert_row(
161: x_rowid => lv_rowid,
162: x_catalog_note_id => lv_catalog_note_id,
163: x_catalog_version_id => lv_new_catalog_version_id,
164: x_note_type_id => cur_sel_old_ctlg_notes.note_type_id,

Line 184: igs_ps_catlg_notes_pkg.update_row(

180: ELSE
181:
182: IF p_override_flag = 'Y' THEN -- was 'YES'
183:
184: igs_ps_catlg_notes_pkg.update_row(
185: x_rowid => cur_sel_new_ctlg_notes.ROWID,
186: x_catalog_note_id => cur_sel_new_ctlg_notes.catalog_note_id,
187: x_catalog_version_id => cur_sel_new_ctlg_notes.catalog_version_id,
188: x_note_type_id => cur_sel_new_ctlg_notes.note_type_id,