APPS.IGS_PS_ACCTS_PKG dependencies on IGS_PS_ACCTS_ALL

Line 5: old_references igs_ps_accts_all%ROWTYPE;

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

Line 6: new_references igs_ps_accts_all%ROWTYPE;

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

Line 35: FROM IGS_PS_ACCTS_ALL

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

Line 92: FROM igs_ps_accts_all

88: || (reverse chronological order - newest change first)
89: */
90: CURSOR cur_rowid IS
91: SELECT rowid
92: FROM igs_ps_accts_all
93: WHERE course_account_id = x_course_account_id
94: FOR UPDATE NOWAIT;
95:
96: lv_rowid cur_rowid%RowType;

Line 127: FROM igs_ps_accts_all

123: || (reverse chronological order - newest change first)
124: */
125: CURSOR cur_rowid IS
126: SELECT rowid
127: FROM igs_ps_accts_all
128: WHERE ((course_cd = x_course_cd) AND
129: (version_number = x_version_number));
130:
131: lv_rowid cur_rowid%RowType;

Line 239: FROM igs_ps_accts_all

235: || (reverse chronological order - newest change first)
236: */
237: CURSOR c IS
238: SELECT rowid
239: FROM igs_ps_accts_all
240: WHERE course_account_id = x_course_account_id;
241:
242: x_last_update_date DATE;
243: x_last_updated_by NUMBER;

Line 289: INSERT INTO igs_ps_accts_all (

285: x_last_updated_by => x_last_updated_by,
286: x_last_update_login => x_last_update_login
287: );
288:
289: INSERT INTO igs_ps_accts_all (
290: course_account_id,
291: course_cd,
292: version_number,
293: segment,

Line 353: FROM igs_ps_accts_all

349: version_number,
350: segment,
351: segment_num,
352: segment_value
353: FROM igs_ps_accts_all
354: WHERE rowid = x_rowid
355: FOR UPDATE NOWAIT;
356:
357: tlinfo c1%ROWTYPE;

Line 451: UPDATE igs_ps_accts_all

447: x_last_updated_by => x_last_updated_by,
448: x_last_update_login => x_last_update_login
449: );
450:
451: UPDATE igs_ps_accts_all
452: SET
453: course_cd = new_references.course_cd,
454: version_number = new_references.version_number,
455: segment = new_references.segment,

Line 491: FROM igs_ps_accts_all

487: || (reverse chronological order - newest change first)
488: */
489: CURSOR c1 IS
490: SELECT rowid
491: FROM igs_ps_accts_all
492: WHERE course_account_id = x_course_account_id;
493:
494: BEGIN
495:

Line 548: DELETE FROM igs_ps_accts_all

544: p_action => 'DELETE',
545: x_rowid => x_rowid
546: );
547:
548: DELETE FROM igs_ps_accts_all
549: WHERE rowid = x_rowid;
550:
551: IF (SQL%NOTFOUND) THEN
552: RAISE NO_DATA_FOUND;