APPS.IGS_PS_US_FLD_STUDY_PKG dependencies on IGS_PS_US_FLD_STUDY

Line 1: PACKAGE BODY igs_ps_us_fld_study_pkg AS

1: PACKAGE BODY igs_ps_us_fld_study_pkg AS
2: /* $Header: IGSPI98B.pls 115.2 2003/05/21 14:28:53 jbegum noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_us_fld_study%ROWTYPE;

Line 5: old_references igs_ps_us_fld_study%ROWTYPE;

1: PACKAGE BODY igs_ps_us_fld_study_pkg AS
2: /* $Header: IGSPI98B.pls 115.2 2003/05/21 14:28:53 jbegum noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_us_fld_study%ROWTYPE;
6: new_references igs_ps_us_fld_study%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_us_fld_study%ROWTYPE;

2: /* $Header: IGSPI98B.pls 115.2 2003/05/21 14:28:53 jbegum noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_us_fld_study%ROWTYPE;
6: new_references igs_ps_us_fld_study%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 32: FROM igs_ps_us_fld_study

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

Line 117: FROM igs_ps_us_fld_study

113: || (reverse chronological order - newest change first)
114: */
115: CURSOR cur_rowid IS
116: SELECT rowid
117: FROM igs_ps_us_fld_study
118: WHERE unit_set_cd = x_unit_set_cd
119: AND version_number = x_version_number
120: AND field_of_study = x_field_of_study
121: FOR UPDATE NOWAIT;

Line 155: FROM igs_ps_us_fld_study

151: || (reverse chronological order - newest change first)
152: */
153: CURSOR cur_rowid IS
154: SELECT rowid
155: FROM igs_ps_us_fld_study
156: WHERE ((unit_set_cd = x_unit_set_cd) AND
157: (version_number = x_version_number));
158:
159: lv_rowid cur_rowid%RowType;

Line 190: FROM igs_ps_us_fld_study

186: || (reverse chronological order - newest change first)
187: */
188: CURSOR cur_rowid IS
189: SELECT rowid
190: FROM igs_ps_us_fld_study
191: WHERE field_of_study = x_field_of_study;
192:
193: lv_rowid cur_rowid%RowType;
194:

Line 319: fnd_message.set_token ('ROUTINE', 'IGS_PS_US_FLD_STUDY_PKG.INSERT_ROW');

315: x_last_update_login := -1;
316: END IF;
317: ELSE
318: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
319: fnd_message.set_token ('ROUTINE', 'IGS_PS_US_FLD_STUDY_PKG.INSERT_ROW');
320: igs_ge_msg_stack.add;
321: app_exception.raise_exception;
322: END IF;
323:

Line 337: INSERT INTO igs_ps_us_fld_study (

333: x_last_updated_by => x_last_updated_by,
334: x_last_update_login => x_last_update_login
335: );
336:
337: INSERT INTO igs_ps_us_fld_study (
338: unit_set_cd,
339: version_number,
340: field_of_study,
341: creation_date,

Line 378: FROM igs_ps_us_fld_study

374: */
375: CURSOR c1 IS
376: SELECT
377: rowid
378: FROM igs_ps_us_fld_study
379: WHERE rowid = x_rowid
380: FOR UPDATE NOWAIT;
381:
382: tlinfo c1%ROWTYPE;

Line 422: DELETE FROM igs_ps_us_fld_study

418: p_action => 'DELETE',
419: x_rowid => x_rowid
420: );
421:
422: DELETE FROM igs_ps_us_fld_study
423: WHERE rowid = x_rowid;
424:
425: IF (SQL%NOTFOUND) THEN
426: RAISE NO_DATA_FOUND;

Line 432: END igs_ps_us_fld_study_pkg;

428:
429: END delete_row;
430:
431:
432: END igs_ps_us_fld_study_pkg;