APPS.IGS_TR_STEP_CTLG_PKG dependencies on IGS_TR_STEP_CTLG_ALL

Line 5: old_references igs_tr_step_ctlg_all%ROWTYPE;

1: PACKAGE BODY igs_tr_step_ctlg_pkg AS
2: /* $Header: IGSTI13B.pls 115.8 2003/06/26 06:53:14 vrathi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_step_ctlg_all%ROWTYPE;
6: new_references igs_tr_step_ctlg_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_tr_step_ctlg_all%ROWTYPE;

2: /* $Header: IGSTI13B.pls 115.8 2003/06/26 06:53:14 vrathi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_step_ctlg_all%ROWTYPE;
6: new_references igs_tr_step_ctlg_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 36: FROM IGS_TR_STEP_CTLG_ALL

32: */
33:
34: CURSOR cur_old_ref_values IS
35: SELECT *
36: FROM IGS_TR_STEP_CTLG_ALL
37: WHERE rowid = x_rowid;
38:
39: BEGIN
40:

Line 143: FROM igs_tr_step_ctlg_all

139: || (reverse chronological order - newest change first)
140: */
141: CURSOR cur_rowid IS
142: SELECT rowid
143: FROM igs_tr_step_ctlg_all
144: WHERE step_catalog_id = x_step_catalog_id;
145:
146: lv_rowid cur_rowid%RowType;
147:

Line 177: FROM igs_tr_step_ctlg_all

173: || (reverse chronological order - newest change first)
174: */
175: CURSOR cur_rowid IS
176: SELECT rowid
177: FROM igs_tr_step_ctlg_all
178: WHERE step_catalog_cd = x_step_catalog_cd
179: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
180:
181: lv_rowid cur_rowid%RowType;

Line 303: FROM igs_tr_step_ctlg_all

299: || (reverse chronological order - newest change first)
300: */
301: CURSOR c IS
302: SELECT rowid
303: FROM igs_tr_step_ctlg_all
304: WHERE step_catalog_id = x_step_catalog_id;
305:
306: x_last_update_date DATE;
307: x_last_updated_by NUMBER;

Line 331: SELECT igs_tr_step_ctlg_all_s.NEXTVAL

327: igs_ge_msg_stack.add;
328: app_exception.raise_exception;
329: END IF;
330:
331: SELECT igs_tr_step_ctlg_all_s.NEXTVAL
332: INTO x_step_catalog_id
333: FROM dual;
334:
335: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 354: INSERT INTO igs_tr_step_ctlg_all (

350: x_last_updated_by => x_last_updated_by,
351: x_last_update_login => x_last_update_login
352: );
353:
354: INSERT INTO igs_tr_step_ctlg_all (
355: step_catalog_id,
356: step_catalog_cd,
357: description,
358: action_days,

Line 422: FROM igs_tr_step_ctlg_all

418: action_days,
419: s_tracking_step_type,
420: publish_ind,
421: closed_ind
422: FROM igs_tr_step_ctlg_all
423: WHERE rowid = x_rowid
424: FOR UPDATE NOWAIT;
425:
426: tlinfo c1%ROWTYPE;

Line 523: UPDATE igs_tr_step_ctlg_all

519: x_last_updated_by => x_last_updated_by,
520: x_last_update_login => x_last_update_login
521: );
522:
523: UPDATE igs_tr_step_ctlg_all
524: SET
525: step_catalog_cd = new_references.step_catalog_cd,
526: description = new_references.description,
527: action_days = new_references.action_days,

Line 565: FROM igs_tr_step_ctlg_all

561: || (reverse chronological order - newest change first)
562: */
563: CURSOR c1 IS
564: SELECT rowid
565: FROM igs_tr_step_ctlg_all
566: WHERE step_catalog_id = x_step_catalog_id;
567:
568: BEGIN
569: