APPS.IGS_FI_P_SA_NOTES_PKG dependencies on IGS_FI_P_SA_NOTES

Line 1: PACKAGE BODY igs_fi_p_sa_notes_pkg AS

1: PACKAGE BODY igs_fi_p_sa_notes_pkg AS
2: /* $Header: IGSSI93B.pls 115.7 2002/11/29 03:57:39 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_p_sa_notes%ROWTYPE;

Line 5: old_references igs_fi_p_sa_notes%ROWTYPE;

1: PACKAGE BODY igs_fi_p_sa_notes_pkg AS
2: /* $Header: IGSSI93B.pls 115.7 2002/11/29 03:57:39 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_p_sa_notes%ROWTYPE;
6: new_references igs_fi_p_sa_notes%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_p_sa_notes%ROWTYPE;

2: /* $Header: IGSSI93B.pls 115.7 2002/11/29 03:57:39 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_p_sa_notes%ROWTYPE;
6: new_references igs_fi_p_sa_notes%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 35: FROM IGS_FI_P_SA_NOTES

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

Line 170: FROM igs_fi_p_sa_notes

166: || (reverse chronological order - newest change first)
167: */
168: CURSOR cur_rowid IS
169: SELECT rowid
170: FROM igs_fi_p_sa_notes
171: WHERE party_sa_notes_id = x_party_sa_notes_id
172: FOR UPDATE NOWAIT;
173:
174: lv_rowid cur_rowid%RowType;

Line 208: FROM igs_fi_p_sa_notes

204: || vvutukur 20-Sep-2002 Enh#2564643.Removed references to subaccount_id.
205: */
206: CURSOR cur_rowid IS
207: SELECT rowid
208: FROM igs_fi_p_sa_notes
209: WHERE party_id = x_party_id
210: AND effective_date = x_effective_date
211: AND reference_number = x_reference_number
212: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 247: FROM igs_fi_p_sa_notes

243: || (reverse chronological order - newest change first)
244: */
245: CURSOR cur_rowid IS
246: SELECT rowid
247: FROM igs_fi_p_sa_notes
248: WHERE ((reference_number = x_reference_number));
249:
250: lv_rowid cur_rowid%RowType;
251:

Line 364: FROM igs_fi_p_sa_notes

360: || from package body to avoid gscc warnings.
361: */
362: CURSOR c IS
363: SELECT rowid
364: FROM igs_fi_p_sa_notes
365: WHERE party_sa_notes_id = x_party_sa_notes_id;
366:
367: x_last_update_date DATE;
368: x_last_updated_by NUMBER;

Line 392: SELECT igs_fi_p_sa_notes_s.NEXTVAL

388: igs_ge_msg_stack.add;
389: app_exception.raise_exception;
390: END IF;
391:
392: SELECT igs_fi_p_sa_notes_s.NEXTVAL
393: INTO x_party_sa_notes_id
394: FROM dual;
395:
396: before_dml(

Line 410: INSERT INTO igs_fi_p_sa_notes (

406: x_last_updated_by => x_last_updated_by,
407: x_last_update_login => x_last_update_login
408: );
409:
410: INSERT INTO igs_fi_p_sa_notes (
411: party_sa_notes_id,
412: party_id,
413: effective_date,
414: reference_number,

Line 465: FROM igs_fi_p_sa_notes

461: SELECT
462: party_id,
463: effective_date,
464: reference_number
465: FROM igs_fi_p_sa_notes
466: WHERE rowid = x_rowid
467: FOR UPDATE NOWAIT;
468:
469: tlinfo c1%ROWTYPE;

Line 559: UPDATE igs_fi_p_sa_notes

555: x_last_updated_by => x_last_updated_by,
556: x_last_update_login => x_last_update_login
557: );
558:
559: UPDATE igs_fi_p_sa_notes
560: SET
561: party_id = new_references.party_id,
562: effective_date = new_references.effective_date,
563: reference_number = new_references.reference_number,

Line 597: FROM igs_fi_p_sa_notes

593: || clause to avoid gscc warnings.
594: */
595: CURSOR c1 IS
596: SELECT rowid
597: FROM igs_fi_p_sa_notes
598: WHERE party_sa_notes_id = x_party_sa_notes_id;
599:
600: BEGIN
601:

Line 650: DELETE FROM igs_fi_p_sa_notes

646: p_action => 'DELETE',
647: x_rowid => x_rowid
648: );
649:
650: DELETE FROM igs_fi_p_sa_notes
651: WHERE rowid = x_rowid;
652:
653: IF (SQL%NOTFOUND) THEN
654: RAISE NO_DATA_FOUND;

Line 660: END igs_fi_p_sa_notes_pkg;

656:
657: END delete_row;
658:
659:
660: END igs_fi_p_sa_notes_pkg;