APPS.IGS_CO_CAT_PKG dependencies on IGS_CO_CAT

Line 1: PACKAGE BODY igs_co_cat_pkg AS

1: PACKAGE BODY igs_co_cat_pkg AS
2: /* $Header: IGSLI02B.pls 115.5 2002/11/29 01:02:31 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_cat%ROWTYPE;

Line 5: old_references igs_co_cat%ROWTYPE;

1: PACKAGE BODY igs_co_cat_pkg AS
2: /* $Header: IGSLI02B.pls 115.5 2002/11/29 01:02:31 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_cat%ROWTYPE;
6: new_references igs_co_cat%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_co_cat%ROWTYPE;

2: /* $Header: IGSLI02B.pls 115.5 2002/11/29 01:02:31 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_cat%ROWTYPE;
6: new_references igs_co_cat%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 32: FROM IGS_CO_CAT

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

Line 116: igs_co_cat_itm_pkg.get_fk_igs_co_cat (

112: || (reverse chronological order - newest change first)
113: */
114: BEGIN
115:
116: igs_co_cat_itm_pkg.get_fk_igs_co_cat (
117: old_references.correspondence_cat
118: );
119:
120: igs_co_cat_map_pkg.get_fk_igs_co_cat (

Line 120: igs_co_cat_map_pkg.get_fk_igs_co_cat (

116: igs_co_cat_itm_pkg.get_fk_igs_co_cat (
117: old_references.correspondence_cat
118: );
119:
120: igs_co_cat_map_pkg.get_fk_igs_co_cat (
121: old_references.correspondence_cat
122: );
123:
124: END check_child_existance;

Line 141: FROM igs_co_cat

137: || (reverse chronological order - newest change first)
138: */
139: CURSOR cur_rowid IS
140: SELECT rowid
141: FROM igs_co_cat
142: WHERE correspondence_cat = x_correspondence_cat
143: FOR UPDATE NOWAIT;
144:
145: lv_rowid cur_rowid%RowType;

Line 254: FROM igs_co_cat

250: || (reverse chronological order - newest change first)
251: */
252: CURSOR c IS
253: SELECT rowid
254: FROM igs_co_cat
255: WHERE correspondence_cat = x_correspondence_cat;
256:
257: x_last_update_date DATE;
258: x_last_updated_by NUMBER;

Line 295: INSERT INTO igs_co_cat (

291: x_last_updated_by => x_last_updated_by,
292: x_last_update_login => x_last_update_login
293: );
294:
295: INSERT INTO igs_co_cat (
296: correspondence_cat,
297: description,
298: closed_ind,
299: creation_date,

Line 345: FROM igs_co_cat

341: CURSOR c1 IS
342: SELECT
343: description,
344: closed_ind
345: FROM igs_co_cat
346: WHERE rowid = x_rowid
347: FOR UPDATE NOWAIT;
348:
349: tlinfo c1%ROWTYPE;

Line 434: UPDATE igs_co_cat

430: x_last_updated_by => x_last_updated_by,
431: x_last_update_login => x_last_update_login
432: );
433:
434: UPDATE igs_co_cat
435: SET
436: description = new_references.description,
437: closed_ind = new_references.closed_ind,
438: last_update_date = x_last_update_date,

Line 468: FROM igs_co_cat

464: || (reverse chronological order - newest change first)
465: */
466: CURSOR c1 IS
467: SELECT rowid
468: FROM igs_co_cat
469: WHERE correspondence_cat = x_correspondence_cat;
470:
471: BEGIN
472:

Line 519: DELETE FROM igs_co_cat

515: p_action => 'DELETE',
516: x_rowid => x_rowid
517: );
518:
519: DELETE FROM igs_co_cat
520: WHERE rowid = x_rowid;
521:
522: IF (SQL%NOTFOUND) THEN
523: RAISE NO_DATA_FOUND;

Line 529: END igs_co_cat_pkg;

525:
526: END delete_row;
527:
528:
529: END igs_co_cat_pkg;