APPS.IGS_AS_ANON_METHOD_PKG dependencies on IGS_AS_ANON_METHOD

Line 1: PACKAGE BODY igs_as_anon_method_pkg AS

1: PACKAGE BODY igs_as_anon_method_pkg AS
2: /* $Header: IGSDI60B.pls 115.1 2002/11/28 23:25:57 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_anon_method%ROWTYPE;

Line 5: old_references igs_as_anon_method%ROWTYPE;

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

Line 6: new_references igs_as_anon_method%ROWTYPE;

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

Line 32: FROM igs_as_anon_method

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

Line 123: FROM igs_as_anon_method

119: || (reverse chronological order - newest change first)
120: */
121: CURSOR cur_rowid IS
122: SELECT rowid
123: FROM igs_as_anon_method
124: WHERE load_cal_type = x_load_cal_type
125: FOR UPDATE NOWAIT;
126:
127: lv_rowid cur_rowid%RowType;

Line 158: FROM igs_as_anon_method

154: || (reverse chronological order - newest change first)
155: */
156: CURSOR cur_rowid IS
157: SELECT rowid
158: FROM igs_as_anon_method
159: WHERE ((assessment_type = x_assessment_type));
160:
161: lv_rowid cur_rowid%RowType;
162:

Line 193: FROM igs_as_anon_method

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

Line 298: FROM igs_as_anon_method

294: || (reverse chronological order - newest change first)
295: */
296: CURSOR c IS
297: SELECT rowid
298: FROM igs_as_anon_method
299: WHERE load_cal_type = x_load_cal_type;
300:
301: x_last_update_date DATE;
302: x_last_updated_by NUMBER;

Line 339: INSERT INTO igs_as_anon_method (

335: x_last_updated_by => x_last_updated_by,
336: x_last_update_login => x_last_update_login
337: );
338:
339: INSERT INTO igs_as_anon_method (
340: load_cal_type,
341: method,
342: assessment_type,
343: creation_date,

Line 389: FROM igs_as_anon_method

385: CURSOR c1 IS
386: SELECT
387: method,
388: assessment_type
389: FROM igs_as_anon_method
390: WHERE rowid = x_rowid
391: FOR UPDATE NOWAIT;
392:
393: tlinfo c1%ROWTYPE;

Line 478: UPDATE igs_as_anon_method

474: x_last_updated_by => x_last_updated_by,
475: x_last_update_login => x_last_update_login
476: );
477:
478: UPDATE igs_as_anon_method
479: SET
480: method = new_references.method,
481: assessment_type = new_references.assessment_type,
482: last_update_date = x_last_update_date,

Line 512: FROM igs_as_anon_method

508: || (reverse chronological order - newest change first)
509: */
510: CURSOR c1 IS
511: SELECT rowid
512: FROM igs_as_anon_method
513: WHERE load_cal_type = x_load_cal_type;
514:
515: BEGIN
516:

Line 563: DELETE FROM igs_as_anon_method

559: p_action => 'DELETE',
560: x_rowid => x_rowid
561: );
562:
563: DELETE FROM igs_as_anon_method
564: WHERE rowid = x_rowid;
565:
566: IF (SQL%NOTFOUND) THEN
567: RAISE NO_DATA_FOUND;

Line 573: END igs_as_anon_method_pkg;

569:
570: END delete_row;
571:
572:
573: END igs_as_anon_method_pkg;