APPS.IGS_AD_APTYP_PESTAT_PKG dependencies on IGS_AD_APTYP_PESTAT

Line 1: PACKAGE BODY igs_ad_aptyp_pestat_pkg AS

1: PACKAGE BODY igs_ad_aptyp_pestat_pkg AS
2: /* $Header: IGSAIG2B.pls 115.4 2003/10/30 13:26:49 rghosh noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_aptyp_pestat%ROWTYPE;

Line 5: old_references igs_ad_aptyp_pestat%ROWTYPE;

1: PACKAGE BODY igs_ad_aptyp_pestat_pkg AS
2: /* $Header: IGSAIG2B.pls 115.4 2003/10/30 13:26:49 rghosh noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_aptyp_pestat%ROWTYPE;
6: new_references igs_ad_aptyp_pestat%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_aptyp_pestat%ROWTYPE;

2: /* $Header: IGSAIG2B.pls 115.4 2003/10/30 13:26:49 rghosh noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_aptyp_pestat%ROWTYPE;
6: new_references igs_ad_aptyp_pestat%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 33: FROM igs_ad_aptyp_pestat

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

Line 128: FROM igs_ad_aptyp_pestat

124: || (reverse chronological order - newest change first)
125: */
126: CURSOR cur_rowid IS
127: SELECT rowid
128: FROM igs_ad_aptyp_pestat
129: WHERE admission_application_type = x_admission_application_type
130: AND persl_stat_type = x_persl_stat_type
131: FOR UPDATE NOWAIT;
132:

Line 164: FROM igs_ad_aptyp_pestat

160: || (reverse chronological order - newest change first)
161: */
162: CURSOR cur_rowid IS
163: SELECT rowid
164: FROM igs_ad_aptyp_pestat
165: WHERE ((persl_stat_type = x_persl_stat_type));
166:
167: lv_rowid cur_rowid%RowType;
168:

Line 199: FROM igs_ad_aptyp_pestat

195: || (reverse chronological order - newest change first)
196: */
197: CURSOR cur_rowid IS
198: SELECT rowid
199: FROM igs_ad_aptyp_pestat
200: WHERE ((admission_application_type = x_admission_appl_type));
201:
202: lv_rowid cur_rowid%RowType;
203:

Line 309: FROM igs_ad_aptyp_pestat

305: || (reverse chronological order - newest change first)
306: */
307: CURSOR c IS
308: SELECT rowid
309: FROM igs_ad_aptyp_pestat
310: WHERE admission_application_type = x_admission_application_type
311: AND persl_stat_type = x_persl_stat_type;
312:
313: x_last_update_date DATE;

Line 352: INSERT INTO igs_ad_aptyp_pestat (

348: x_last_updated_by => x_last_updated_by,
349: x_last_update_login => x_last_update_login
350: );
351:
352: INSERT INTO igs_ad_aptyp_pestat (
353: admission_application_type,
354: persl_stat_type,
355: group_number,
356: mandatory,

Line 405: FROM igs_ad_aptyp_pestat

401: CURSOR c1 IS
402: SELECT
403: group_number,
404: mandatory
405: FROM igs_ad_aptyp_pestat
406: WHERE rowid = x_rowid
407: FOR UPDATE NOWAIT;
408:
409: tlinfo c1%ROWTYPE;

Line 496: UPDATE igs_ad_aptyp_pestat

492: x_last_updated_by => x_last_updated_by,
493: x_last_update_login => x_last_update_login
494: );
495:
496: UPDATE igs_ad_aptyp_pestat
497: SET
498: group_number = new_references.group_number,
499: mandatory = new_references.mandatory,
500: last_update_date = x_last_update_date,

Line 531: FROM igs_ad_aptyp_pestat

527: || (reverse chronological order - newest change first)
528: */
529: CURSOR c1 IS
530: SELECT rowid
531: FROM igs_ad_aptyp_pestat
532: WHERE admission_application_type = x_admission_application_type
533: AND persl_stat_type = x_persl_stat_type;
534:
535: BEGIN

Line 585: DELETE FROM igs_ad_aptyp_pestat

581: p_action => 'DELETE',
582: x_rowid => x_rowid
583: );
584:
585: DELETE FROM igs_ad_aptyp_pestat
586: WHERE rowid = x_rowid;
587:
588: IF (SQL%NOTFOUND) THEN
589: RAISE NO_DATA_FOUND;

Line 595: END igs_ad_aptyp_pestat_pkg;

591:
592: END delete_row;
593:
594:
595: END igs_ad_aptyp_pestat_pkg;