APPS.IGS_PS_USEC_ACCTS_PKG dependencies on IGS_PS_USEC_ACCTS_ALL

Line 5: old_references igs_ps_usec_accts_all%ROWTYPE;

1: PACKAGE BODY igs_ps_usec_accts_pkg AS
2: /* $Header: IGSPI3AB.pls 115.4 2002/11/29 02:24:20 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_usec_accts_all%ROWTYPE;
6: new_references igs_ps_usec_accts_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_usec_accts_all%ROWTYPE;

2: /* $Header: IGSPI3AB.pls 115.4 2002/11/29 02:24:20 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_usec_accts_all%ROWTYPE;
6: new_references igs_ps_usec_accts_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 34: FROM IGS_PS_USEC_ACCTS_ALL

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

Line 116: FROM igs_ps_usec_accts_all

112: || (reverse chronological order - newest change first)
113: */
114: CURSOR cur_rowid IS
115: SELECT rowid
116: FROM igs_ps_usec_accts_all
117: WHERE usec_account_id = x_usec_account_id
118: FOR UPDATE NOWAIT;
119:
120: lv_rowid cur_rowid%RowType;

Line 151: FROM igs_ps_usec_accts_all

147: || (reverse chronological order - newest change first)
148: */
149: CURSOR cur_rowid IS
150: SELECT rowid
151: FROM igs_ps_usec_accts_all
152: WHERE ((uoo_id = x_uoo_id));
153:
154: lv_rowid cur_rowid%RowType;
155:

Line 262: FROM igs_ps_usec_accts_all

258: || (reverse chronological order - newest change first)
259: */
260: CURSOR c IS
261: SELECT rowid
262: FROM igs_ps_usec_accts_all
263: WHERE usec_account_id = x_usec_account_id;
264:
265: x_last_update_date DATE;
266: x_last_updated_by NUMBER;

Line 311: INSERT INTO igs_ps_usec_accts_all (

307: x_last_updated_by => x_last_updated_by,
308: x_last_update_login => x_last_update_login
309: );
310:
311: INSERT INTO igs_ps_usec_accts_all (
312: usec_account_id,
313: uoo_id,
314: segment,
315: segment_num,

Line 371: FROM igs_ps_usec_accts_all

367: uoo_id,
368: segment,
369: segment_num,
370: segment_value
371: FROM igs_ps_usec_accts_all
372: WHERE rowid = x_rowid
373: FOR UPDATE NOWAIT;
374:
375: tlinfo c1%ROWTYPE;

Line 466: UPDATE igs_ps_usec_accts_all

462: x_last_updated_by => x_last_updated_by,
463: x_last_update_login => x_last_update_login
464: );
465:
466: UPDATE igs_ps_usec_accts_all
467: SET
468: uoo_id = new_references.uoo_id,
469: segment = new_references.segment,
470: segment_num = new_references.segment_num,

Line 504: FROM igs_ps_usec_accts_all

500: || (reverse chronological order - newest change first)
501: */
502: CURSOR c1 IS
503: SELECT rowid
504: FROM igs_ps_usec_accts_all
505: WHERE usec_account_id = x_usec_account_id;
506:
507: BEGIN
508:

Line 559: DELETE FROM igs_ps_usec_accts_all

555: p_action => 'DELETE',
556: x_rowid => x_rowid
557: );
558:
559: DELETE FROM igs_ps_usec_accts_all
560: WHERE rowid = x_rowid;
561:
562: IF (SQL%NOTFOUND) THEN
563: RAISE NO_DATA_FOUND;