APPS.IGS_AD_APPL_PERSTAT_PKG dependencies on IGS_AD_APPL_PERSTAT

Line 1: PACKAGE BODY igs_ad_appl_perstat_pkg AS

1: PACKAGE BODY igs_ad_appl_perstat_pkg AS
2: /* $Header: IGSAIG3B.pls 120.3 2005/10/03 08:24:03 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_appl_perstat%ROWTYPE;

Line 5: old_references igs_ad_appl_perstat%ROWTYPE;

1: PACKAGE BODY igs_ad_appl_perstat_pkg AS
2: /* $Header: IGSAIG3B.pls 120.3 2005/10/03 08:24:03 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_appl_perstat%ROWTYPE;
6: new_references igs_ad_appl_perstat%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_appl_perstat%ROWTYPE;

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

Line 34: FROM igs_ad_appl_perstat

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

Line 150: FROM igs_ad_appl_perstat

146: || (reverse chronological order - newest change first)
147: */
148: CURSOR cur_rowid IS
149: SELECT rowid
150: FROM igs_ad_appl_perstat
151: WHERE appl_perstat_id = x_appl_perstat_id AND
152: person_id = x_person_id AND
153: admission_appl_number = x_admission_appl_number
154: FOR UPDATE NOWAIT;

Line 187: FROM igs_ad_appl_perstat

183: || (reverse chronological order - newest change first)
184: */
185: CURSOR cur_rowid IS
186: SELECT rowid
187: FROM igs_ad_appl_perstat
188: WHERE ((persl_stat_type = x_persl_stat_type));
189:
190: lv_rowid cur_rowid%RowType;
191:

Line 310: FROM igs_ad_appl_perstat

306: || (reverse chronological order - newest change first)
307: */
308: CURSOR c IS
309: SELECT rowid
310: FROM igs_ad_appl_perstat
311: WHERE appl_perstat_id = x_appl_perstat_id;
312:
313: x_last_update_date DATE;
314: x_last_updated_by NUMBER;

Line 373: INSERT INTO igs_ad_appl_perstat (

369:
370: IF (x_mode = 'S') THEN
371: igs_sc_gen_001.set_ctx('R');
372: END IF;
373: INSERT INTO igs_ad_appl_perstat (
374: appl_perstat_id,
375: person_id,
376: admission_appl_number,
377: persl_stat_type,

Line 389: igs_ad_appl_perstat_s.NEXTVAL,

385: program_id,
386: program_application_id,
387: program_update_date
388: ) VALUES (
389: igs_ad_appl_perstat_s.NEXTVAL,
390: new_references.person_id,
391: new_references.admission_appl_number,
392: new_references.persl_stat_type,
393: new_references.date_received,

Line 463: FROM igs_ad_appl_perstat

459: person_id,
460: admission_appl_number,
461: persl_stat_type,
462: date_received
463: FROM igs_ad_appl_perstat
464: WHERE rowid = x_rowid
465: FOR UPDATE NOWAIT;
466:
467: tlinfo c1%ROWTYPE;

Line 581: UPDATE igs_ad_appl_perstat

577:
578: IF (x_mode = 'S') THEN
579: igs_sc_gen_001.set_ctx('R');
580: END IF;
581: UPDATE igs_ad_appl_perstat
582: SET
583: appl_perstat_id = new_references.appl_perstat_id,
584: person_id = new_references.person_id,
585: admission_appl_number = new_references.admission_appl_number,

Line 651: FROM igs_ad_appl_perstat

647: || (reverse chronological order - newest change first)
648: */
649: CURSOR c1 IS
650: SELECT rowid
651: FROM igs_ad_appl_perstat
652: WHERE appl_perstat_id = x_appl_perstat_id;
653:
654: BEGIN
655:

Line 711: DELETE FROM igs_ad_appl_perstat

707:
708: IF (x_mode = 'S') THEN
709: igs_sc_gen_001.set_ctx('R');
710: END IF;
711: DELETE FROM igs_ad_appl_perstat
712: WHERE rowid = x_rowid;
713:
714: IF (SQL%NOTFOUND) THEN
715: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 748: END igs_ad_appl_perstat_pkg;

744: END IF;
745: END delete_row;
746:
747:
748: END igs_ad_appl_perstat_pkg;