APPS.IGS_AS_ANON_ID_ASS_PKG dependencies on IGS_AS_ANON_ID_ASS

Line 1: PACKAGE BODY igs_as_anon_id_ass_pkg AS

1: PACKAGE BODY igs_as_anon_id_ass_pkg AS
2: /* $Header: IGSDI63B.pls 115.1 2002/11/28 23:26:43 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_anon_id_ass%ROWTYPE;

Line 5: old_references igs_as_anon_id_ass%ROWTYPE;

1: PACKAGE BODY igs_as_anon_id_ass_pkg AS
2: /* $Header: IGSDI63B.pls 115.1 2002/11/28 23:26:43 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_anon_id_ass%ROWTYPE;
6: new_references igs_as_anon_id_ass%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_as_anon_id_ass%ROWTYPE;

2: /* $Header: IGSDI63B.pls 115.1 2002/11/28 23:26:43 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_anon_id_ass%ROWTYPE;
6: new_references igs_as_anon_id_ass%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM igs_as_anon_id_ass

31: */
32:
33: CURSOR cur_old_ref_values IS
34: SELECT *
35: FROM igs_as_anon_id_ass
36: WHERE rowid = x_rowid;
37:
38: BEGIN
39:

Line 93: FROM igs_as_anon_id_ass

89: || (reverse chronological order - newest change first)
90: */
91: CURSOR cur_rowid IS
92: SELECT rowid
93: FROM igs_as_anon_id_ass
94: WHERE anonymous_id = x_anonymous_id
95: AND load_cal_type = x_load_cal_type
96: AND load_ci_sequence_number = x_load_ci_sequence_number
97: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 199: FROM igs_as_anon_id_ass

195: || (reverse chronological order - newest change first)
196: */
197: CURSOR cur_rowid IS
198: SELECT rowid
199: FROM igs_as_anon_id_ass
200: WHERE person_id = x_person_id
201: AND assessment_type = x_assessment_type
202: AND load_cal_type = x_load_cal_type
203: AND load_ci_sequence_number = x_load_ci_sequence_number

Line 237: FROM igs_as_anon_id_ass

233: || (reverse chronological order - newest change first)
234: */
235: CURSOR cur_rowid IS
236: SELECT rowid
237: FROM igs_as_anon_id_ass
238: WHERE ((assessment_type = x_assessment_type));
239:
240: lv_rowid cur_rowid%RowType;
241:

Line 273: FROM igs_as_anon_id_ass

269: || (reverse chronological order - newest change first)
270: */
271: CURSOR cur_rowid IS
272: SELECT rowid
273: FROM igs_as_anon_id_ass
274: WHERE ((load_cal_type = x_cal_type) AND
275: (load_ci_sequence_number = x_sequence_number));
276:
277: lv_rowid cur_rowid%RowType;

Line 399: FROM igs_as_anon_id_ass

395: || (reverse chronological order - newest change first)
396: */
397: CURSOR c IS
398: SELECT rowid
399: FROM igs_as_anon_id_ass
400: WHERE person_id = x_person_id
401: AND assessment_type = x_assessment_type
402: AND load_cal_type = x_load_cal_type
403: AND load_ci_sequence_number = x_load_ci_sequence_number;

Line 462: INSERT INTO igs_as_anon_id_ass (

458: x_last_updated_by => x_last_updated_by,
459: x_last_update_login => x_last_update_login
460: );
461:
462: INSERT INTO igs_as_anon_id_ass (
463: person_id,
464: anonymous_id,
465: system_generated_ind,
466: assessment_type,

Line 529: FROM igs_as_anon_id_ass

525: CURSOR c1 IS
526: SELECT
527: anonymous_id,
528: system_generated_ind
529: FROM igs_as_anon_id_ass
530: WHERE rowid = x_rowid
531: FOR UPDATE NOWAIT;
532:
533: tlinfo c1%ROWTYPE;

Line 642: UPDATE igs_as_anon_id_ass

638: x_program_update_date := SYSDATE;
639: END IF;
640: END IF;
641:
642: UPDATE igs_as_anon_id_ass
643: SET
644: anonymous_id = new_references.anonymous_id,
645: system_generated_ind = new_references.system_generated_ind,
646: last_update_date = x_last_update_date,

Line 683: FROM igs_as_anon_id_ass

679: || (reverse chronological order - newest change first)
680: */
681: CURSOR c1 IS
682: SELECT rowid
683: FROM igs_as_anon_id_ass
684: WHERE person_id = x_person_id
685: AND assessment_type = x_assessment_type
686: AND load_cal_type = x_load_cal_type
687: AND load_ci_sequence_number = x_load_ci_sequence_number;

Line 743: DELETE FROM igs_as_anon_id_ass

739: p_action => 'DELETE',
740: x_rowid => x_rowid
741: );
742:
743: DELETE FROM igs_as_anon_id_ass
744: WHERE rowid = x_rowid;
745:
746: IF (SQL%NOTFOUND) THEN
747: RAISE NO_DATA_FOUND;

Line 753: END igs_as_anon_id_ass_pkg;

749:
750: END delete_row;
751:
752:
753: END igs_as_anon_id_ass_pkg;