APPS.IGS_AD_IMP_NEAR_MTCH_PKG dependencies on IGS_AD_IMP_NEAR_MTCH_ALL

Line 4: old_references igs_ad_imp_near_mtch_all%RowType;

1: PACKAGE BODY igs_ad_imp_near_mtch_pkg AS
2: /* $Header: IGSAIB2B.pls 115.19 2003/05/22 13:17:56 npalanis ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_imp_near_mtch_all%RowType;
5: new_references igs_ad_imp_near_mtch_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ad_imp_near_mtch_all%RowType;

1: PACKAGE BODY igs_ad_imp_near_mtch_pkg AS
2: /* $Header: IGSAIB2B.pls 115.19 2003/05/22 13:17:56 npalanis ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_imp_near_mtch_all%RowType;
5: new_references igs_ad_imp_near_mtch_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 41: FROM IGS_AD_IMP_NEAR_MTCH_ALL

37: ***************************************************************/
38:
39: CURSOR cur_old_ref_values IS
40: SELECT *
41: FROM IGS_AD_IMP_NEAR_MTCH_ALL
42: WHERE rowid = x_rowid;
43:
44: BEGIN
45:

Line 213: FROM igs_ad_imp_near_mtch_all

209: ***************************************************************/
210:
211: CURSOR cur_rowid IS
212: SELECT rowid
213: FROM igs_ad_imp_near_mtch_all
214: WHERE near_mtch_id = x_near_mtch_id
215: FOR UPDATE NOWAIT;
216:
217: lv_rowid cur_rowid%RowType;

Line 249: FROM igs_ad_imp_near_mtch_all

245: ***************************************************************/
246:
247: CURSOR cur_rowid IS
248: SELECT rowid
249: FROM igs_ad_imp_near_mtch_all
250: WHERE interface_id = x_interface_id ;
251:
252: lv_rowid cur_rowid%RowType;
253:

Line 286: FROM igs_ad_imp_near_mtch_all

282: ***************************************************************/
283:
284: CURSOR cur_rowid IS
285: SELECT rowid
286: FROM igs_ad_imp_near_mtch_all
287: WHERE addr_type = x_addr_type ;
288:
289: lv_rowid cur_rowid%RowType;
290:

Line 323: FROM igs_ad_imp_near_mtch_all

319: ***************************************************************/
320:
321: CURSOR cur_rowid IS
322: SELECT rowid
323: FROM igs_ad_imp_near_mtch_all
324: WHERE match_set_id = x_match_set_id ;
325:
326: lv_rowid cur_rowid%RowType;
327:

Line 360: FROM igs_ad_imp_near_mtch_all

356: ***************************************************************/
357:
358: CURSOR cur_rowid IS
359: SELECT rowid
360: FROM igs_ad_imp_near_mtch_all
361: WHERE person_id = x_person_id ;
362:
363: lv_rowid cur_rowid%RowType;
364:

Line 530: cursor C is select ROWID from IGS_AD_IMP_NEAR_MTCH_ALL

526:
527: (reverse chronological order - newest change first)
528: ***************************************************************/
529:
530: cursor C is select ROWID from IGS_AD_IMP_NEAR_MTCH_ALL
531: where NEAR_MTCH_ID= X_NEAR_MTCH_ID;
532: X_LAST_UPDATE_DATE DATE ;
533: X_LAST_UPDATED_BY NUMBER ;
534: X_LAST_UPDATE_LOGIN NUMBER ;

Line 591: insert into IGS_AD_IMP_NEAR_MTCH_ALL (

587: x_last_update_login=>X_LAST_UPDATE_LOGIN,
588: x_party_site_id => X_PARTY_SITE_ID,
589: x_interface_relations_id => X_INTERFACE_RELATIONS_ID);
590:
591: insert into IGS_AD_IMP_NEAR_MTCH_ALL (
592: NEAR_MTCH_ID
593: ,INTERFACE_ID
594: ,PERSON_ID
595: ,ORG_ID

Line 683: from IGS_AD_IMP_NEAR_MTCH_ALL

679: PERSON_ID_TYPE,
680: MATCH_SET_ID,
681: PARTY_SITE_ID,
682: INTERFACE_RELATIONS_ID
683: from IGS_AD_IMP_NEAR_MTCH_ALL
684: where ROWID = X_ROWID
685: for update nowait;
686:
687: tlinfo c1%rowtype;

Line 807: update IGS_AD_IMP_NEAR_MTCH_ALL set

803: X_PROGRAM_UPDATE_DATE := SYSDATE;
804: end if;
805: end if;
806:
807: update IGS_AD_IMP_NEAR_MTCH_ALL set
808: INTERFACE_ID = NEW_REFERENCES.INTERFACE_ID,
809: PERSON_ID = NEW_REFERENCES.PERSON_ID,
810: MATCH_IND = NEW_REFERENCES.MATCH_IND,
811: ACTION = NEW_REFERENCES.ACTION,

Line 863: cursor c1 is select ROWID from IGS_AD_IMP_NEAR_MTCH_ALL

859:
860: (reverse chronological order - newest change first)
861: ***************************************************************/
862:
863: cursor c1 is select ROWID from IGS_AD_IMP_NEAR_MTCH_ALL
864: where NEAR_MTCH_ID= X_NEAR_MTCH_ID;
865: begin
866: open c1;
867: fetch c1 into X_ROWID;

Line 924: delete from IGS_AD_IMP_NEAR_MTCH_ALL

920: p_action => 'DELETE',
921: x_rowid => X_ROWID
922: );
923:
924: delete from IGS_AD_IMP_NEAR_MTCH_ALL
925: where ROWID = X_ROWID;
926: if (sql%notfound) then
927: raise no_data_found;
928: end if;