APPS.IGS_FI_SA_SEGMENTS_PKG dependencies on IGS_FI_SA_SEGMENTS_ALL

Line 5: old_references igs_fi_sa_segments_all%ROWTYPE;

1: PACKAGE BODY igs_fi_sa_segments_pkg AS
2: /* $Header: IGSSIA0B.pls 115.5 2002/11/29 03:59:41 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_sa_segments_all%ROWTYPE;
6: new_references igs_fi_sa_segments_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_sa_segments_all%ROWTYPE;

2: /* $Header: IGSSIA0B.pls 115.5 2002/11/29 03:59:41 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_sa_segments_all%ROWTYPE;
6: new_references igs_fi_sa_segments_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 35: FROM IGS_FI_SA_SEGMENTS_ALL

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

Line 89: FROM igs_fi_sa_segments_all

85: || (reverse chronological order - newest change first)
86: */
87: CURSOR cur_rowid IS
88: SELECT rowid
89: FROM igs_fi_sa_segments_all
90: WHERE subaccount_segment_id = x_subaccount_segment_id
91: FOR UPDATE NOWAIT;
92:
93: lv_rowid cur_rowid%RowType;

Line 200: FROM igs_fi_sa_segments_all

196: || (reverse chronological order - newest change first)
197: */
198: CURSOR c IS
199: SELECT rowid
200: FROM igs_fi_sa_segments_all
201: WHERE subaccount_segment_id = x_subaccount_segment_id;
202:
203: x_last_update_date DATE;
204: x_last_updated_by NUMBER;

Line 248: INSERT INTO igs_fi_sa_segments_all (

244: x_last_updated_by => x_last_updated_by,
245: x_last_update_login => x_last_update_login
246: );
247:
248: INSERT INTO igs_fi_sa_segments_all (
249: subaccount_segment_id,
250: segment,
251: segment_num,
252: segment_value,

Line 304: FROM igs_fi_sa_segments_all

300: SELECT
301: segment,
302: segment_num,
303: segment_value
304: FROM igs_fi_sa_segments_all
305: WHERE rowid = x_rowid
306: FOR UPDATE NOWAIT;
307:
308: tlinfo c1%ROWTYPE;

Line 398: UPDATE igs_fi_sa_segments_all

394: x_last_updated_by => x_last_updated_by,
395: x_last_update_login => x_last_update_login
396: );
397:
398: UPDATE igs_fi_sa_segments_all
399: SET
400: segment = new_references.segment,
401: segment_num = new_references.segment_num,
402: segment_value = new_references.segment_value,

Line 436: FROM igs_fi_sa_segments_all

432: || (reverse chronological order - newest change first)
433: */
434: CURSOR c1 IS
435: SELECT rowid
436: FROM igs_fi_sa_segments_all
437: WHERE subaccount_segment_id = x_subaccount_segment_id;
438:
439: BEGIN
440:

Line 489: DELETE FROM igs_fi_sa_segments_all

485: p_action => 'DELETE',
486: x_rowid => x_rowid
487: );
488:
489: DELETE FROM igs_fi_sa_segments_all
490: WHERE rowid = x_rowid;
491:
492: IF (SQL%NOTFOUND) THEN
493: RAISE NO_DATA_FOUND;