APPS.IGS_HE_SUB_RTN_CAL_PKG dependencies on IGS_HE_SUB_RTN_CAL

Line 1: PACKAGE BODY igs_he_sub_rtn_cal_pkg AS

1: PACKAGE BODY igs_he_sub_rtn_cal_pkg AS
2: /* $Header: IGSWI12B.pls 115.7 2002/12/20 08:51:28 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_sub_rtn_cal%ROWTYPE;

Line 5: old_references igs_he_sub_rtn_cal%ROWTYPE;

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

Line 6: new_references igs_he_sub_rtn_cal%ROWTYPE;

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

Line 36: FROM IGS_HE_SUB_RTN_CAL

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

Line 137: FROM igs_he_sub_rtn_cal

133: || (reverse chronological order - newest change first)
134: */
135: CURSOR cur_rowid IS
136: SELECT rowid
137: FROM igs_he_sub_rtn_cal
138: WHERE submission_name = x_submission_name
139: AND user_return_subclass = x_user_return_subclass
140: AND return_name = x_return_name
141: AND cal_type = x_cal_type

Line 178: FROM igs_he_sub_rtn_cal

174: || (reverse chronological order - newest change first)
175: */
176: CURSOR cur_rowid IS
177: SELECT rowid
178: FROM igs_he_sub_rtn_cal
179: WHERE ((return_name = x_return_name) AND
180: (submission_name = x_submission_name) AND
181: (user_return_subclass = x_user_return_subclass));
182:

Line 216: FROM igs_he_sub_rtn_cal

212: || (reverse chronological order - newest change first)
213: */
214: CURSOR cur_rowid IS
215: SELECT rowid
216: FROM igs_he_sub_rtn_cal
217: WHERE ((cal_type = x_cal_type) AND
218: (ci_sequence_number = x_sequence_number));
219:
220: lv_rowid cur_rowid%RowType;

Line 342: FROM igs_he_sub_rtn_cal

338: || (reverse chronological order - newest change first)
339: */
340: CURSOR c IS
341: SELECT rowid
342: FROM igs_he_sub_rtn_cal
343: WHERE submission_name = x_submission_name
344: AND user_return_subclass = x_user_return_subclass
345: AND return_name = x_return_name
346: AND cal_type = x_cal_type

Line 374: SELECT igs_he_sub_rtn_cal_s.NEXTVAL

370: igs_ge_msg_stack.add;
371: app_exception.raise_exception;
372: END IF;
373:
374: SELECT igs_he_sub_rtn_cal_s.NEXTVAL
375: INTO x_sub_rtn_cal_id
376: FROM dual;
377:
378: before_dml(

Line 395: INSERT INTO igs_he_sub_rtn_cal (

391: x_last_updated_by => x_last_updated_by,
392: x_last_update_login => x_last_update_login
393: );
394:
395: INSERT INTO igs_he_sub_rtn_cal (
396: sub_rtn_cal_id,
397: submission_name,
398: user_return_subclass,
399: return_name,

Line 457: FROM igs_he_sub_rtn_cal

453: CURSOR c1 IS
454: SELECT
455: sub_rtn_cal_id,
456: fte_prog_pcnt
457: FROM igs_he_sub_rtn_cal
458: WHERE rowid = x_rowid
459: FOR UPDATE NOWAIT;
460:
461: tlinfo c1%ROWTYPE;

Line 554: UPDATE igs_he_sub_rtn_cal

550: x_last_updated_by => x_last_updated_by,
551: x_last_update_login => x_last_update_login
552: );
553:
554: UPDATE igs_he_sub_rtn_cal
555: SET
556: sub_rtn_cal_id = new_references.sub_rtn_cal_id,
557: fte_prog_pcnt = new_references.fte_prog_pcnt,
558: last_update_date = x_last_update_date,

Line 592: FROM igs_he_sub_rtn_cal

588: || (reverse chronological order - newest change first)
589: */
590: CURSOR c1 IS
591: SELECT rowid
592: FROM igs_he_sub_rtn_cal
593: WHERE submission_name = x_submission_name
594: AND user_return_subclass = x_user_return_subclass
595: AND return_name = x_return_name
596: AND cal_type = x_cal_type

Line 655: DELETE FROM igs_he_sub_rtn_cal

651: p_action => 'DELETE',
652: x_rowid => x_rowid
653: );
654:
655: DELETE FROM igs_he_sub_rtn_cal
656: WHERE rowid = x_rowid;
657:
658: IF (SQL%NOTFOUND) THEN
659: RAISE NO_DATA_FOUND;

Line 665: END igs_he_sub_rtn_cal_pkg;

661:
662: END delete_row;
663:
664:
665: END igs_he_sub_rtn_cal_pkg;