APPS.IGS_PE_USR_ARG_PKG dependencies on IGS_PE_USR_ARG_ALL

Line 5: old_references igs_pe_usr_arg_all%ROWTYPE;

1: PACKAGE BODY igs_pe_usr_arg_pkg AS
2: /* $Header: IGSNI82B.pls 120.3 2006/01/18 23:23:45 skpandey ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_usr_arg_all%ROWTYPE;
6: new_references igs_pe_usr_arg_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pe_usr_arg_all%ROWTYPE;

2: /* $Header: IGSNI82B.pls 120.3 2006/01/18 23:23:45 skpandey ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_usr_arg_all%ROWTYPE;
6: new_references igs_pe_usr_arg_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGS_PE_USR_ARG_ALL

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

Line 186: FROM igs_pe_usr_arg_all

182: || (reverse chronological order - newest change first)
183: */
184: CURSOR cur_rowid IS
185: SELECT rowid
186: FROM igs_pe_usr_arg_all
187: WHERE usr_act_re_gs_id = x_usr_act_re_gs_id
188: FOR UPDATE NOWAIT;
189:
190: lv_rowid cur_rowid%RowType;

Line 225: FROM igs_pe_usr_arg_all

221: */
222:
223: CURSOR cur_rowid IS
224: SELECT rowid
225: FROM igs_pe_usr_arg_all
226: WHERE person_type = x_person_type
227: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
228:
229: lv_rowid cur_rowid%RowType;

Line 260: FROM igs_pe_usr_arg_all

256: || (reverse chronological order - newest change first)
257: */
258: CURSOR cur_rowid IS
259: SELECT rowid
260: FROM igs_pe_usr_arg_all
261: WHERE ((person_type = x_person_type_code));
262:
263: lv_rowid cur_rowid%RowType;
264:

Line 379: FROM igs_pe_usr_arg_all

375: || (reverse chronological order - newest change first)
376: */
377: CURSOR c IS
378: SELECT rowid
379: FROM igs_pe_usr_arg_all
380: WHERE usr_act_re_gs_id = x_usr_act_re_gs_id;
381:
382: x_last_update_date DATE;
383: x_last_updated_by NUMBER;

Line 407: SELECT igs_pe_usr_arg_all_s.NEXTVAL

403: igs_ge_msg_stack.add;
404: app_exception.raise_exception;
405: END IF;
406:
407: SELECT igs_pe_usr_arg_all_s.NEXTVAL
408: INTO x_usr_act_re_gs_id
409: FROM dual;
410:
411: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 430: INSERT INTO igs_pe_usr_arg_all (

426: x_last_update_login => x_last_update_login
427: );
428:
429:
430: INSERT INTO igs_pe_usr_arg_all (
431: usr_act_re_gs_id,
432: person_type,
433: record_open_dt_alias,
434: record_cutoff_dt_alias,

Line 486: || is changed to base table,igs_pe_usr_arg_all

482: || Known limitations, enhancements or remarks :
483: || Change History :
484: || Who When What
485: ||ayedubat 25/6/2001 In the cursor select statement ,view igs_pe_usr_arg
486: || is changed to base table,igs_pe_usr_arg_all
487: || (reverse chronological order - newest change first)
488: */
489: CURSOR c1 IS
490: SELECT

Line 496: FROM igs_pe_usr_arg_all

492: record_open_dt_alias,
493: record_cutoff_dt_alias,
494: grad_sch_dt_alias,
495: upd_audit_dt_alias
496: FROM igs_pe_usr_arg_all
497: WHERE rowid = x_rowid
498: FOR UPDATE NOWAIT;
499:
500: tlinfo c1%ROWTYPE;

Line 594: UPDATE igs_pe_usr_arg_all

590: x_last_updated_by => x_last_updated_by,
591: x_last_update_login => x_last_update_login
592: );
593:
594: UPDATE igs_pe_usr_arg_all
595: SET
596: person_type = new_references.person_type,
597: record_open_dt_alias = new_references.record_open_dt_alias,
598: record_cutoff_dt_alias = new_references.record_cutoff_dt_alias,

Line 634: FROM igs_pe_usr_arg_all

630: || (reverse chronological order - newest change first)
631: */
632: CURSOR c1 IS
633: SELECT rowid
634: FROM igs_pe_usr_arg_all
635: WHERE usr_act_re_gs_id = x_usr_act_re_gs_id;
636:
637: BEGIN
638:

Line 691: DELETE FROM igs_pe_usr_arg_all

687: p_action => 'DELETE',
688: x_rowid => x_rowid
689: );
690:
691: DELETE FROM igs_pe_usr_arg_all
692: WHERE rowid = x_rowid;
693:
694: IF (SQL%NOTFOUND) THEN
695: RAISE NO_DATA_FOUND;