APPS.IGS_UC_APP_NAMES_PKG dependencies on IGS_UC_APP_NAMES

Line 1: PACKAGE BODY igs_uc_app_names_pkg AS

1: PACKAGE BODY igs_uc_app_names_pkg AS
2: /* $Header: IGSXI49B.pls 120.0 2005/06/01 17:36:50 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_app_names%ROWTYPE;

Line 5: old_references igs_uc_app_names%ROWTYPE;

1: PACKAGE BODY igs_uc_app_names_pkg AS
2: /* $Header: IGSXI49B.pls 120.0 2005/06/01 17:36:50 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_app_names%ROWTYPE;
6: new_references igs_uc_app_names%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_app_names%ROWTYPE;

2: /* $Header: IGSXI49B.pls 120.0 2005/06/01 17:36:50 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_app_names%ROWTYPE;
6: new_references igs_uc_app_names%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 38: FROM igs_uc_app_names

34: */
35:
36: CURSOR cur_old_ref_values IS
37: SELECT *
38: FROM igs_uc_app_names
39: WHERE rowid = x_rowid;
40:
41: BEGIN
42:

Line 148: FROM igs_uc_app_names

144: || (reverse chronological order - newest change first)
145: */
146: CURSOR cur_rowid IS
147: SELECT rowid
148: FROM igs_uc_app_names
149: WHERE app_no = x_app_no
150: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
151:
152: lv_rowid cur_rowid%RowType;

Line 183: FROM igs_uc_app_names

179: || (reverse chronological order - newest change first)
180: */
181: CURSOR cur_rowid IS
182: SELECT rowid
183: FROM igs_uc_app_names
184: WHERE ((app_no = x_app_no));
185:
186: lv_rowid cur_rowid%RowType;
187:

Line 315: fnd_message.set_token ('ROUTINE', 'IGS_UC_APP_NAMES_PKG.INSERT_ROW');

311: x_last_update_login := -1;
312: END IF;
313: ELSE
314: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
315: fnd_message.set_token ('ROUTINE', 'IGS_UC_APP_NAMES_PKG.INSERT_ROW');
316: igs_ge_msg_stack.add;
317: app_exception.raise_exception;
318: END IF;
319:

Line 339: INSERT INTO igs_uc_app_names (

335: x_last_updated_by => x_last_updated_by,
336: x_last_update_login => x_last_update_login
337: );
338:
339: INSERT INTO igs_uc_app_names (
340: app_no,
341: check_digit,
342: name_change_date,
343: title,

Line 406: FROM igs_uc_app_names

402: surname,
403: birth_date,
404: sex,
405: sent_to_oss_flag
406: FROM igs_uc_app_names
407: WHERE rowid = x_rowid
408: FOR UPDATE NOWAIT;
409:
410: tlinfo c1%ROWTYPE;

Line 491: fnd_message.set_token ('ROUTINE', 'IGS_UC_APP_NAMES_PKG.UPDATE_ROW');

487: x_last_update_login := -1;
488: END IF;
489: ELSE
490: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
491: fnd_message.set_token ('ROUTINE', 'IGS_UC_APP_NAMES_PKG.UPDATE_ROW');
492: igs_ge_msg_stack.add;
493: app_exception.raise_exception;
494: END IF;
495:

Line 515: UPDATE igs_uc_app_names

511: x_last_updated_by => x_last_updated_by,
512: x_last_update_login => x_last_update_login
513: );
514:
515: UPDATE igs_uc_app_names
516: SET
517: app_no = new_references.app_no,
518: check_digit = new_references.check_digit,
519: name_change_date = new_references.name_change_date,

Line 562: FROM igs_uc_app_names

558: || (reverse chronological order - newest change first)
559: */
560: CURSOR c1 IS
561: SELECT rowid
562: FROM igs_uc_app_names
563: WHERE app_no = x_app_no;
564:
565: BEGIN
566:

Line 625: DELETE FROM igs_uc_app_names

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

Line 635: END igs_uc_app_names_pkg;

631:
632: END delete_row;
633:
634:
635: END igs_uc_app_names_pkg;