APPS.IGS_AD_PNMEMBR_NOTS_PKG dependencies on IGS_AD_PNMEMBR_NOTS

Line 1: PACKAGE BODY igs_ad_pnmembr_nots_pkg AS

1: PACKAGE BODY igs_ad_pnmembr_nots_pkg AS
2: /* $Header: IGSAIH3B.pls 120.0 2005/06/01 21:22:42 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_pnmembr_nots%ROWTYPE;

Line 5: old_references igs_ad_pnmembr_nots%ROWTYPE;

1: PACKAGE BODY igs_ad_pnmembr_nots_pkg AS
2: /* $Header: IGSAIH3B.pls 120.0 2005/06/01 21:22:42 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_pnmembr_nots%ROWTYPE;
6: new_references igs_ad_pnmembr_nots%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_pnmembr_nots%ROWTYPE;

2: /* $Header: IGSAIH3B.pls 120.0 2005/06/01 21:22:42 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_pnmembr_nots%ROWTYPE;
6: new_references igs_ad_pnmembr_nots%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 33: FROM igs_ad_pnmembr_nots

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

Line 119: FROM igs_ad_pnmembr_nots

115: || (reverse chronological order - newest change first)
116: */
117: CURSOR cur_rowid IS
118: SELECT rowid
119: FROM igs_ad_pnmembr_nots
120: WHERE panel_dtls_id = x_panel_dtls_id
121: AND member_person_id = x_member_person_id
122: AND notes_version_num = x_notes_version_num
123: FOR UPDATE NOWAIT;

Line 157: FROM igs_ad_pnmembr_nots

153: || (reverse chronological order - newest change first)
154: */
155: CURSOR cur_rowid IS
156: SELECT rowid
157: FROM igs_ad_pnmembr_nots
158: WHERE ((member_person_id = x_member_person_id) AND
159: (panel_dtls_id = x_panel_dtls_id));
160:
161: lv_rowid cur_rowid%RowType;

Line 169: fnd_message.set_name ('IGS', 'IGS_AD_PNMEMBR_NOTS_FK');

165: OPEN cur_rowid;
166: FETCH cur_rowid INTO lv_rowid;
167: IF (cur_rowid%FOUND) THEN
168: CLOSE cur_rowid;
169: fnd_message.set_name ('IGS', 'IGS_AD_PNMEMBR_NOTS_FK');
170: igs_ge_msg_stack.add;
171: app_exception.raise_exception;
172: RETURN;
173: END IF;

Line 290: fnd_message.set_token ('ROUTINE', 'IGS_AD_PNMEMBR_NOTS_PKG.INSERT_ROW');

286: x_last_update_login := -1;
287: END IF;
288: ELSE
289: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
290: fnd_message.set_token ('ROUTINE', 'IGS_AD_PNMEMBR_NOTS_PKG.INSERT_ROW');
291: igs_ge_msg_stack.add;
292: app_exception.raise_exception;
293: END IF;
294:

Line 309: INSERT INTO igs_ad_pnmembr_nots (

305: x_last_updated_by => x_last_updated_by,
306: x_last_update_login => x_last_update_login
307: );
308:
309: INSERT INTO igs_ad_pnmembr_nots (
310: panel_dtls_id,
311: member_person_id,
312: notes_version_num,
313: member_notes,

Line 368: FROM igs_ad_pnmembr_nots

364: */
365: CURSOR c1 IS
366: SELECT
367: member_notes
368: FROM igs_ad_pnmembr_nots
369: WHERE rowid = x_rowid
370: FOR UPDATE NOWAIT;
371:
372: tlinfo c1%ROWTYPE;

Line 440: fnd_message.set_token ('ROUTINE', 'IGS_AD_pnmembr_nots_PKG.UPDATE_ROW');

436: x_last_update_login := -1;
437: END IF;
438: ELSE
439: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
440: fnd_message.set_token ('ROUTINE', 'IGS_AD_pnmembr_nots_PKG.UPDATE_ROW');
441: igs_ge_msg_stack.add;
442: app_exception.raise_exception;
443: END IF;
444:

Line 459: UPDATE igs_ad_pnmembr_nots

455: x_last_updated_by => x_last_updated_by,
456: x_last_update_login => x_last_update_login
457: );
458:
459: UPDATE igs_ad_pnmembr_nots
460: SET
461: member_notes = new_references.member_notes,
462: last_update_date = x_last_update_date,
463: last_updated_by = x_last_updated_by,

Line 510: FROM igs_ad_pnmembr_nots

506: || (reverse chronological order - newest change first)
507: */
508: CURSOR c1 IS
509: SELECT rowid
510: FROM igs_ad_pnmembr_nots
511: WHERE panel_dtls_id = x_panel_dtls_id
512: AND member_person_id = x_member_person_id
513: AND notes_version_num = x_notes_version_num;
514:

Line 565: DELETE FROM igs_ad_pnmembr_nots

561: p_action => 'DELETE',
562: x_rowid => x_rowid
563: );
564:
565: DELETE FROM igs_ad_pnmembr_nots
566: WHERE rowid = x_rowid;
567:
568: IF (SQL%NOTFOUND) THEN
569: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 592: END igs_ad_pnmembr_nots_pkg;

588: END IF;
589: END delete_row;
590:
591:
592: END igs_ad_pnmembr_nots_pkg;