APPS.IGS_OR_CWLK_PKG dependencies on IGS_OR_CWLK

Line 1: PACKAGE BODY igs_or_cwlk_pkg AS

1: PACKAGE BODY igs_or_cwlk_pkg AS
2: /* $Header: IGSOI26B.pls 115.4 2002/11/29 01:43:18 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_or_cwlk%ROWTYPE;

Line 5: old_references igs_or_cwlk%ROWTYPE;

1: PACKAGE BODY igs_or_cwlk_pkg AS
2: /* $Header: IGSOI26B.pls 115.4 2002/11/29 01:43:18 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_or_cwlk%ROWTYPE;
6: new_references igs_or_cwlk%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_or_cwlk%ROWTYPE;

2: /* $Header: IGSOI26B.pls 115.4 2002/11/29 01:43:18 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_or_cwlk%ROWTYPE;
6: new_references igs_or_cwlk%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 32: FROM IGS_OR_CWLK

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

Line 84: igs_or_cwlk_dtl_pkg.get_fk_igs_or_cwlk (

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

Line 105: FROM igs_or_cwlk

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

Line 211: FROM igs_or_cwlk

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

Line 255: SELECT igs_or_cwlk_s.NEXTVAL

251: igs_ge_msg_stack.add;
252: app_exception.raise_exception;
253: END IF;
254:
255: SELECT igs_or_cwlk_s.NEXTVAL
256: INTO x_crosswalk_id
257: FROM dual;
258:
259: before_dml(

Line 272: INSERT INTO igs_or_cwlk (

268: x_last_updated_by => x_last_updated_by,
269: x_last_update_login => x_last_update_login
270: );
271:
272: INSERT INTO igs_or_cwlk (
273: crosswalk_id,
274: institution_code,
275: institution_name,
276: creation_date,

Line 330: FROM igs_or_cwlk

326: CURSOR c1 IS
327: SELECT
328: institution_code,
329: institution_name
330: FROM igs_or_cwlk
331: WHERE rowid = x_rowid
332: FOR UPDATE NOWAIT;
333:
334: tlinfo c1%ROWTYPE;

Line 437: UPDATE igs_or_cwlk

433: x_program_update_date := SYSDATE;
434: END IF;
435: END IF;
436:
437: UPDATE igs_or_cwlk
438: SET
439: institution_code = new_references.institution_code,
440: institution_name = new_references.institution_name,
441: last_update_date = x_last_update_date,

Line 475: FROM igs_or_cwlk

471: || (reverse chronological order - newest change first)
472: */
473: CURSOR c1 IS
474: SELECT rowid
475: FROM igs_or_cwlk
476: WHERE crosswalk_id = x_crosswalk_id;
477:
478: BEGIN
479:

Line 526: DELETE FROM igs_or_cwlk

522: p_action => 'DELETE',
523: x_rowid => x_rowid
524: );
525:
526: DELETE FROM igs_or_cwlk
527: WHERE rowid = x_rowid;
528:
529: IF (SQL%NOTFOUND) THEN
530: RAISE NO_DATA_FOUND;

Line 536: END igs_or_cwlk_pkg;

532:
533: END delete_row;
534:
535:
536: END igs_or_cwlk_pkg;