APPS.IGF_AP_PERS_NOTE_PKG dependencies on IGF_AP_PERS_NOTE

Line 1: PACKAGE BODY igf_ap_pers_note_pkg AS

1: PACKAGE BODY igf_ap_pers_note_pkg AS
2: /* $Header: IGFAI43B.pls 115.7 2002/11/28 14:01:49 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_pers_note%ROWTYPE;

Line 5: old_references igf_ap_pers_note%ROWTYPE;

1: PACKAGE BODY igf_ap_pers_note_pkg AS
2: /* $Header: IGFAI43B.pls 115.7 2002/11/28 14:01:49 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_pers_note%ROWTYPE;
6: new_references igf_ap_pers_note%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2 ,

Line 6: new_references igf_ap_pers_note%ROWTYPE;

2: /* $Header: IGFAI43B.pls 115.7 2002/11/28 14:01:49 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_pers_note%ROWTYPE;
6: new_references igf_ap_pers_note%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2 ,
10: x_rowid IN VARCHAR2 ,

Line 34: FROM IGF_AP_PERS_NOTE

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

Line 132: FROM igf_ap_pers_note

128: || (reverse chronological order - newest change first)
129: */
130: CURSOR cur_rowid IS
131: SELECT rowid
132: FROM igf_ap_pers_note
133: WHERE reference_number = x_reference_number
134: FOR UPDATE NOWAIT;
135:
136: lv_rowid cur_rowid%RowType;

Line 169: FROM igf_ap_pers_note

165: || (reverse chronological order - newest change first)
166: */
167: CURSOR cur_rowid IS
168: SELECT rowid
169: FROM igf_ap_pers_note
170: WHERE ((pe_note_type = x_pe_note_type));
171:
172: lv_rowid cur_rowid%RowType;
173:

Line 206: FROM igf_ap_pers_note

202: || (reverse chronological order - newest change first)
203: */
204: CURSOR cur_rowid IS
205: SELECT rowid
206: FROM igf_ap_pers_note
207: WHERE ((base_id = x_base_id));
208:
209: lv_rowid cur_rowid%RowType;
210:

Line 317: FROM igf_ap_pers_note

313: || (reverse chronological order - newest change first)
314: */
315: CURSOR c IS
316: SELECT rowid
317: FROM igf_ap_pers_note
318: WHERE reference_number = x_reference_number;
319:
320: x_last_update_date DATE;
321: x_last_updated_by NUMBER;

Line 361: INSERT INTO igf_ap_pers_note (

357: x_last_updated_by => x_last_updated_by,
358: x_last_update_login => x_last_update_login
359: );
360:
361: INSERT INTO igf_ap_pers_note (
362: reference_number,
363: base_id,
364: pe_note_type,
365: short_desc,

Line 419: FROM igf_ap_pers_note

415: base_id,
416: pe_note_type,
417: short_desc,
418: rec_resp
419: FROM igf_ap_pers_note
420: WHERE rowid = x_rowid
421: FOR UPDATE NOWAIT;
422:
423: tlinfo c1%ROWTYPE;

Line 514: UPDATE igf_ap_pers_note

510: x_last_updated_by => x_last_updated_by,
511: x_last_update_login => x_last_update_login
512: );
513:
514: UPDATE igf_ap_pers_note
515: SET
516: base_id = new_references.base_id,
517: pe_note_type = new_references.pe_note_type,
518: short_desc = new_references.short_desc,

Line 552: FROM igf_ap_pers_note

548: || (reverse chronological order - newest change first)
549: */
550: CURSOR c1 IS
551: SELECT rowid
552: FROM igf_ap_pers_note
553: WHERE reference_number = x_reference_number;
554:
555: BEGIN
556:

Line 607: DELETE FROM igf_ap_pers_note

603: p_action => 'DELETE',
604: x_rowid => x_rowid
605: );
606:
607: DELETE FROM igf_ap_pers_note
608: WHERE rowid = x_rowid;
609:
610: IF (SQL%NOTFOUND) THEN
611: RAISE NO_DATA_FOUND;

Line 617: END igf_ap_pers_note_pkg;

613:
614: END delete_row;
615:
616:
617: END igf_ap_pers_note_pkg;