APPS.IGS_AD_INTERFACE_PKG dependencies on IGS_AD_INTERFACE_ALL

Line 5: old_references igs_ad_interface_all%ROWTYPE;

1: PACKAGE BODY igs_ad_interface_pkg AS
2: /* $Header: IGSAIB3B.pls 120.2 2005/09/22 23:52:29 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_interface_all%ROWTYPE;
6: new_references igs_ad_interface_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_interface_all%ROWTYPE;

2: /* $Header: IGSAIB3B.pls 120.2 2005/09/22 23:52:29 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_interface_all%ROWTYPE;
6: new_references igs_ad_interface_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 85: FROM IGS_AD_INTERFACE_ALL

81: */
82:
83: CURSOR cur_old_ref_values IS
84: SELECT *
85: FROM IGS_AD_INTERFACE_ALL
86: WHERE rowid = x_rowid;
87:
88: BEGIN
89:

Line 277: FROM igs_ad_interface_all

273: ***************************************************************/
274:
275: CURSOR cur_rowid IS
276: SELECT rowid
277: FROM igs_ad_interface_all
278: WHERE interface_id = x_interface_id
279: FOR UPDATE NOWAIT;
280:
281: lv_rowid cur_rowid%RowType;

Line 545: FROM igs_ad_interface_all

541: || (reverse chronological order - newest change first)
542: */
543: CURSOR c IS
544: SELECT rowid
545: FROM igs_ad_interface_all
546: WHERE interface_id = x_interface_id;
547:
548: x_last_update_date DATE;
549: x_last_updated_by NUMBER;

Line 655: INSERT INTO igs_ad_interface_all (

651: x_attribute23 => x_attribute23,
652: x_attribute24 => x_attribute24
653: );
654:
655: INSERT INTO igs_ad_interface_all (
656: person_number,
657: org_id,
658: interface_id,
659: batch_id,

Line 927: FROM igs_ad_interface_all

923: attribute21,
924: attribute22,
925: attribute23,
926: attribute24
927: FROM igs_ad_interface_all
928: WHERE rowid = x_rowid
929: FOR UPDATE NOWAIT;
930:
931: tlinfo c1%ROWTYPE;

Line 1194: UPDATE igs_ad_interface_all

1190: x_program_update_date := SYSDATE;
1191: END IF;
1192: END IF;
1193:
1194: UPDATE igs_ad_interface_all
1195: SET
1196: person_number = new_references.person_number,
1197: interface_id = new_references.interface_id,
1198: batch_id = new_references.batch_id,

Line 1339: FROM igs_ad_interface_all

1335: || (reverse chronological order - newest change first)
1336: */
1337: CURSOR c1 IS
1338: SELECT rowid
1339: FROM igs_ad_interface_all
1340: WHERE interface_id = x_interface_id;
1341:
1342: BEGIN
1343:

Line 1496: DELETE FROM igs_ad_interface_all

1492: p_action => 'DELETE',
1493: x_rowid => x_rowid
1494: );
1495:
1496: DELETE FROM igs_ad_interface_all
1497: WHERE rowid = x_rowid;
1498:
1499: IF (SQL%NOTFOUND) THEN
1500: RAISE NO_DATA_FOUND;