APPS.IGS_OR_CWLK_DTL_PKG dependencies on IGS_OR_CWLK_DTL

Line 1: PACKAGE BODY igs_or_cwlk_dtl_pkg AS

1: PACKAGE BODY igs_or_cwlk_dtl_pkg AS
2: /* $Header: IGSOI27B.pls 115.5 2002/11/29 01:43:33 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_or_cwlk_dtl%ROWTYPE;

Line 5: old_references igs_or_cwlk_dtl%ROWTYPE;

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

Line 6: new_references igs_or_cwlk_dtl%ROWTYPE;

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

Line 33: FROM IGS_OR_CWLK_DTL

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

Line 149: FROM igs_or_cwlk_dtl

145: || (reverse chronological order - newest change first)
146: */
147: CURSOR cur_rowid IS
148: SELECT rowid
149: FROM igs_or_cwlk_dtl
150: WHERE crosswalk_dtl_id = x_crosswalk_dtl_id
151: FOR UPDATE NOWAIT;
152:
153: lv_rowid cur_rowid%RowType;

Line 184: FROM igs_or_cwlk_dtl

180: || (reverse chronological order - newest change first)
181: */
182: CURSOR cur_rowid IS
183: SELECT rowid
184: FROM igs_or_cwlk_dtl
185: WHERE alt_id_type = x_alt_id_type
186: AND alt_id_value = x_alt_id_value
187: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
188:

Line 219: FROM igs_or_cwlk_dtl

215: || (reverse chronological order - newest change first)
216: */
217: CURSOR cur_rowid IS
218: SELECT rowid
219: FROM igs_or_cwlk_dtl
220: WHERE ((crosswalk_id = x_crosswalk_id));
221:
222: lv_rowid cur_rowid%RowType;
223:

Line 254: FROM igs_or_cwlk_dtl

250: || (reverse chronological order - newest change first)
251: */
252: CURSOR cur_rowid IS
253: SELECT rowid
254: FROM igs_or_cwlk_dtl
255: WHERE ((alt_id_type = x_org_alternate_id_type));
256:
257: lv_rowid cur_rowid%RowType;
258:

Line 367: FROM igs_or_cwlk_dtl

363: || (reverse chronological order - newest change first)
364: */
365: CURSOR c IS
366: SELECT rowid
367: FROM igs_or_cwlk_dtl
368: WHERE crosswalk_dtl_id = x_crosswalk_dtl_id;
369:
370: x_last_update_date DATE;
371: x_last_updated_by NUMBER;

Line 411: SELECT igs_or_cwlk_dtl_s.NEXTVAL

407: igs_ge_msg_stack.add;
408: app_exception.raise_exception;
409: END IF;
410:
411: SELECT igs_or_cwlk_dtl_s.NEXTVAL
412: INTO x_crosswalk_dtl_id
413: FROM dual;
414:
415: before_dml(

Line 429: INSERT INTO igs_or_cwlk_dtl (

425: x_last_updated_by => x_last_updated_by,
426: x_last_update_login => x_last_update_login
427: );
428:
429: INSERT INTO igs_or_cwlk_dtl (
430: crosswalk_dtl_id,
431: crosswalk_id,
432: alt_id_type,
433: alt_id_value,

Line 491: FROM igs_or_cwlk_dtl

487: SELECT
488: crosswalk_id,
489: alt_id_type,
490: alt_id_value
491: FROM igs_or_cwlk_dtl
492: WHERE rowid = x_rowid
493: FOR UPDATE NOWAIT;
494:
495: tlinfo c1%ROWTYPE;

Line 601: UPDATE igs_or_cwlk_dtl

597: x_program_update_date := SYSDATE;
598: END IF;
599: END IF;
600:
601: UPDATE igs_or_cwlk_dtl
602: SET
603: crosswalk_id = new_references.crosswalk_id,
604: alt_id_type = new_references.alt_id_type,
605: alt_id_value = new_references.alt_id_value,

Line 641: FROM igs_or_cwlk_dtl

637: || (reverse chronological order - newest change first)
638: */
639: CURSOR c1 IS
640: SELECT rowid
641: FROM igs_or_cwlk_dtl
642: WHERE crosswalk_dtl_id = x_crosswalk_dtl_id;
643:
644: BEGIN
645:

Line 694: DELETE FROM igs_or_cwlk_dtl

690: p_action => 'DELETE',
691: x_rowid => x_rowid
692: );
693:
694: DELETE FROM igs_or_cwlk_dtl
695: WHERE rowid = x_rowid;
696:
697: IF (SQL%NOTFOUND) THEN
698: RAISE NO_DATA_FOUND;

Line 704: END igs_or_cwlk_dtl_pkg;

700:
701: END delete_row;
702:
703:
704: END igs_or_cwlk_dtl_pkg;