APPS.IGF_AP_MATCH_DETAILS_PKG dependencies on IGF_AP_MATCH_DETAILS

Line 1: PACKAGE BODY igf_ap_match_details_pkg AS

1: PACKAGE BODY igf_ap_match_details_pkg AS
2: /* $Header: IGFAI38B.pls 120.0 2005/06/02 15:55:31 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_match_details%ROWTYPE;

Line 5: old_references igf_ap_match_details%ROWTYPE;

1: PACKAGE BODY igf_ap_match_details_pkg AS
2: /* $Header: IGFAI38B.pls 120.0 2005/06/02 15:55:31 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_match_details%ROWTYPE;
6: new_references igf_ap_match_details%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2 ,

Line 6: new_references igf_ap_match_details%ROWTYPE;

2: /* $Header: IGFAI38B.pls 120.0 2005/06/02 15:55:31 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_match_details%ROWTYPE;
6: new_references igf_ap_match_details%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2 ,
10: x_rowid IN VARCHAR2 ,

Line 52: FROM IGF_AP_MATCH_DETAILS

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

Line 153: FROM igf_ap_match_details

149: || (reverse chronological order - newest change first)
150: */
151: CURSOR cur_rowid IS
152: SELECT rowid
153: FROM igf_ap_match_details
154: WHERE amd_id = x_amd_id
155: FOR UPDATE NOWAIT;
156:
157: lv_rowid cur_rowid%RowType;

Line 188: FROM igf_ap_match_details

184: || (reverse chronological order - newest change first)
185: */
186: CURSOR cur_rowid IS
187: SELECT rowid
188: FROM igf_ap_match_details
189: WHERE ((apm_id = x_apm_id));
190:
191: lv_rowid cur_rowid%RowType;
192:

Line 353: FROM igf_ap_match_details

349: || (reverse chronological order - newest change first)
350: */
351: CURSOR c IS
352: SELECT rowid
353: FROM igf_ap_match_details
354: WHERE amd_id = x_amd_id;
355:
356: x_last_update_date DATE;
357: x_last_updated_by NUMBER;

Line 381: SELECT igf_ap_match_details_s.NEXTVAL

377: igs_ge_msg_stack.add;
378: app_exception.raise_exception;
379: END IF;
380:
381: SELECT igf_ap_match_details_s.NEXTVAL
382: INTO x_amd_id
383: FROM dual;
384:
385: before_dml(

Line 418: INSERT INTO igf_ap_match_details (

414: x_email_id_match => x_email_id_match,
415: x_gender_match => x_gender_match
416: );
417:
418: INSERT INTO igf_ap_match_details (
419: amd_id,
420: apm_id,
421: person_id,
422: ssn_match,

Line 548: FROM igf_ap_match_details

544: gender_txt,
545: email_id_txt,
546: email_id_match,
547: gender_match
548: FROM igf_ap_match_details
549: WHERE rowid = x_rowid
550: FOR UPDATE NOWAIT;
551:
552: tlinfo c1%ROWTYPE;

Line 697: UPDATE igf_ap_match_details

693: x_email_id_match => x_email_id_match,
694: x_gender_match => x_gender_match
695: );
696:
697: UPDATE igf_ap_match_details
698: SET
699: apm_id = new_references.apm_id,
700: person_id = new_references.person_id,
701: ssn_match = new_references.ssn_match,

Line 772: FROM igf_ap_match_details

768: || (reverse chronological order - newest change first)
769: */
770: CURSOR c1 IS
771: SELECT rowid
772: FROM igf_ap_match_details
773: WHERE amd_id = x_amd_id;
774:
775: BEGIN
776:

Line 863: DELETE FROM igf_ap_match_details

859: p_action => 'DELETE',
860: x_rowid => x_rowid
861: );
862:
863: DELETE FROM igf_ap_match_details
864: WHERE rowid = x_rowid;
865:
866: IF (SQL%NOTFOUND) THEN
867: RAISE NO_DATA_FOUND;

Line 873: END igf_ap_match_details_pkg;

869:
870: END delete_row;
871:
872:
873: END igf_ap_match_details_pkg;