APPS.IGS_PE_DUP_PAIRS_PKG dependencies on IGS_PE_DUP_PAIRS_ALL

Line 4: old_references IGS_PE_DUP_PAIRS_ALL%RowType;

1: PACKAGE BODY igs_pe_dup_pairs_pkg AS
2: /* $Header: IGSNI68B.pls 115.9 2002/11/29 01:29:17 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PE_DUP_PAIRS_ALL%RowType;
5: new_references IGS_PE_DUP_PAIRS_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_PE_DUP_PAIRS_ALL%RowType;

1: PACKAGE BODY igs_pe_dup_pairs_pkg AS
2: /* $Header: IGSNI68B.pls 115.9 2002/11/29 01:29:17 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PE_DUP_PAIRS_ALL%RowType;
5: new_references IGS_PE_DUP_PAIRS_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 47: FROM IGS_PE_DUP_PAIRS_ALL

43: ***************************************************************/
44:
45: CURSOR cur_old_ref_values IS
46: SELECT *
47: FROM IGS_PE_DUP_PAIRS_ALL
48: WHERE rowid = x_rowid;
49:
50: BEGIN
51:

Line 158: FROM IGS_PE_DUP_PAIRS_ALL

154: ***************************************************************/
155:
156: CURSOR cur_rowid IS
157: SELECT rowid
158: FROM IGS_PE_DUP_PAIRS_ALL
159: WHERE duplicate_pair_id = x_duplicate_pair_id
160: FOR UPDATE NOWAIT;
161:
162: lv_rowid cur_rowid%RowType;

Line 341: cursor C is select ROWID from IGS_PE_DUP_PAIRS_ALL

337:
338: (reverse chronological order - newest change first)
339: ***************************************************************/
340:
341: cursor C is select ROWID from IGS_PE_DUP_PAIRS_ALL
342: where DUPLICATE_PAIR_ID= X_DUPLICATE_PAIR_ID
343: ;
344: X_LAST_UPDATE_DATE DATE ;
345: X_LAST_UPDATED_BY NUMBER ;

Line 406: insert into IGS_PE_DUP_PAIRS_ALL (

402: x_created_by=>X_LAST_UPDATED_BY,
403: x_last_update_date=>X_LAST_UPDATE_DATE,
404: x_last_updated_by=>X_LAST_UPDATED_BY,
405: x_last_update_login=>X_LAST_UPDATE_LOGIN);
406: insert into IGS_PE_DUP_PAIRS_ALL (
407: DUPLICATE_PAIR_ID
408: ,BATCH_ID
409: ,MATCH_SET_ID
410: ,ACTUAL_PERSON_ID

Line 504: from IGS_PE_DUP_PAIRS_ALL

500: , DUP_STATUS
501: , ADDRESS_TYPE
502: , LOCATION_ID
503: , PERSON_ID_TYPE
504: from IGS_PE_DUP_PAIRS_ALL
505: where ROWID = X_ROWID
506: for update nowait;
507: tlinfo c1%rowtype;
508: begin

Line 639: update IGS_PE_DUP_PAIRS_ALL set

635: end if;
636: end if;
637:
638:
639: update IGS_PE_DUP_PAIRS_ALL set
640: BATCH_ID = NEW_REFERENCES.BATCH_ID,
641: MATCH_SET_ID = NEW_REFERENCES.MATCH_SET_ID,
642: ACTUAL_PERSON_ID = NEW_REFERENCES.ACTUAL_PERSON_ID,
643: DUPLICATE_PERSON_ID = NEW_REFERENCES.DUPLICATE_PERSON_ID,

Line 700: cursor c1 is select ROWID from IGS_PE_DUP_PAIRS_ALL

696:
697: (reverse chronological order - newest change first)
698: ***************************************************************/
699:
700: cursor c1 is select ROWID from IGS_PE_DUP_PAIRS_ALL
701: where DUPLICATE_PAIR_ID= X_DUPLICATE_PAIR_ID
702: ;
703: begin
704: open c1;

Line 765: delete from IGS_PE_DUP_PAIRS_ALL

761: Before_DML (
762: p_action => 'DELETE',
763: x_rowid => X_ROWID
764: );
765: delete from IGS_PE_DUP_PAIRS_ALL
766: where ROWID = X_ROWID;
767: if (sql%notfound) then
768: raise no_data_found;
769: end if;