APPS.IGS_HE_SYS_RTN_CLAS_PKG dependencies on IGS_HE_SYS_RTN_CLAS

Line 1: PACKAGE BODY igs_he_sys_rtn_clas_pkg AS

1: PACKAGE BODY igs_he_sys_rtn_clas_pkg AS
2: /* $Header: IGSWI13B.pls 115.4 2002/12/20 08:52:31 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_sys_rtn_clas%ROWTYPE;

Line 5: old_references igs_he_sys_rtn_clas%ROWTYPE;

1: PACKAGE BODY igs_he_sys_rtn_clas_pkg AS
2: /* $Header: IGSWI13B.pls 115.4 2002/12/20 08:52:31 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_sys_rtn_clas%ROWTYPE;
6: new_references igs_he_sys_rtn_clas%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_sys_rtn_clas%ROWTYPE;

2: /* $Header: IGSWI13B.pls 115.4 2002/12/20 08:52:31 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_sys_rtn_clas%ROWTYPE;
6: new_references igs_he_sys_rtn_clas%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 32: FROM IGS_HE_SYS_RTN_CLAS

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

Line 84: igs_he_sys_rt_cl_fld_pkg.get_fk_igs_he_sys_rtn_clas (

80: || (reverse chronological order - newest change first)
81: */
82: BEGIN
83:
84: igs_he_sys_rt_cl_fld_pkg.get_fk_igs_he_sys_rtn_clas (
85: old_references.system_return_class_type
86: );
87:
88: igs_he_usr_rtn_clas_pkg.get_fk_igs_he_sys_rtn_clas (

Line 88: igs_he_usr_rtn_clas_pkg.get_fk_igs_he_sys_rtn_clas (

84: igs_he_sys_rt_cl_fld_pkg.get_fk_igs_he_sys_rtn_clas (
85: old_references.system_return_class_type
86: );
87:
88: igs_he_usr_rtn_clas_pkg.get_fk_igs_he_sys_rtn_clas (
89: old_references.system_return_class_type
90: );
91:
92: END check_child_existance;

Line 109: FROM igs_he_sys_rtn_clas

105: || (reverse chronological order - newest change first)
106: */
107: CURSOR cur_rowid IS
108: SELECT rowid
109: FROM igs_he_sys_rtn_clas
110: WHERE system_return_class_type = x_system_return_class_type
111: FOR UPDATE NOWAIT;
112:
113: lv_rowid cur_rowid%RowType;

Line 215: FROM igs_he_sys_rtn_clas

211: || (reverse chronological order - newest change first)
212: */
213: CURSOR c IS
214: SELECT rowid
215: FROM igs_he_sys_rtn_clas
216: WHERE system_return_class_type = x_system_return_class_type;
217:
218: x_last_update_date DATE;
219: x_last_updated_by NUMBER;

Line 256: INSERT INTO igs_he_sys_rtn_clas (

252: x_last_updated_by => x_last_updated_by,
253: x_last_update_login => x_last_update_login
254: );
255:
256: INSERT INTO igs_he_sys_rtn_clas (
257: system_return_class_type,
258: system_return_class_recid,
259: description,
260: creation_date,

Line 306: FROM igs_he_sys_rtn_clas

302: CURSOR c1 IS
303: SELECT
304: system_return_class_recid,
305: description
306: FROM igs_he_sys_rtn_clas
307: WHERE rowid = x_rowid
308: FOR UPDATE NOWAIT;
309:
310: tlinfo c1%ROWTYPE;

Line 395: UPDATE igs_he_sys_rtn_clas

391: x_last_updated_by => x_last_updated_by,
392: x_last_update_login => x_last_update_login
393: );
394:
395: UPDATE igs_he_sys_rtn_clas
396: SET
397: system_return_class_recid = new_references.system_return_class_recid,
398: description = new_references.description,
399: last_update_date = x_last_update_date,

Line 429: FROM igs_he_sys_rtn_clas

425: || (reverse chronological order - newest change first)
426: */
427: CURSOR c1 IS
428: SELECT rowid
429: FROM igs_he_sys_rtn_clas
430: WHERE system_return_class_type = x_system_return_class_type;
431:
432: BEGIN
433:

Line 480: DELETE FROM igs_he_sys_rtn_clas

476: p_action => 'DELETE',
477: x_rowid => x_rowid
478: );
479:
480: DELETE FROM igs_he_sys_rtn_clas
481: WHERE rowid = x_rowid;
482:
483: IF (SQL%NOTFOUND) THEN
484: RAISE NO_DATA_FOUND;

Line 490: END igs_he_sys_rtn_clas_pkg;

486:
487: END delete_row;
488:
489:
490: END igs_he_sys_rtn_clas_pkg;