APPS.IGS_PS_UNIT_TYPE_LVL_PKG dependencies on IGS_PS_UNIT_TYPE_LVL

Line 1: PACKAGE BODY igs_ps_unit_type_lvl_pkg AS

1: PACKAGE BODY igs_ps_unit_type_lvl_pkg AS
2: /* $Header: IGSPI1YB.pls 120.1 2005/08/10 01:16:13 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_unit_type_lvl%ROWTYPE;

Line 5: old_references igs_ps_unit_type_lvl%ROWTYPE;

1: PACKAGE BODY igs_ps_unit_type_lvl_pkg AS
2: /* $Header: IGSPI1YB.pls 120.1 2005/08/10 01:16:13 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_unit_type_lvl%ROWTYPE;
6: new_references igs_ps_unit_type_lvl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_unit_type_lvl%ROWTYPE;

2: /* $Header: IGSPI1YB.pls 120.1 2005/08/10 01:16:13 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_unit_type_lvl%ROWTYPE;
6: new_references igs_ps_unit_type_lvl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 33: FROM IGS_PS_UNIT_TYPE_LVL

29: */
30:
31: CURSOR cur_old_ref_values IS
32: SELECT *
33: FROM IGS_PS_UNIT_TYPE_LVL
34: WHERE rowid = x_rowid;
35:
36: BEGIN
37:

Line 113: FROM igs_ps_unit_type_lvl

109: || (reverse chronological order - newest change first)
110: */
111: CURSOR cur_rowid IS
112: SELECT rowid
113: FROM igs_ps_unit_type_lvl
114: WHERE unit_type_id = x_unit_type_id ;
115:
116: lv_rowid cur_rowid%RowType;
117:

Line 147: FROM igs_ps_unit_type_lvl

143: || (reverse chronological order - newest change first)
144: */
145: CURSOR cur_rowid IS
146: SELECT rowid
147: FROM igs_ps_unit_type_lvl
148: WHERE level_code = x_level_code
149: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
150:
151: lv_rowid cur_rowid%RowType;

Line 260: FROM igs_ps_unit_type_lvl

256: || (reverse chronological order - newest change first)
257: */
258: CURSOR c IS
259: SELECT rowid
260: FROM igs_ps_unit_type_lvl
261: WHERE unit_type_id = x_unit_type_id;
262:
263: x_last_update_date DATE;
264: x_last_updated_by NUMBER;

Line 288: SELECT igs_ps_unit_type_lvl_s.NEXTVAL

284: igs_ge_msg_stack.add;
285: app_exception.raise_exception;
286: END IF;
287:
288: SELECT igs_ps_unit_type_lvl_s.NEXTVAL
289: INTO x_unit_type_id
290: FROM dual;
291:
292: before_dml(

Line 306: INSERT INTO igs_ps_unit_type_lvl (

302: x_last_updated_by => x_last_updated_by,
303: x_last_update_login => x_last_update_login
304: );
305:
306: INSERT INTO igs_ps_unit_type_lvl (
307: unit_type_id,
308: level_code,
309: description,
310: closed_ind,

Line 360: FROM igs_ps_unit_type_lvl

356: SELECT
357: level_code,
358: description,
359: closed_ind
360: FROM igs_ps_unit_type_lvl
361: WHERE rowid = x_rowid
362: FOR UPDATE NOWAIT;
363:
364: tlinfo c1%ROWTYPE;

Line 452: UPDATE igs_ps_unit_type_lvl

448: x_last_updated_by => x_last_updated_by,
449: x_last_update_login => x_last_update_login
450: );
451:
452: UPDATE igs_ps_unit_type_lvl
453: SET
454: level_code = new_references.level_code,
455: description = new_references.description,
456: closed_ind = new_references.closed_ind,

Line 488: FROM igs_ps_unit_type_lvl

484: || (reverse chronological order - newest change first)
485: */
486: CURSOR c1 IS
487: SELECT rowid
488: FROM igs_ps_unit_type_lvl
489: WHERE unit_type_id = x_unit_type_id;
490:
491: BEGIN
492:

Line 522: END igs_ps_unit_type_lvl_pkg;

518:
519: END add_row;
520:
521:
522: END igs_ps_unit_type_lvl_pkg;