APPS.IGS_HE_FTE_CAL_PRD_PKG dependencies on IGS_HE_FTE_CAL_PRD

Line 1: PACKAGE BODY igs_he_fte_cal_prd_pkg AS

1: PACKAGE BODY igs_he_fte_cal_prd_pkg AS
2: /* $Header: IGSWI30B.pls 115.3 2002/12/20 10:29:30 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_fte_cal_prd%ROWTYPE;

Line 5: old_references igs_he_fte_cal_prd%ROWTYPE;

1: PACKAGE BODY igs_he_fte_cal_prd_pkg AS
2: /* $Header: IGSWI30B.pls 115.3 2002/12/20 10:29:30 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_fte_cal_prd%ROWTYPE;
6: new_references igs_he_fte_cal_prd%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_fte_cal_prd%ROWTYPE;

2: /* $Header: IGSWI30B.pls 115.3 2002/12/20 10:29:30 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_fte_cal_prd%ROWTYPE;
6: new_references igs_he_fte_cal_prd%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 33: FROM igs_he_fte_cal_prd

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

Line 86: igs_he_fte_proprt_pkg.get_fk_igs_he_fte_cal_prd (

82: || (reverse chronological order - newest change first)
83: */
84: BEGIN
85:
86: igs_he_fte_proprt_pkg.get_fk_igs_he_fte_cal_prd (
87: old_references.fte_cal_type,
88: old_references.fte_sequence_num
89: );
90:

Line 152: FROM igs_he_fte_cal_prd

148: || (reverse chronological order - newest change first)
149: */
150: CURSOR cur_rowid IS
151: SELECT rowid
152: FROM igs_he_fte_cal_prd
153: WHERE fte_cal_type = x_fte_cal_type
154: AND fte_sequence_num = x_fte_sequence_num
155: FOR UPDATE NOWAIT;
156:

Line 189: FROM igs_he_fte_cal_prd

185: || (reverse chronological order - newest change first)
186: */
187: CURSOR cur_rowid IS
188: SELECT rowid
189: FROM igs_he_fte_cal_prd
190: WHERE ((teach_cal_type = x_teach_cal_type) AND
191: (teach_sequence_num = x_teach_sequence_num));
192:
193: lv_rowid cur_rowid%RowType;

Line 226: FROM igs_he_fte_cal_prd

222: || (reverse chronological order - newest change first)
223: */
224: CURSOR cur_rowid IS
225: SELECT rowid
226: FROM igs_he_fte_cal_prd
227: WHERE ((fte_cal_type = x_fte_cal_type) AND
228: (fte_sequence_num = x_fte_sequence_num));
229:
230: lv_rowid cur_rowid%RowType;

Line 342: FROM igs_he_fte_cal_prd

338: || (reverse chronological order - newest change first)
339: */
340: CURSOR c IS
341: SELECT rowid
342: FROM igs_he_fte_cal_prd
343: WHERE fte_cal_type = x_fte_cal_type
344: AND fte_sequence_num = x_fte_sequence_num;
345:
346: x_last_update_date DATE;

Line 385: INSERT INTO igs_he_fte_cal_prd (

381: x_last_updated_by => x_last_updated_by,
382: x_last_update_login => x_last_update_login
383: );
384:
385: INSERT INTO igs_he_fte_cal_prd (
386: fte_cal_type,
387: fte_sequence_num,
388: teach_cal_type,
389: teach_sequence_num,

Line 438: FROM igs_he_fte_cal_prd

434: CURSOR c1 IS
435: SELECT
436: teach_cal_type,
437: teach_sequence_num
438: FROM igs_he_fte_cal_prd
439: WHERE rowid = x_rowid
440: FOR UPDATE NOWAIT;
441:
442: tlinfo c1%ROWTYPE;

Line 529: UPDATE igs_he_fte_cal_prd

525: x_last_updated_by => x_last_updated_by,
526: x_last_update_login => x_last_update_login
527: );
528:
529: UPDATE igs_he_fte_cal_prd
530: SET
531: teach_cal_type = new_references.teach_cal_type,
532: teach_sequence_num = new_references.teach_sequence_num,
533: last_update_date = x_last_update_date,

Line 564: FROM igs_he_fte_cal_prd

560: || (reverse chronological order - newest change first)
561: */
562: CURSOR c1 IS
563: SELECT rowid
564: FROM igs_he_fte_cal_prd
565: WHERE fte_cal_type = x_fte_cal_type
566: AND fte_sequence_num = x_fte_sequence_num;
567:
568: BEGIN

Line 618: DELETE FROM igs_he_fte_cal_prd

614: p_action => 'DELETE',
615: x_rowid => x_rowid
616: );
617:
618: DELETE FROM igs_he_fte_cal_prd
619: WHERE rowid = x_rowid;
620:
621: IF (SQL%NOTFOUND) THEN
622: RAISE NO_DATA_FOUND;

Line 628: END igs_he_fte_cal_prd_pkg;

624:
625: END delete_row;
626:
627:
628: END igs_he_fte_cal_prd_pkg;