APPS.IGF_AP_RECORD_MATCH_PKG dependencies on IGF_AP_RECORD_MATCH_ALL

Line 5: old_references igf_ap_record_match_all%ROWTYPE;

1: PACKAGE BODY igf_ap_record_match_pkg AS
2: /* $Header: IGFAI40B.pls 120.0 2005/06/01 14:49:26 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_record_match_all%ROWTYPE;
6: new_references igf_ap_record_match_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2 ,

Line 6: new_references igf_ap_record_match_all%ROWTYPE;

2: /* $Header: IGFAI40B.pls 120.0 2005/06/01 14:49:26 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_record_match_all%ROWTYPE;
6: new_references igf_ap_record_match_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2 ,
10: x_rowid IN VARCHAR2 ,

Line 53: FROM IGF_AP_RECORD_MATCH_ALL

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

Line 128: FROM igf_ap_record_match_all

124: || (reverse chronological order - newest change first)
125: */
126: CURSOR cur_rowid IS
127: SELECT rowid
128: FROM igf_ap_record_match_all
129: WHERE arm_id = x_arm_id
130: FOR UPDATE NOWAIT;
131:
132: lv_rowid cur_rowid%RowType;

Line 162: FROM igf_ap_record_match_all

158: || (reverse chronological order - newest change first)
159: */
160: CURSOR cur_rowid IS
161: SELECT rowid
162: FROM igf_ap_record_match_all
163: WHERE match_code = x_match_code
164: AND ((l_rowid IS NULL) OR (rowid <> l_rowid))
165: FOR UPDATE NOWAIT;
166:

Line 356: FROM igf_ap_record_match_all

352: || (reverse chronological order - newest change first)
353: */
354: CURSOR c IS
355: SELECT rowid
356: FROM igf_ap_record_match_all
357: WHERE arm_id = x_arm_id;
358:
359: x_last_update_date DATE;
360: x_last_updated_by NUMBER;

Line 384: SELECT igf_ap_record_match_all_s.NEXTVAL

380: igs_ge_msg_stack.add;
381: app_exception.raise_exception;
382: END IF;
383:
384: SELECT igf_ap_record_match_all_s.NEXTVAL
385: INTO x_arm_id
386: FROM dual;
387:
388: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 424: INSERT INTO igf_ap_record_match_all (

420: x_gender_mt_txt => x_gender_mt_txt,
421: x_email_mt_txt => x_email_mt_txt
422: );
423:
424: INSERT INTO igf_ap_record_match_all (
425: arm_id,
426: org_id,
427: ssn,
428: given_name,

Line 560: FROM igf_ap_record_match_all

556: city_mt_txt,
557: zip_mt_txt,
558: gender_mt_txt,
559: email_mt_txt
560: FROM igf_ap_record_match_all
561: WHERE rowid = x_rowid
562: FOR UPDATE NOWAIT;
563:
564: tlinfo c1%ROWTYPE;

Line 712: UPDATE igf_ap_record_match_all

708: x_gender_mt_txt => x_gender_mt_txt,
709: x_email_mt_txt => x_email_mt_txt
710: );
711:
712: UPDATE igf_ap_record_match_all
713: SET
714: ssn = new_references.ssn,
715: given_name = new_references.given_name,
716: surname = new_references.surname,

Line 788: FROM igf_ap_record_match_all

784: || (reverse chronological order - newest change first)
785: */
786: CURSOR c1 IS
787: SELECT rowid
788: FROM igf_ap_record_match_all
789: WHERE arm_id = x_arm_id;
790:
791: BEGIN
792:

Line 881: DELETE FROM igf_ap_record_match_all

877: p_action => 'DELETE',
878: x_rowid => x_rowid
879: );
880:
881: DELETE FROM igf_ap_record_match_all
882: WHERE rowid = x_rowid;
883:
884: IF (SQL%NOTFOUND) THEN
885: RAISE NO_DATA_FOUND;