APPS.IGS_AD_PESTAT_GROUP_PKG dependencies on IGS_AD_PESTAT_GROUP

Line 1: PACKAGE BODY igs_ad_pestat_group_pkg AS

1: PACKAGE BODY igs_ad_pestat_group_pkg AS
2: /* $Header: IGSAIG4B.pls 120.1 2005/08/03 06:46:46 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_pestat_group%ROWTYPE;

Line 5: old_references igs_ad_pestat_group%ROWTYPE;

1: PACKAGE BODY igs_ad_pestat_group_pkg AS
2: /* $Header: IGSAIG4B.pls 120.1 2005/08/03 06:46:46 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_pestat_group%ROWTYPE;
6: new_references igs_ad_pestat_group%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_pestat_group%ROWTYPE;

2: /* $Header: IGSAIG4B.pls 120.1 2005/08/03 06:46:46 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_pestat_group%ROWTYPE;
6: new_references igs_ad_pestat_group%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM igs_ad_pestat_group

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

Line 122: FROM igs_ad_pestat_group

118: || (reverse chronological order - newest change first)
119: */
120: CURSOR cur_rowid IS
121: SELECT rowid
122: FROM igs_ad_pestat_group
123: WHERE group_number = x_group_number
124: AND admission_application_type = x_admission_application_type
125: FOR UPDATE NOWAIT;
126:

Line 158: FROM igs_ad_pestat_group

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

Line 274: FROM igs_ad_pestat_group

270: || (reverse chronological order - newest change first)
271: */
272: CURSOR c IS
273: SELECT rowid
274: FROM igs_ad_pestat_group
275: WHERE group_number = x_group_number
276: AND admission_application_type = x_admission_application_type;
277:
278: x_last_update_date DATE;

Line 319: INSERT INTO igs_ad_pestat_group (

315: x_group_name => x_group_name,
316: x_group_required_flag => x_group_required_flag
317: );
318:
319: INSERT INTO igs_ad_pestat_group (
320: group_number,
321: admission_application_type,
322: group_min,
323: self_message,

Line 376: FROM igs_ad_pestat_group

372: || (reverse chronological order - newest change first)
373: */
374: CURSOR c1 IS
375: SELECT *
376: FROM igs_ad_pestat_group
377: WHERE rowid = x_rowid
378: FOR UPDATE NOWAIT;
379:
380: tlinfo c1%ROWTYPE;

Line 473: UPDATE igs_ad_pestat_group

469: x_group_name => x_group_name,
470: x_group_required_flag => x_group_required_flag
471: );
472:
473: UPDATE igs_ad_pestat_group
474: SET
475: group_min = new_references.group_min,
476: self_message = new_references.self_message,
477: last_update_date = x_last_update_date,

Line 512: FROM igs_ad_pestat_group

508: || (reverse chronological order - newest change first)
509: */
510: CURSOR c1 IS
511: SELECT rowid
512: FROM igs_ad_pestat_group
513: WHERE group_number = x_group_number
514: AND admission_application_type = x_admission_application_type;
515:
516: BEGIN

Line 570: DELETE FROM igs_ad_pestat_group

566: p_action => 'DELETE',
567: x_rowid => x_rowid
568: );
569:
570: DELETE FROM igs_ad_pestat_group
571: WHERE rowid = x_rowid;
572:
573: IF (SQL%NOTFOUND) THEN
574: RAISE NO_DATA_FOUND;

Line 580: END igs_ad_pestat_group_pkg;

576:
577: END delete_row;
578:
579:
580: END igs_ad_pestat_group_pkg;