APPS.IGS_PS_EXP_WL_PKG dependencies on IGS_PS_EXP_WL

Line 1: PACKAGE BODY igs_ps_exp_wl_pkg AS

1: PACKAGE BODY igs_ps_exp_wl_pkg AS
2: /* $Header: IGSPI3DB.pls 115.4 2003/07/24 13:33:40 shtatiko noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_exp_wl%ROWTYPE;

Line 5: old_references igs_ps_exp_wl%ROWTYPE;

1: PACKAGE BODY igs_ps_exp_wl_pkg AS
2: /* $Header: IGSPI3DB.pls 115.4 2003/07/24 13:33:40 shtatiko noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_exp_wl%ROWTYPE;
6: new_references igs_ps_exp_wl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_exp_wl%ROWTYPE;

2: /* $Header: IGSPI3DB.pls 115.4 2003/07/24 13:33:40 shtatiko noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_exp_wl%ROWTYPE;
6: new_references igs_ps_exp_wl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 31: FROM igs_ps_exp_wl

27: */
28:
29: CURSOR cur_old_ref_values IS
30: SELECT *
31: FROM igs_ps_exp_wl
32: WHERE rowid = x_rowid;
33:
34: BEGIN
35:

Line 82: FROM igs_ps_exp_wl

78: || (reverse chronological order - newest change first)
79: */
80: CURSOR cur_rowid IS
81: SELECT rowid
82: FROM igs_ps_exp_wl
83: WHERE calendar_cat = x_calendar_cat
84: FOR UPDATE NOWAIT;
85:
86: lv_rowid cur_rowid%RowType;

Line 108: FROM igs_ps_exp_wl ;

104: PROCEDURE BeforeRowInsert AS
105: l_count_recs NUMBER(2);
106: CURSOR c_num_of_recs IS
107: SELECT count(*)
108: FROM igs_ps_exp_wl ;
109:
110: BEGIN
111: OPEN c_num_of_recs ;
112: FETCH c_num_of_recs INTO l_count_recs ;

Line 200: FROM igs_ps_exp_wl

196: || shtatiko 24-JUL-2003 Bug# 2986863, Removed references to obsoleted column, control_num
197: */
198: CURSOR c IS
199: SELECT rowid
200: FROM igs_ps_exp_wl
201: WHERE calendar_cat = x_calendar_cat;
202:
203: x_last_update_date DATE;
204: x_last_updated_by NUMBER;

Line 239: INSERT INTO igs_ps_exp_wl (

235: x_last_updated_by => x_last_updated_by,
236: x_last_update_login => x_last_update_login
237: );
238:
239: INSERT INTO igs_ps_exp_wl (
240: calendar_cat,
241: creation_date,
242: created_by,
243: last_update_date,

Line 283: FROM igs_ps_exp_wl

279: */
280: CURSOR c1 IS
281: SELECT
282: calendar_cat
283: FROM igs_ps_exp_wl
284: WHERE rowid = x_rowid
285: FOR UPDATE NOWAIT;
286:
287: tlinfo c1%ROWTYPE;

Line 368: UPDATE igs_ps_exp_wl

364: x_last_updated_by => x_last_updated_by,
365: x_last_update_login => x_last_update_login
366: );
367:
368: UPDATE igs_ps_exp_wl
369: SET
370: calendar_cat = new_references.calendar_cat,
371: last_update_date = x_last_update_date,
372: last_updated_by = x_last_updated_by,

Line 400: FROM igs_ps_exp_wl

396: || shtatiko 24-JUL-2003 Bug# 2986863, Removed references to obsoleted column, control_num
397: */
398: CURSOR c1 IS
399: SELECT rowid
400: FROM igs_ps_exp_wl
401: WHERE calendar_cat = x_calendar_cat;
402:
403: BEGIN
404:

Line 447: DELETE FROM igs_ps_exp_wl

443: p_action => 'DELETE',
444: x_rowid => x_rowid
445: );
446:
447: DELETE FROM igs_ps_exp_wl
448: WHERE rowid = x_rowid;
449:
450: IF (SQL%NOTFOUND) THEN
451: RAISE NO_DATA_FOUND;

Line 457: END igs_ps_exp_wl_pkg;

453:
454: END delete_row;
455:
456:
457: END igs_ps_exp_wl_pkg;