APPS.IGS_AD_SS_APPL_UPD_PAGE dependencies on IGS_AD_APPL_PERSTAT

Line 5: old_references igs_ad_appl_perstat%ROWTYPE;

1: PACKAGE BODY igs_ad_ss_appl_upd_page AS
2: /* $Header: IGSADC5B.pls 115.5 2003/10/30 13:18:27 rghosh noship $ */
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: IGSADC5B.pls 115.5 2003/10/30 13:18:27 rghosh noship $ */
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 ,

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 118: FROM igs_ad_appl_perstat

114: || (reverse chronological order - newest change first)
115: */
116: CURSOR cur_rowid IS
117: SELECT rowid
118: FROM igs_ad_appl_perstat
119: WHERE appl_perstat_id = x_appl_perstat_id AND
120: person_id = x_person_id AND
121: admission_appl_number = x_admission_appl_number
122: FOR UPDATE NOWAIT;

Line 217: FROM igs_ad_appl_perstat

213: || (reverse chronological order - newest change first)
214: */
215: CURSOR c IS
216: SELECT rowid
217: FROM igs_ad_appl_perstat
218: WHERE appl_perstat_id = x_appl_perstat_id;
219:
220: x_last_update_date DATE;
221: x_last_updated_by NUMBER;

Line 276: INSERT INTO igs_ad_appl_perstat (

272: x_last_updated_by => x_last_updated_by,
273: x_last_update_login => x_last_update_login
274: );
275:
276: INSERT INTO igs_ad_appl_perstat (
277: appl_perstat_id,
278: person_id,
279: admission_appl_number,
280: persl_stat_type,

Line 292: igs_ad_appl_perstat_s.NEXTVAL,

288: program_id,
289: program_application_id,
290: program_update_date
291: ) VALUES (
292: igs_ad_appl_perstat_s.NEXTVAL,
293: new_references.person_id,
294: new_references.admission_appl_number,
295: new_references.persl_stat_type,
296: new_references.date_received,