APPS.IGS_UC_ENQ_DETAILS_PKG dependencies on IGS_UC_ENQ_DETAILS

Line 1: PACKAGE BODY igs_uc_enq_details_pkg AS

1: PACKAGE BODY igs_uc_enq_details_pkg AS
2: /* $Header: IGSXI42B.pls 115.5 2003/02/28 07:51:45 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_enq_details%ROWTYPE;

Line 5: old_references igs_uc_enq_details%ROWTYPE;

1: PACKAGE BODY igs_uc_enq_details_pkg AS
2: /* $Header: IGSXI42B.pls 115.5 2003/02/28 07:51:45 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_enq_details%ROWTYPE;
6: new_references igs_uc_enq_details%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_enq_details%ROWTYPE;

2: /* $Header: IGSXI42B.pls 115.5 2003/02/28 07:51:45 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_enq_details%ROWTYPE;
6: new_references igs_uc_enq_details%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 43: FROM igs_uc_enq_details

39: */
40:
41: CURSOR cur_old_ref_values IS
42: SELECT *
43: FROM igs_uc_enq_details
44: WHERE rowid = x_rowid;
45:
46: BEGIN
47:

Line 108: FROM igs_uc_enq_details

104: || (reverse chronological order - newest change first)
105: */
106: CURSOR cur_rowid IS
107: SELECT rowid
108: FROM igs_uc_enq_details
109: WHERE app_no = x_app_no ;
110:
111: lv_rowid cur_rowid%RowType;
112:

Line 289: INSERT INTO igs_uc_enq_details (

285: x_last_updated_by => x_last_updated_by,
286: x_last_update_login => x_last_update_login
287: );
288:
289: INSERT INTO igs_uc_enq_details (
290: app_no,
291: surname,
292: given_names,
293: sex,

Line 375: FROM igs_uc_enq_details

371: country,
372: postcode,
373: email,
374: telephone
375: FROM igs_uc_enq_details
376: WHERE rowid = x_rowid
377: FOR UPDATE NOWAIT;
378:
379: tlinfo c1%ROWTYPE;

Line 497: UPDATE igs_uc_enq_details

493: x_last_updated_by => x_last_updated_by,
494: x_last_update_login => x_last_update_login
495: );
496:
497: UPDATE igs_uc_enq_details
498: SET
499: surname = new_references.surname,
500: given_names = new_references.given_names,
501: sex = new_references.sex,

Line 553: FROM igs_uc_enq_details

549: || (reverse chronological order - newest change first)
550: */
551: CURSOR c1 IS
552: SELECT rowid
553: FROM igs_uc_enq_details
554: WHERE app_no = x_app_no;
555:
556: BEGIN
557:

Line 626: DELETE FROM igs_uc_enq_details

622: p_action => 'DELETE',
623: x_rowid => x_rowid
624: );
625:
626: DELETE FROM igs_uc_enq_details
627: WHERE rowid = x_rowid;
628:
629: IF (SQL%NOTFOUND) THEN
630: RAISE NO_DATA_FOUND;

Line 636: END igs_uc_enq_details_pkg;

632:
633: END delete_row;
634:
635:
636: END igs_uc_enq_details_pkg;