APPS.IGS_PS_CATALOG_ROLLOVER dependencies on IGS_PS_CATLG_VERS

Line 7: p_old_catalog_version IN IGS_PS_CATLG_VERS_ALL.CATALOG_VERSION%TYPE,

3:
4: PROCEDURE catalog_rollover (
5: errbuf OUT NOCOPY VARCHAR2,
6: retcode OUT NOCOPY NUMBER,
7: p_old_catalog_version IN IGS_PS_CATLG_VERS_ALL.CATALOG_VERSION%TYPE,
8: p_new_catalog_version IN IGS_PS_CATLG_VERS_ALL.CATALOG_VERSION%TYPE,
9: p_override_flag IN VARCHAR2,
10: p_debug_flag IN VARCHAR2,
11: p_org_id IN NUMBER ) AS

Line 8: p_new_catalog_version IN IGS_PS_CATLG_VERS_ALL.CATALOG_VERSION%TYPE,

4: PROCEDURE catalog_rollover (
5: errbuf OUT NOCOPY VARCHAR2,
6: retcode OUT NOCOPY NUMBER,
7: p_old_catalog_version IN IGS_PS_CATLG_VERS_ALL.CATALOG_VERSION%TYPE,
8: p_new_catalog_version IN IGS_PS_CATLG_VERS_ALL.CATALOG_VERSION%TYPE,
9: p_override_flag IN VARCHAR2,
10: p_debug_flag IN VARCHAR2,
11: p_org_id IN NUMBER ) AS
12: ------------------------------------------------------------------

Line 26: CURSOR cur_sel_catalog_vers(p_catalog_version IGS_PS_CATLG_VERS.CATALOG_VERSION%TYPE) IS

22: --Who When What
23: --smvk 06-Jan-2003 Bug # 2647185. Removed the hard coded strings
24: -- ('New Catalog Version','New Catalog Notes','Updated Catalog Notes')
25: -------------------------------------------------------------------
26: CURSOR cur_sel_catalog_vers(p_catalog_version IGS_PS_CATLG_VERS.CATALOG_VERSION%TYPE) IS
27: SELECT catalog_version_id,
28: catalog_version,
29: description,
30: closed_ind,

Line 37: FROM IGS_PS_CATLG_VERS

33: creation_date,
34: last_update_date,
35: last_update_login,
36: last_updated_by
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

Line 84: lv_new_catalog_version_id IGS_PS_CATLG_VERS.CATALOG_VERSION_ID%TYPE;

80: cur_sel_old_ctlg_notes cur_sel_old_catalog_notes%ROWTYPE;
81: cur_sel_new_ctlg_notes cur_sel_new_catalog_notes%ROWTYPE;
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

Line 85: lv_old_catalog_version_id IGS_PS_CATLG_VERS.CATALOG_VERSION_ID%TYPE;

81: cur_sel_new_ctlg_notes cur_sel_new_catalog_notes%ROWTYPE;
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);

Line 115: igs_ps_catlg_vers_pkg.insert_row(

111:
112: DECLARE
113: lv_rowid VARCHAR2(25);
114: BEGIN
115: igs_ps_catlg_vers_pkg.insert_row(
116: x_rowid => lv_rowid,
117: x_catalog_version_id => lv_new_catalog_version_id,
118: x_catalog_version => p_new_catalog_version,
119: x_description => cur_sel_ctlg_vers.description,