APPS.IGS_HE_EXT_RUN_PRMS_PKG dependencies on IGS_HE_EXT_RUN_PRMS

Line 1: PACKAGE BODY igs_he_ext_run_prms_pkg AS

1: PACKAGE BODY igs_he_ext_run_prms_pkg AS
2: /* $Header: IGSWI07B.pls 115.6 2002/12/20 08:47:15 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ext_run_prms%ROWTYPE;

Line 5: old_references igs_he_ext_run_prms%ROWTYPE;

1: PACKAGE BODY igs_he_ext_run_prms_pkg AS
2: /* $Header: IGSWI07B.pls 115.6 2002/12/20 08:47:15 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ext_run_prms%ROWTYPE;
6: new_references igs_he_ext_run_prms%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_ext_run_prms%ROWTYPE;

2: /* $Header: IGSWI07B.pls 115.6 2002/12/20 08:47:15 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ext_run_prms%ROWTYPE;
6: new_references igs_he_ext_run_prms%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 34: FROM IGS_HE_EXT_RUN_PRMS

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

Line 116: FROM igs_he_ext_run_prms

112: || (reverse chronological order - newest change first)
113: */
114: CURSOR cur_rowid IS
115: SELECT rowid
116: FROM igs_he_ext_run_prms
117: WHERE run_prms_id = x_run_prms_id
118: FOR UPDATE NOWAIT;
119:
120: lv_rowid cur_rowid%RowType;

Line 151: FROM igs_he_ext_run_prms

147: || (reverse chronological order - newest change first)
148: */
149: CURSOR cur_rowid IS
150: SELECT rowid
151: FROM igs_he_ext_run_prms
152: WHERE ((extract_run_id = x_extract_run_id));
153:
154: lv_rowid cur_rowid%RowType;
155:

Line 262: FROM igs_he_ext_run_prms

258: || (reverse chronological order - newest change first)
259: */
260: CURSOR c IS
261: SELECT rowid
262: FROM igs_he_ext_run_prms
263: WHERE run_prms_id = x_run_prms_id;
264:
265: x_last_update_date DATE;
266: x_last_updated_by NUMBER;

Line 290: SELECT igs_he_ext_run_prms_s.NEXTVAL

286: igs_ge_msg_stack.add;
287: app_exception.raise_exception;
288: END IF;
289:
290: SELECT igs_he_ext_run_prms_s.NEXTVAL
291: INTO x_run_prms_id
292: FROM dual;
293:
294: before_dml(

Line 309: INSERT INTO igs_he_ext_run_prms (

305: x_last_updated_by => x_last_updated_by,
306: x_last_update_login => x_last_update_login
307: );
308:
309: INSERT INTO igs_he_ext_run_prms (
310: run_prms_id,
311: extract_run_id,
312: param_type,
313: exclude,

Line 367: FROM igs_he_ext_run_prms

363: extract_run_id,
364: param_type,
365: exclude,
366: only
367: FROM igs_he_ext_run_prms
368: WHERE rowid = x_rowid
369: FOR UPDATE NOWAIT;
370:
371: tlinfo c1%ROWTYPE;

Line 462: UPDATE igs_he_ext_run_prms

458: x_last_updated_by => x_last_updated_by,
459: x_last_update_login => x_last_update_login
460: );
461:
462: UPDATE igs_he_ext_run_prms
463: SET
464: extract_run_id = new_references.extract_run_id,
465: param_type = new_references.param_type,
466: exclude = new_references.exclude,

Line 500: FROM igs_he_ext_run_prms

496: || (reverse chronological order - newest change first)
497: */
498: CURSOR c1 IS
499: SELECT rowid
500: FROM igs_he_ext_run_prms
501: WHERE run_prms_id = x_run_prms_id;
502:
503: BEGIN
504:

Line 555: DELETE FROM igs_he_ext_run_prms

551: p_action => 'DELETE',
552: x_rowid => x_rowid
553: );
554:
555: DELETE FROM igs_he_ext_run_prms
556: WHERE rowid = x_rowid;
557:
558: IF (SQL%NOTFOUND) THEN
559: RAISE NO_DATA_FOUND;

Line 565: END igs_he_ext_run_prms_pkg;

561:
562: END delete_row;
563:
564:
565: END igs_he_ext_run_prms_pkg;