APPS.IGS_PE_USR_AVAL_PKG dependencies on IGS_PE_USR_AVAL_ALL

Line 5: old_references igs_pe_usr_aval_all%ROWTYPE;

1: PACKAGE BODY igs_pe_usr_aval_pkg AS
2: /* $Header: IGSNI83B.pls 115.10 2002/11/29 01:33:15 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_usr_aval_all%ROWTYPE;
6: new_references igs_pe_usr_aval_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pe_usr_aval_all%ROWTYPE;

2: /* $Header: IGSNI83B.pls 115.10 2002/11/29 01:33:15 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_usr_aval_all%ROWTYPE;
6: new_references igs_pe_usr_aval_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 36: FROM IGS_PE_USR_AVAL_ALL

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

Line 144: FROM igs_pe_usr_aval_all

140: || (reverse chronological order - newest change first)
141: */
142: CURSOR cur_rowid IS
143: SELECT rowid
144: FROM igs_pe_usr_aval_all
145: WHERE usr_act_val_id = x_usr_act_val_id
146: FOR UPDATE NOWAIT;
147:
148: lv_rowid cur_rowid%RowType;

Line 180: FROM igs_pe_usr_aval_all

176: || (reverse chronological order - newest change first)
177: */
178: CURSOR cur_rowid IS
179: SELECT rowid
180: FROM igs_pe_usr_aval_all
181: WHERE person_type = x_person_type
182: AND validation = x_validation
183: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
184:

Line 216: FROM igs_pe_usr_aval_all

212: || (reverse chronological order - newest change first)
213: */
214: CURSOR cur_rowid IS
215: SELECT rowid
216: FROM igs_pe_usr_aval_all
217: WHERE ((person_type = x_person_type_code));
218:
219: lv_rowid cur_rowid%RowType;
220:

Line 337: FROM igs_pe_usr_aval_all

333: || (reverse chronological order - newest change first)
334: */
335: CURSOR c IS
336: SELECT rowid
337: FROM igs_pe_usr_aval_all
338: WHERE usr_act_val_id = x_usr_act_val_id;
339:
340: x_last_update_date DATE;
341: x_last_updated_by NUMBER;

Line 365: SELECT igs_pe_usr_aval_all_s.NEXTVAL

361: igs_ge_msg_stack.add;
362: app_exception.raise_exception;
363: END IF;
364:
365: SELECT igs_pe_usr_aval_all_s.NEXTVAL
366: INTO x_usr_act_val_id
367: FROM dual;
368:
369: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 387: INSERT INTO igs_pe_usr_aval_all (

383: x_override_ind => x_override_ind,
384: x_override_dt => x_override_dt
385: );
386:
387: INSERT INTO igs_pe_usr_aval_all (
388: usr_act_val_id,
389: person_type,
390: validation,
391: org_id,

Line 449: FROM igs_pe_usr_aval_all

445: CURSOR c1 IS
446: SELECT
447: person_type,
448: validation
449: FROM igs_pe_usr_aval_all
450: WHERE rowid = x_rowid
451: FOR UPDATE NOWAIT;
452:
453: tlinfo c1%ROWTYPE;

Line 545: UPDATE igs_pe_usr_aval_all

541: x_override_ind => x_override_ind,
542: x_override_dt => x_override_dt
543: );
544:
545: UPDATE igs_pe_usr_aval_all
546: SET
547: person_type = new_references.person_type,
548: validation = new_references.validation,
549: last_update_date = x_last_update_date,

Line 586: FROM igs_pe_usr_aval_all

582: || (reverse chronological order - newest change first)
583: */
584: CURSOR c1 IS
585: SELECT rowid
586: FROM igs_pe_usr_aval_all
587: WHERE usr_act_val_id = x_usr_act_val_id;
588:
589: BEGIN
590:

Line 643: DELETE FROM igs_pe_usr_aval_all

639: p_action => 'DELETE',
640: x_rowid => x_rowid
641: );
642:
643: DELETE FROM igs_pe_usr_aval_all
644: WHERE rowid = x_rowid;
645:
646: IF (SQL%NOTFOUND) THEN
647: RAISE NO_DATA_FOUND;