APPS.IGS_EN_DOC_INSTANCES_PKG dependencies on IGS_EN_DOC_INSTANCES

Line 1: PACKAGE BODY igs_en_doc_instances_pkg AS

1: PACKAGE BODY igs_en_doc_instances_pkg AS
2: /* $Header: IGSEI63B.pls 115.1 2002/11/28 23:47:50 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_doc_instances%ROWTYPE;

Line 5: old_references igs_en_doc_instances%ROWTYPE;

1: PACKAGE BODY igs_en_doc_instances_pkg AS
2: /* $Header: IGSEI63B.pls 115.1 2002/11/28 23:47:50 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_doc_instances%ROWTYPE;
6: new_references igs_en_doc_instances%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_en_doc_instances%ROWTYPE;

2: /* $Header: IGSEI63B.pls 115.1 2002/11/28 23:47:50 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_doc_instances%ROWTYPE;
6: new_references igs_en_doc_instances%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 32: FROM igs_en_doc_instances

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

Line 86: FROM igs_en_doc_instances

82: || (reverse chronological order - newest change first)
83: */
84: CURSOR cur_rowid IS
85: SELECT rowid
86: FROM igs_en_doc_instances
87: WHERE doc_inst_id = x_doc_inst_id
88: FOR UPDATE NOWAIT;
89:
90: lv_rowid cur_rowid%RowType;

Line 191: FROM igs_en_doc_instances

187: || (reverse chronological order - newest change first)
188: */
189: CURSOR c IS
190: SELECT rowid
191: FROM igs_en_doc_instances
192: WHERE doc_inst_id = x_doc_inst_id;
193:
194: x_last_update_date DATE;
195: x_last_updated_by NUMBER;

Line 219: SELECT igs_en_doc_instances_s.NEXTVAL

215: igs_ge_msg_stack.add;
216: app_exception.raise_exception;
217: END IF;
218:
219: SELECT igs_en_doc_instances_s.NEXTVAL
220: INTO x_doc_inst_id
221: FROM dual;
222:
223: before_dml(

Line 236: INSERT INTO igs_en_doc_instances (

232: x_last_updated_by => x_last_updated_by,
233: x_last_update_login => x_last_update_login
234: );
235:
236: INSERT INTO igs_en_doc_instances (
237: doc_inst_id,
238: doc_inst_name,
239: doc_inst_params,
240: creation_date,

Line 286: FROM igs_en_doc_instances

282: CURSOR c1 IS
283: SELECT
284: doc_inst_name,
285: doc_inst_params
286: FROM igs_en_doc_instances
287: WHERE rowid = x_rowid
288: FOR UPDATE NOWAIT;
289:
290: tlinfo c1%ROWTYPE;

Line 375: UPDATE igs_en_doc_instances

371: x_last_updated_by => x_last_updated_by,
372: x_last_update_login => x_last_update_login
373: );
374:
375: UPDATE igs_en_doc_instances
376: SET
377: doc_inst_name = new_references.doc_inst_name,
378: doc_inst_params = new_references.doc_inst_params,
379: last_update_date = x_last_update_date,

Line 409: FROM igs_en_doc_instances

405: || (reverse chronological order - newest change first)
406: */
407: CURSOR c1 IS
408: SELECT rowid
409: FROM igs_en_doc_instances
410: WHERE doc_inst_id = x_doc_inst_id;
411:
412: BEGIN
413:

Line 460: FROM igs_en_doc_instances

456: CURSOR c_rowid IS
457: SELECT rowid
458: FROM igs_en_attrib_values
459: WHERE obj_id = (SELECT doc_inst_id
460: FROM igs_en_doc_instances
461: WHERE rowid = x_rowid);
462: l_rowid VARCHAR2(255);
463:
464: BEGIN

Line 483: DELETE FROM igs_en_doc_instances

479: END LOOP;
480: CLOSE c_rowid;
481:
482:
483: DELETE FROM igs_en_doc_instances
484: WHERE rowid = x_rowid;
485:
486: IF (SQL%NOTFOUND) THEN
487: RAISE NO_DATA_FOUND;

Line 492: END igs_en_doc_instances_pkg;

488: END IF;
489:
490: END delete_row;
491:
492: END igs_en_doc_instances_pkg;