APPS.IGS_PS_USEC_CATEGORY_PKG dependencies on IGS_PS_USEC_CATEGORY

Line 1: PACKAGE BODY igs_ps_usec_category_pkg AS

1: PACKAGE BODY igs_ps_usec_category_pkg AS
2: /* $Header: IGSPI2AB.pls 115.5 2003/03/21 08:01:37 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_usec_category%ROWTYPE;

Line 5: old_references igs_ps_usec_category%ROWTYPE;

1: PACKAGE BODY igs_ps_usec_category_pkg AS
2: /* $Header: IGSPI2AB.pls 115.5 2003/03/21 08:01:37 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_usec_category%ROWTYPE;
6: new_references igs_ps_usec_category%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_usec_category%ROWTYPE;

2: /* $Header: IGSPI2AB.pls 115.5 2003/03/21 08:01:37 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_usec_category%ROWTYPE;
6: new_references igs_ps_usec_category%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 32: FROM IGS_PS_USEC_CATEGORY

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

Line 148: FROM igs_ps_usec_category

144: || (reverse chronological order - newest change first)
145: */
146: CURSOR cur_rowid IS
147: SELECT rowid
148: FROM igs_ps_usec_category
149: WHERE usec_cat_id = x_usec_cat_id
150: FOR UPDATE NOWAIT;
151:
152: lv_rowid cur_rowid%RowType;

Line 184: FROM igs_ps_usec_category

180: || (reverse chronological order - newest change first)
181: */
182: CURSOR cur_rowid IS
183: SELECT rowid
184: FROM igs_ps_usec_category
185: WHERE uoo_id = x_uoo_id
186: AND unit_cat = x_unit_cat
187: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
188:

Line 220: FROM igs_ps_usec_category

216: || (reverse chronological order - newest change first)
217: */
218: CURSOR cur_rowid IS
219: SELECT rowid
220: FROM igs_ps_usec_category
221: WHERE ((uoo_id = x_uoo_id));
222:
223: lv_rowid cur_rowid%RowType;
224:

Line 255: FROM igs_ps_usec_category

251: || (reverse chronological order - newest change first)
252: */
253: CURSOR cur_rowid IS
254: SELECT rowid
255: FROM igs_ps_usec_category
256: WHERE ((unit_cat = x_unit_cat));
257:
258: lv_rowid cur_rowid%RowType;
259:

Line 367: FROM igs_ps_usec_category

363: || (reverse chronological order - newest change first)
364: */
365: CURSOR c IS
366: SELECT rowid
367: FROM igs_ps_usec_category
368: WHERE usec_cat_id = x_usec_cat_id;
369:
370: x_last_update_date DATE;
371: x_last_updated_by NUMBER;

Line 395: SELECT igs_ps_usec_category_s.NEXTVAL

391: igs_ge_msg_stack.add;
392: app_exception.raise_exception;
393: END IF;
394:
395: SELECT igs_ps_usec_category_s.NEXTVAL
396: INTO x_usec_cat_id
397: FROM dual;
398:
399: before_dml(

Line 412: INSERT INTO igs_ps_usec_category (

408: x_last_updated_by => x_last_updated_by,
409: x_last_update_login => x_last_update_login
410: );
411:
412: INSERT INTO igs_ps_usec_category (
413: usec_cat_id,
414: uoo_id,
415: unit_cat,
416: creation_date,

Line 462: FROM igs_ps_usec_category

458: CURSOR c1 IS
459: SELECT
460: uoo_id,
461: unit_cat
462: FROM igs_ps_usec_category
463: WHERE rowid = x_rowid
464: FOR UPDATE NOWAIT;
465:
466: tlinfo c1%ROWTYPE;

Line 551: UPDATE igs_ps_usec_category

547: x_last_updated_by => x_last_updated_by,
548: x_last_update_login => x_last_update_login
549: );
550:
551: UPDATE igs_ps_usec_category
552: SET
553: uoo_id = new_references.uoo_id,
554: unit_cat = new_references.unit_cat,
555: last_update_date = x_last_update_date,

Line 585: FROM igs_ps_usec_category

581: || (reverse chronological order - newest change first)
582: */
583: CURSOR c1 IS
584: SELECT rowid
585: FROM igs_ps_usec_category
586: WHERE usec_cat_id = x_usec_cat_id;
587:
588: BEGIN
589:

Line 636: DELETE FROM igs_ps_usec_category

632: p_action => 'DELETE',
633: x_rowid => x_rowid
634: );
635:
636: DELETE FROM igs_ps_usec_category
637: WHERE rowid = x_rowid;
638:
639: IF (SQL%NOTFOUND) THEN
640: RAISE NO_DATA_FOUND;

Line 646: END igs_ps_usec_category_pkg;

642:
643: END delete_row;
644:
645:
646: END igs_ps_usec_category_pkg;