APPS.IGS_PS_UNT_CRCLM_PKG dependencies on IGS_PS_UNT_CRCLM_ALL

Line 5: old_references igs_ps_unt_crclm_all%ROWTYPE;

1: PACKAGE BODY igs_ps_unt_crclm_pkg AS
2: /* $Header: IGSPI2BB.pls 115.5 2002/11/29 02:14:51 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_unt_crclm_all%ROWTYPE;
6: new_references igs_ps_unt_crclm_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_unt_crclm_all%ROWTYPE;

2: /* $Header: IGSPI2BB.pls 115.5 2002/11/29 02:14:51 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_unt_crclm_all%ROWTYPE;
6: new_references igs_ps_unt_crclm_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 32: FROM IGS_PS_UNT_CRCLM_ALL

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

Line 84: igs_ps_unit_ver_pkg.get_fk_igs_ps_unt_crclm_all (

80: || (reverse chronological order - newest change first)
81: */
82: BEGIN
83:
84: igs_ps_unit_ver_pkg.get_fk_igs_ps_unt_crclm_all (
85: old_references.curriculum_id
86: );
87:
88: END check_child_existance;

Line 105: FROM igs_ps_unt_crclm_all

101: || (reverse chronological order - newest change first)
102: */
103: CURSOR cur_rowid IS
104: SELECT rowid
105: FROM igs_ps_unt_crclm_all
106: WHERE curriculum_id = x_curriculum_id
107: FOR UPDATE NOWAIT;
108:
109: lv_rowid cur_rowid%RowType;

Line 211: FROM igs_ps_unt_crclm_all

207: || (reverse chronological order - newest change first)
208: */
209: CURSOR c IS
210: SELECT rowid
211: FROM igs_ps_unt_crclm_all
212: WHERE curriculum_id = x_curriculum_id;
213:
214: x_last_update_date DATE;
215: x_last_updated_by NUMBER;

Line 241: SELECT igs_ps_unt_crclm_all_s.NEXTVAL

237: END IF;
238:
239: IF (FND_PROFILE.VALUE('IGS_PS_CURRICULUM_ID') = 'N') THEN
240:
241: SELECT igs_ps_unt_crclm_all_s.NEXTVAL
242: INTO x_curriculum_id
243: FROM dual;
244:
245: END IF;

Line 261: INSERT INTO igs_ps_unt_crclm_all (

257: x_last_updated_by => x_last_updated_by,
258: x_last_update_login => x_last_update_login
259: );
260:
261: INSERT INTO igs_ps_unt_crclm_all (
262: curriculum_id,
263: description,
264: closed_ind,
265: org_id,

Line 313: FROM igs_ps_unt_crclm_all

309: CURSOR c1 IS
310: SELECT
311: description,
312: closed_ind
313: FROM igs_ps_unt_crclm_all
314: WHERE rowid = x_rowid
315: FOR UPDATE NOWAIT;
316:
317: tlinfo c1%ROWTYPE;

Line 402: UPDATE igs_ps_unt_crclm_all

398: x_last_updated_by => x_last_updated_by,
399: x_last_update_login => x_last_update_login
400: );
401:
402: UPDATE igs_ps_unt_crclm_all
403: SET
404: description = new_references.description,
405: closed_ind = new_references.closed_ind,
406: last_update_date = x_last_update_date,

Line 436: FROM igs_ps_unt_crclm_all

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

Line 487: DELETE FROM igs_ps_unt_crclm_all

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