APPS.IGS_EN_INTM_TYPES_PKG dependencies on IGS_EN_INTM_TYPES

Line 1: PACKAGE BODY igs_en_intm_types_pkg AS

1: PACKAGE BODY igs_en_intm_types_pkg AS
2: /* $Header: IGSEI56B.pls 115.6 2003/02/20 11:26:14 kkillams noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_intm_types%ROWTYPE;

Line 5: old_references igs_en_intm_types%ROWTYPE;

1: PACKAGE BODY igs_en_intm_types_pkg AS
2: /* $Header: IGSEI56B.pls 115.6 2003/02/20 11:26:14 kkillams noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_intm_types%ROWTYPE;
6: new_references igs_en_intm_types%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_en_intm_types%ROWTYPE;

2: /* $Header: IGSEI56B.pls 115.6 2003/02/20 11:26:14 kkillams noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_intm_types%ROWTYPE;
6: new_references igs_en_intm_types%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 34: FROM igs_en_intm_types

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

Line 91: FROM igs_en_intm_types

87: || (reverse chronological order - newest change first)
88: */
89: CURSOR cur_rowid IS
90: SELECT rowid
91: FROM igs_en_intm_types
92: WHERE intermission_type = x_intermission_type
93: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
94:
95:

Line 199: FROM igs_en_intm_types

195: || (reverse chronological order - newest change first)
196: */
197: CURSOR c IS
198: SELECT rowid
199: FROM igs_en_intm_types
200: WHERE intermission_type = x_intermission_type;
201:
202: x_last_update_date DATE;
203: x_last_updated_by NUMBER;

Line 242: INSERT INTO igs_en_intm_types (

238: x_last_updated_by => x_last_updated_by,
239: x_last_update_login => x_last_update_login
240: );
241:
242: INSERT INTO igs_en_intm_types (
243: intermission_type,
244: description,
245: appr_reqd_ind,
246: study_antr_inst_ind,

Line 301: FROM igs_en_intm_types

297: description,
298: appr_reqd_ind,
299: study_antr_inst_ind,
300: closed_ind
301: FROM igs_en_intm_types
302: WHERE rowid = x_rowid
303: FOR UPDATE NOWAIT;
304:
305: tlinfo c1%ROWTYPE;

Line 398: UPDATE igs_en_intm_types

394: x_last_updated_by => x_last_updated_by,
395: x_last_update_login => x_last_update_login
396: );
397:
398: UPDATE igs_en_intm_types
399: SET
400: description = new_references.description,
401: appr_reqd_ind = new_references.appr_reqd_ind,
402: study_antr_inst_ind = new_references.study_antr_inst_ind,

Line 436: FROM igs_en_intm_types

432: || (reverse chronological order - newest change first)
433: */
434: CURSOR c1 IS
435: SELECT rowid
436: FROM igs_en_intm_types
437: WHERE intermission_type = x_intermission_type;
438:
439: BEGIN
440:

Line 471: END igs_en_intm_types_pkg;

467: );
468:
469: END add_row;
470:
471: END igs_en_intm_types_pkg;