APPS.IGS_CO_CAT_MAP_PKG dependencies on IGS_CO_CAT_MAP

Line 1: PACKAGE BODY igs_co_cat_map_pkg AS

1: PACKAGE BODY igs_co_cat_map_pkg AS
2: /* $Header: IGSLI04B.pls 115.5 2003/10/30 13:29:16 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_cat_map%ROWTYPE;

Line 5: old_references igs_co_cat_map%ROWTYPE;

1: PACKAGE BODY igs_co_cat_map_pkg AS
2: /* $Header: IGSLI04B.pls 115.5 2003/10/30 13:29:16 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_cat_map%ROWTYPE;
6: new_references igs_co_cat_map%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_co_cat_map%ROWTYPE;

2: /* $Header: IGSLI04B.pls 115.5 2003/10/30 13:29:16 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_cat_map%ROWTYPE;
6: new_references igs_co_cat_map%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_MAP

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

Line 157: FROM igs_co_cat_map

153: || (reverse chronological order - newest change first)
154: */
155: CURSOR cur_rowid IS
156: SELECT rowid
157: FROM igs_co_cat_map
158: WHERE correspondence_cat = x_correspondence_cat
159: AND admission_cat = x_admission_cat
160: FOR UPDATE NOWAIT;
161:

Line 193: FROM igs_co_cat_map

189: || (reverse chronological order - newest change first)
190: */
191: CURSOR cur_rowid IS
192: SELECT rowid
193: FROM igs_co_cat_map
194: WHERE ((correspondence_cat = x_correspondence_cat));
195:
196: lv_rowid cur_rowid%RowType;
197:

Line 228: FROM igs_co_cat_map

224: || (reverse chronological order - newest change first)
225: */
226: CURSOR cur_rowid IS
227: SELECT rowid
228: FROM igs_co_cat_map
229: WHERE ((admission_cat = x_admission_cat));
230:
231: lv_rowid cur_rowid%RowType;
232:

Line 340: FROM igs_co_cat_map

336: || (reverse chronological order - newest change first)
337: */
338: CURSOR c IS
339: SELECT rowid
340: FROM igs_co_cat_map
341: WHERE correspondence_cat = x_correspondence_cat
342: AND admission_cat = x_admission_cat;
343:
344: x_last_update_date DATE;

Line 382: INSERT INTO igs_co_cat_map (

378: x_last_updated_by => x_last_updated_by,
379: x_last_update_login => x_last_update_login
380: );
381:
382: INSERT INTO igs_co_cat_map (
383: correspondence_cat,
384: admission_cat,
385: dflt_cat_ind,
386: creation_date,

Line 431: FROM igs_co_cat_map

427: */
428: CURSOR c1 IS
429: SELECT
430: dflt_cat_ind
431: FROM igs_co_cat_map
432: WHERE rowid = x_rowid
433: FOR UPDATE NOWAIT;
434:
435: tlinfo c1%ROWTYPE;

Line 519: UPDATE igs_co_cat_map

515: x_last_updated_by => x_last_updated_by,
516: x_last_update_login => x_last_update_login
517: );
518:
519: UPDATE igs_co_cat_map
520: SET
521: dflt_cat_ind = new_references.dflt_cat_ind,
522: last_update_date = x_last_update_date,
523: last_updated_by = x_last_updated_by,

Line 552: FROM igs_co_cat_map

548: || (reverse chronological order - newest change first)
549: */
550: CURSOR c1 IS
551: SELECT rowid
552: FROM igs_co_cat_map
553: WHERE correspondence_cat = x_correspondence_cat
554: AND admission_cat = x_admission_cat;
555:
556: BEGIN

Line 604: DELETE FROM igs_co_cat_map

600: p_action => 'DELETE',
601: x_rowid => x_rowid
602: );
603:
604: DELETE FROM igs_co_cat_map
605: WHERE rowid = x_rowid;
606:
607: IF (SQL%NOTFOUND) THEN
608: RAISE NO_DATA_FOUND;

Line 614: END igs_co_cat_map_pkg;

610:
611: END delete_row;
612:
613:
614: END igs_co_cat_map_pkg;