APPS.IGS_PS_VAL_AM dependencies on IGS_PS_CATLG_VERS

Line 63: p_old_sch_version IN IGS_PS_CATLG_VERS_ALL.CATALOG_VERSION%TYPE,

59:
60: PROCEDURE schedule_rollover (
61: errbuf OUT NOCOPY VARCHAR2,
62: retcode OUT NOCOPY NUMBER,
63: p_old_sch_version IN IGS_PS_CATLG_VERS_ALL.CATALOG_VERSION%TYPE,
64: p_new_sch_version IN IGS_PS_CATLG_VERS_ALL.CATALOG_VERSION%TYPE,
65: p_override_flag IN VARCHAR2,
66: p_debug_flag IN VARCHAR2,
67: p_org_id IN NUMBER ) AS

Line 64: p_new_sch_version IN IGS_PS_CATLG_VERS_ALL.CATALOG_VERSION%TYPE,

60: PROCEDURE schedule_rollover (
61: errbuf OUT NOCOPY VARCHAR2,
62: retcode OUT NOCOPY NUMBER,
63: p_old_sch_version IN IGS_PS_CATLG_VERS_ALL.CATALOG_VERSION%TYPE,
64: p_new_sch_version IN IGS_PS_CATLG_VERS_ALL.CATALOG_VERSION%TYPE,
65: p_override_flag IN VARCHAR2,
66: p_debug_flag IN VARCHAR2,
67: p_org_id IN NUMBER ) AS
68: /*------------------------------------------------------------------

Line 76: CURSOR cur_sel_sch_vers(p_sch_version IGS_PS_CATLG_VERS.CATALOG_VERSION%TYPE) IS

72: sommukhe 17-APR-2006 Bug#4111831, included logging for parameters, raising error with valid message when old and
73: new schedule versions are same,removed note id,note type id, schedule idfrom log as they are
74: not relevant to user.
75: -------------------------------------------------------------------*/
76: CURSOR cur_sel_sch_vers(p_sch_version IGS_PS_CATLG_VERS.CATALOG_VERSION%TYPE) IS
77: SELECT catalog_version_id,
78: catalog_version,
79: description,
80: closed_ind,

Line 87: FROM IGS_PS_CATLG_VERS

83: creation_date,
84: last_update_date,
85: last_update_login,
86: last_updated_by
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

Line 135: lv_new_sch_version_id IGS_PS_CATLG_VERS.CATALOG_VERSION_ID%TYPE;

131: v_sel_old_sch_notes cur_sel_old_sch_notes%ROWTYPE;
132: v_sel_new_sch_notes cur_sel_new_sch_notes%ROWTYPE;
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;

Line 136: lv_old_sch_version_id IGS_PS_CATLG_VERS.CATALOG_VERSION_ID%TYPE;

132: v_sel_new_sch_notes cur_sel_new_sch_notes%ROWTYPE;
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:

Line 182: igs_ps_catlg_vers_pkg.insert_row(

178: ELSE
179: DECLARE
180: lv_rowid VARCHAR2(25);
181: BEGIN
182: igs_ps_catlg_vers_pkg.insert_row(
183: x_rowid => lv_rowid,
184: x_catalog_version_id => lv_new_sch_version_id,
185: x_catalog_version => p_new_sch_version,
186: x_description => v_sel_sch_vers.description,