APPS.IGS_CO_INTERAC_HIST_PKG dependencies on IGS_CO_INTERAC_HIST

Line 1: PACKAGE BODY Igs_Co_Interac_Hist_Pkg AS

1: PACKAGE BODY Igs_Co_Interac_Hist_Pkg AS
2: /* $Header: IGSLI28B.pls 120.0 2005/06/01 19:36:59 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_co_interac_hist%ROWTYPE;
5: new_references igs_co_interac_hist%ROWTYPE;

Line 4: old_references igs_co_interac_hist%ROWTYPE;

1: PACKAGE BODY Igs_Co_Interac_Hist_Pkg AS
2: /* $Header: IGSLI28B.pls 120.0 2005/06/01 19:36:59 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_co_interac_hist%ROWTYPE;
5: new_references igs_co_interac_hist%ROWTYPE;
6:
7: PROCEDURE set_column_values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_co_interac_hist%ROWTYPE;

1: PACKAGE BODY Igs_Co_Interac_Hist_Pkg AS
2: /* $Header: IGSLI28B.pls 120.0 2005/06/01 19:36:59 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_co_interac_hist%ROWTYPE;
5: new_references igs_co_interac_hist%ROWTYPE;
6:
7: PROCEDURE set_column_values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 40: FROM igs_co_interac_hist

36: || (reverse chronological order - newest change first)
37: */
38: CURSOR cur_old_ref_values IS
39: SELECT *
40: FROM igs_co_interac_hist
41: WHERE ROWID = x_rowid;
42: BEGIN
43: l_rowid := x_rowid;
44: -- Code for setting the Old and New Reference Values.

Line 119: FROM igs_co_interac_hist

115: || (reverse chronological order - newest change first)
116: */
117: CURSOR cur_rowid IS
118: SELECT ROWID
119: FROM igs_co_interac_hist
120: WHERE request_id = x_request_id
121: FOR UPDATE NOWAIT;
122: lv_rowid cur_rowid%ROWTYPE;
123: BEGIN

Line 245: FROM igs_co_interac_hist

241: || (reverse chronological order - newest change first)
242: */
243: CURSOR c IS
244: SELECT ROWID
245: FROM igs_co_interac_hist
246: WHERE request_id = x_request_id;
247: x_last_update_date DATE;
248: x_last_updated_by NUMBER;
249: x_last_update_login NUMBER;

Line 287: INSERT INTO igs_co_interac_hist (

283: x_last_updated_by => x_last_updated_by,
284: x_last_update_login => x_last_update_login ,
285: x_version_id => x_version_id
286: );
287: INSERT INTO igs_co_interac_hist (
288: student_id,
289: request_id,
290: document_id,
291: document_type,

Line 375: FROM igs_co_interac_hist

371: ci_sequence_number,
372: requested_date,
373: delivery_type,
374: version_id
375: FROM igs_co_interac_hist
376: WHERE ROWID = x_rowid
377: FOR UPDATE NOWAIT;
378: tlinfo c1%ROWTYPE;
379: BEGIN

Line 484: UPDATE igs_co_interac_hist

480: x_last_updated_by => x_last_updated_by,
481: x_last_update_login => x_last_update_login ,
482: x_version_id => x_version_id
483: );
484: UPDATE igs_co_interac_hist
485: SET
486: student_id = new_references.student_id,
487: request_id = new_references.request_id,
488: document_id = new_references.document_id,

Line 536: FROM igs_co_interac_hist

532: || (reverse chronological order - newest change first)
533: */
534: CURSOR c1 IS
535: SELECT ROWID
536: FROM igs_co_interac_hist
537: WHERE request_id = x_request_id;
538: BEGIN
539: OPEN c1;
540: FETCH c1 INTO x_rowid;

Line 598: DELETE FROM igs_co_interac_hist

594: before_dml (
595: p_action => 'DELETE',
596: x_rowid => x_rowid
597: );
598: DELETE FROM igs_co_interac_hist
599: WHERE ROWID = x_rowid;
600: IF (SQL%NOTFOUND) THEN
601: RAISE NO_DATA_FOUND;
602: END IF;

Line 604: END Igs_Co_Interac_Hist_Pkg;

600: IF (SQL%NOTFOUND) THEN
601: RAISE NO_DATA_FOUND;
602: END IF;
603: END delete_row;
604: END Igs_Co_Interac_Hist_Pkg;