APPS.IGS_UC_APP_ADDRESES_PKG dependencies on IGS_UC_APP_ADDRESES

Line 1: PACKAGE BODY igs_uc_app_addreses_pkg AS

1: PACKAGE BODY igs_uc_app_addreses_pkg AS
2: /* $Header: IGSXI50B.pls 120.1 2006/08/21 03:37:17 jbaber noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_app_addreses%ROWTYPE;

Line 5: old_references igs_uc_app_addreses%ROWTYPE;

1: PACKAGE BODY igs_uc_app_addreses_pkg AS
2: /* $Header: IGSXI50B.pls 120.1 2006/08/21 03:37:17 jbaber noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_app_addreses%ROWTYPE;
6: new_references igs_uc_app_addreses%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_app_addreses%ROWTYPE;

2: /* $Header: IGSXI50B.pls 120.1 2006/08/21 03:37:17 jbaber noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_app_addreses%ROWTYPE;
6: new_references igs_uc_app_addreses%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 54: FROM igs_uc_app_addreses

50: */
51:
52: CURSOR cur_old_ref_values IS
53: SELECT *
54: FROM igs_uc_app_addreses
55: WHERE rowid = x_rowid;
56:
57: BEGIN
58:

Line 180: FROM igs_uc_app_addreses

176: || (reverse chronological order - newest change first)
177: */
178: CURSOR cur_rowid IS
179: SELECT rowid
180: FROM igs_uc_app_addreses
181: WHERE app_no = x_app_no
182: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
183:
184: lv_rowid cur_rowid%RowType;

Line 215: FROM igs_uc_app_addreses

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

Line 395: fnd_message.set_token ('ROUTINE', 'IGS_UC_APP_ADDRESES_PKG.INSERT_ROW');

391: x_last_update_login := -1;
392: END IF;
393: ELSE
394: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
395: fnd_message.set_token ('ROUTINE', 'IGS_UC_APP_ADDRESES_PKG.INSERT_ROW');
396: igs_ge_msg_stack.add;
397: app_exception.raise_exception;
398: END IF;
399:

Line 435: INSERT INTO igs_uc_app_addreses (

431: x_last_updated_by => x_last_updated_by,
432: x_last_update_login => x_last_update_login
433: );
434:
435: INSERT INTO igs_uc_app_addreses (
436: app_no,
437: address_area,
438: address1,
439: address2,

Line 566: FROM igs_uc_app_addreses

562: ad_interface_id,
563: mobile,
564: country_code,
565: home_country_code
566: FROM igs_uc_app_addreses
567: WHERE rowid = x_rowid
568: FOR UPDATE NOWAIT;
569:
570: tlinfo c1%ROWTYPE;

Line 683: fnd_message.set_token ('ROUTINE', 'IGS_UC_APP_ADDRESES_PKG.UPDATE_ROW');

679: x_last_update_login := -1;
680: END IF;
681: ELSE
682: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
683: fnd_message.set_token ('ROUTINE', 'IGS_UC_APP_ADDRESES_PKG.UPDATE_ROW');
684: igs_ge_msg_stack.add;
685: app_exception.raise_exception;
686: END IF;
687:

Line 723: UPDATE igs_uc_app_addreses

719: x_last_updated_by => x_last_updated_by,
720: x_last_update_login => x_last_update_login
721: );
722:
723: UPDATE igs_uc_app_addreses
724: SET
725: app_no = new_references.app_no,
726: address_area = new_references.address_area,
727: address1 = new_references.address1,

Line 802: FROM igs_uc_app_addreses

798: || (reverse chronological order - newest change first)
799: */
800: CURSOR c1 IS
801: SELECT rowid
802: FROM igs_uc_app_addreses
803: WHERE app_no = x_app_no;
804:
805: BEGIN
806:

Line 897: DELETE FROM igs_uc_app_addreses

893: p_action => 'DELETE',
894: x_rowid => x_rowid
895: );
896:
897: DELETE FROM igs_uc_app_addreses
898: WHERE rowid = x_rowid;
899:
900: IF (SQL%NOTFOUND) THEN
901: RAISE NO_DATA_FOUND;

Line 907: END igs_uc_app_addreses_pkg;

903:
904: END delete_row;
905:
906:
907: END igs_uc_app_addreses_pkg;