APPS.IGS_HE_USR_RTN_CLAS_PKG dependencies on IGS_HE_USR_RTN_CLAS

Line 1: PACKAGE BODY igs_he_usr_rtn_clas_pkg AS

1: PACKAGE BODY igs_he_usr_rtn_clas_pkg AS
2: /* $Header: IGSWI15B.pls 115.7 2002/12/20 08:53:20 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_usr_rtn_clas%ROWTYPE;

Line 5: old_references igs_he_usr_rtn_clas%ROWTYPE;

1: PACKAGE BODY igs_he_usr_rtn_clas_pkg AS
2: /* $Header: IGSWI15B.pls 115.7 2002/12/20 08:53:20 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_usr_rtn_clas%ROWTYPE;
6: new_references igs_he_usr_rtn_clas%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_usr_rtn_clas%ROWTYPE;

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

Line 37: FROM IGS_HE_USR_RTN_CLAS

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

Line 120: igs_he_submsn_return_pkg.get_fk_igs_he_usr_rtn_clas (

116: || (reverse chronological order - newest change first)
117: */
118: BEGIN
119:
120: igs_he_submsn_return_pkg.get_fk_igs_he_usr_rtn_clas (
121: old_references.user_return_subclass
122: );
123:
124: igs_he_usr_rt_cl_fld_pkg.get_fk_igs_he_usr_rtn_clas (

Line 124: igs_he_usr_rt_cl_fld_pkg.get_fk_igs_he_usr_rtn_clas (

120: igs_he_submsn_return_pkg.get_fk_igs_he_usr_rtn_clas (
121: old_references.user_return_subclass
122: );
123:
124: igs_he_usr_rt_cl_fld_pkg.get_fk_igs_he_usr_rtn_clas (
125: old_references.user_return_subclass
126: );
127:
128: END check_child_existance;

Line 145: FROM igs_he_usr_rtn_clas

141: || (reverse chronological order - newest change first)
142: */
143: CURSOR cur_rowid IS
144: SELECT rowid
145: FROM igs_he_usr_rtn_clas
146: WHERE user_return_subclass = x_user_return_subclass
147: FOR UPDATE NOWAIT;
148:
149: lv_rowid cur_rowid%RowType;

Line 180: FROM igs_he_usr_rtn_clas

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

Line 305: FROM igs_he_usr_rtn_clas

301: || (reverse chronological order - newest change first)
302: */
303: CURSOR c IS
304: SELECT rowid
305: FROM igs_he_usr_rtn_clas
306: WHERE user_return_subclass = x_user_return_subclass;
307:
308: x_last_update_date DATE;
309: x_last_updated_by NUMBER;

Line 333: SELECT igs_he_usr_rtn_clas_s.NEXTVAL

329: igs_ge_msg_stack.add;
330: app_exception.raise_exception;
331: END IF;
332:
333: SELECT igs_he_usr_rtn_clas_s.NEXTVAL
334: INTO x_usr_rtn_clas_id
335: FROM dual;
336:
337: before_dml(

Line 355: INSERT INTO igs_he_usr_rtn_clas (

351: x_last_updated_by => x_last_updated_by,
352: x_last_update_login => x_last_update_login
353: );
354:
355: INSERT INTO igs_he_usr_rtn_clas (
356: usr_rtn_clas_id,
357: system_return_class_type,
358: user_return_subclass,
359: description,

Line 425: FROM igs_he_usr_rtn_clas

421: record_id,
422: rec_id_seg1,
423: rec_id_seg2,
424: rec_id_seg3
425: FROM igs_he_usr_rtn_clas
426: WHERE rowid = x_rowid
427: FOR UPDATE NOWAIT;
428:
429: tlinfo c1%ROWTYPE;

Line 529: UPDATE igs_he_usr_rtn_clas

525: x_last_updated_by => x_last_updated_by,
526: x_last_update_login => x_last_update_login
527: );
528:
529: UPDATE igs_he_usr_rtn_clas
530: SET
531: usr_rtn_clas_id = new_references.usr_rtn_clas_id,
532: system_return_class_type = new_references.system_return_class_type,
533: description = new_references.description,

Line 573: FROM igs_he_usr_rtn_clas

569: || (reverse chronological order - newest change first)
570: */
571: CURSOR c1 IS
572: SELECT rowid
573: FROM igs_he_usr_rtn_clas
574: WHERE user_return_subclass = x_user_return_subclass;
575:
576: BEGIN
577:

Line 634: DELETE FROM igs_he_usr_rtn_clas

630: p_action => 'DELETE',
631: x_rowid => x_rowid
632: );
633:
634: DELETE FROM igs_he_usr_rtn_clas
635: WHERE rowid = x_rowid;
636:
637: IF (SQL%NOTFOUND) THEN
638: RAISE NO_DATA_FOUND;

Line 644: END igs_he_usr_rtn_clas_pkg;

640:
641: END delete_row;
642:
643:
644: END igs_he_usr_rtn_clas_pkg;