APPS.IGS_HE_SYS_RT_CL_FLD_PKG dependencies on IGS_HE_SYS_RT_CL_FLD

Line 1: PACKAGE BODY igs_he_sys_rt_cl_fld_pkg AS

1: PACKAGE BODY igs_he_sys_rt_cl_fld_pkg AS
2: /* $Header: IGSWI14B.pls 120.1 2006/02/06 21:06:34 anwest noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_sys_rt_cl_fld%ROWTYPE;

Line 5: old_references igs_he_sys_rt_cl_fld%ROWTYPE;

1: PACKAGE BODY igs_he_sys_rt_cl_fld_pkg AS
2: /* $Header: IGSWI14B.pls 120.1 2006/02/06 21:06:34 anwest noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_sys_rt_cl_fld%ROWTYPE;
6: new_references igs_he_sys_rt_cl_fld%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_sys_rt_cl_fld%ROWTYPE;

2: /* $Header: IGSWI14B.pls 120.1 2006/02/06 21:06:34 anwest noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_sys_rt_cl_fld%ROWTYPE;
6: new_references igs_he_sys_rt_cl_fld%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 37: FROM IGS_HE_SYS_RT_CL_FLD

33: */
34:
35: CURSOR cur_old_ref_values IS
36: SELECT *
37: FROM IGS_HE_SYS_RT_CL_FLD
38: WHERE rowid = x_rowid;
39:
40: BEGIN
41:

Line 95: igs_he_sys_rt_cl_ass_pkg.get_fk_igs_he_sys_rt_cl_fld (

91: || ANWEST 09-JAN-2006 Changes as per HE305
92: */
93: BEGIN
94:
95: igs_he_sys_rt_cl_ass_pkg.get_fk_igs_he_sys_rt_cl_fld (
96: old_references.system_return_class_type,
97: old_references.field_number
98: );
99:

Line 143: FROM igs_he_sys_rt_cl_fld

139: || (reverse chronological order - newest change first)
140: */
141: CURSOR cur_rowid IS
142: SELECT rowid
143: FROM igs_he_sys_rt_cl_fld
144: WHERE system_return_class_type = x_system_return_class_type
145: AND field_number = x_field_number
146: FOR UPDATE NOWAIT;
147:

Line 179: FROM igs_he_sys_rt_cl_fld

175: || (reverse chronological order - newest change first)
176: */
177: CURSOR cur_rowid IS
178: SELECT rowid
179: FROM igs_he_sys_rt_cl_fld
180: WHERE ((system_return_class_type = x_system_return_class_type));
181:
182: lv_rowid cur_rowid%RowType;
183:

Line 306: FROM igs_he_sys_rt_cl_fld

302: || (reverse chronological order - newest change first)
303: */
304: CURSOR c IS
305: SELECT rowid
306: FROM igs_he_sys_rt_cl_fld
307: WHERE system_return_class_type = x_system_return_class_type
308: AND field_number = x_field_number;
309:
310: x_last_update_date DATE;

Line 353: INSERT INTO igs_he_sys_rt_cl_fld (

349: x_last_updated_by => x_last_updated_by,
350: x_last_update_login => x_last_update_login
351: );
352:
353: INSERT INTO igs_he_sys_rt_cl_fld (
354: system_return_class_type,
355: field_number,
356: field_name,
357: field_description,

Line 422: FROM igs_he_sys_rt_cl_fld

418: datatype,
419: length,
420: mandatory_flag,
421: closed_flag
422: FROM igs_he_sys_rt_cl_fld
423: WHERE rowid = x_rowid
424: FOR UPDATE NOWAIT;
425:
426: tlinfo c1%ROWTYPE;

Line 525: UPDATE igs_he_sys_rt_cl_fld

521: x_last_updated_by => x_last_updated_by,
522: x_last_update_login => x_last_update_login
523: );
524:
525: UPDATE igs_he_sys_rt_cl_fld
526: SET
527: field_name = new_references.field_name,
528: field_description = new_references.field_description,
529: datatype = new_references.datatype,

Line 568: FROM igs_he_sys_rt_cl_fld

564: || (reverse chronological order - newest change first)
565: */
566: CURSOR c1 IS
567: SELECT rowid
568: FROM igs_he_sys_rt_cl_fld
569: WHERE system_return_class_type = x_system_return_class_type
570: AND field_number = x_field_number;
571:
572: BEGIN

Line 630: DELETE FROM igs_he_sys_rt_cl_fld

626: p_action => 'DELETE',
627: x_rowid => x_rowid
628: );
629:
630: DELETE FROM igs_he_sys_rt_cl_fld
631: WHERE rowid = x_rowid;
632:
633: IF (SQL%NOTFOUND) THEN
634: RAISE NO_DATA_FOUND;

Line 640: END igs_he_sys_rt_cl_fld_pkg;

636:
637: END delete_row;
638:
639:
640: END igs_he_sys_rt_cl_fld_pkg;