eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AW_DP_TEACH_PRDS_PKG dependencies on IGF_AW_DP_TEACH_PRDS

Line 1: PACKAGE BODY igf_aw_dp_teach_prds_pkg AS

1: PACKAGE BODY igf_aw_dp_teach_prds_pkg AS
2: /* $Header: IGFWI61B.pls 120.0 2005/06/01 15:46:00 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_dp_teach_prds%ROWTYPE;

Line 5: old_references igf_aw_dp_teach_prds%ROWTYPE;

1: PACKAGE BODY igf_aw_dp_teach_prds_pkg AS
2: /* $Header: IGFWI61B.pls 120.0 2005/06/01 15:46:00 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_dp_teach_prds%ROWTYPE;
6: new_references igf_aw_dp_teach_prds%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_aw_dp_teach_prds%ROWTYPE;

2: /* $Header: IGFWI61B.pls 120.0 2005/06/01 15:46:00 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_dp_teach_prds%ROWTYPE;
6: new_references igf_aw_dp_teach_prds%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 37: FROM igf_aw_dp_teach_prds

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

Line 173: FROM igf_aw_dp_teach_prds

169: || (reverse chronological order - newest change first)
170: */
171: CURSOR cur_rowid IS
172: SELECT rowid
173: FROM igf_aw_dp_teach_prds
174: WHERE adteach_id = x_adteach_id
175: FOR UPDATE NOWAIT;
176:
177: lv_rowid cur_rowid%RowType;

Line 208: FROM igf_aw_dp_teach_prds

204: || (reverse chronological order - newest change first)
205: */
206: CURSOR cur_rowid IS
207: SELECT rowid
208: FROM igf_aw_dp_teach_prds
209: WHERE ((adterms_id = x_adterms_id));
210:
211: lv_rowid cur_rowid%RowType;
212:

Line 243: FROM igf_aw_dp_teach_prds

239: || (reverse chronological order - newest change first)
240: */
241: CURSOR cur_rowid IS
242: SELECT rowid
243: FROM igf_aw_dp_teach_prds
244: WHERE ((tp_cal_type = x_cal_type) AND
245: (tp_sequence_number = x_sequence_number));
246:
247: lv_rowid cur_rowid%ROWTYPE;

Line 278: FROM igf_aw_dp_teach_prds

274: || (reverse chronological order - newest change first)
275: */
276: CURSOR cur_rowid IS
277: SELECT rowid
278: FROM igf_aw_dp_teach_prds
279: WHERE ((date_offset_cd = x_dt_alias));
280:
281: lv_rowid cur_rowid%ROWTYPE;
282:

Line 320: FROM igf_aw_dp_teach_prds

316: -- the column date_offset_cd
317: -------------------------------------------------------------------
318: CURSOR cur_rowid IS
319: SELECT rowid
320: FROM igf_aw_dp_teach_prds
321: WHERE adterms_id = x_adterms_id
322: AND tp_cal_type = x_tp_cal_type
323: AND tp_sequence_number = x_tp_sequence_number
324: AND NVL(date_offset_cd,'*') = NVL(x_date_offset_cd,'*')

Line 465: fnd_message.set_token ('ROUTINE', 'IGF_AW_DP_TEACH_PRDS_PKG.INSERT_ROW');

461: x_last_update_login := -1;
462: END IF;
463: ELSE
464: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
465: fnd_message.set_token ('ROUTINE', 'IGF_AW_DP_TEACH_PRDS_PKG.INSERT_ROW');
466: igs_ge_msg_stack.add;
467: app_exception.raise_exception;
468: END IF;
469:

Line 490: INSERT INTO igf_aw_dp_teach_prds (

486: x_last_updated_by => x_last_updated_by,
487: x_last_update_login => x_last_update_login
488: );
489:
490: INSERT INTO igf_aw_dp_teach_prds (
491: adteach_id,
492: adterms_id,
493: tp_cal_type,
494: tp_sequence_number,

Line 505: igf_aw_dp_teach_prds_s.NEXTVAL,

501: last_update_date,
502: last_updated_by,
503: last_update_login
504: ) VALUES (
505: igf_aw_dp_teach_prds_s.NEXTVAL,
506: new_references.adterms_id,
507: new_references.tp_cal_type,
508: new_references.tp_sequence_number,
509: new_references.tp_perct_num,

Line 552: FROM igf_aw_dp_teach_prds

548: tp_perct_num,
549: date_offset_cd,
550: attendance_type_code,
551: credit_points_num
552: FROM igf_aw_dp_teach_prds
553: WHERE rowid = x_rowid
554: FOR UPDATE NOWAIT;
555:
556: tlinfo c1%ROWTYPE;

Line 634: fnd_message.set_token ('ROUTINE', 'IGF_AW_DP_TEACH_PRDS_PKG.UPDATE_ROW');

630: x_last_update_login := -1;
631: END IF;
632: ELSE
633: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
634: fnd_message.set_token ('ROUTINE', 'IGF_AW_DP_TEACH_PRDS_PKG.UPDATE_ROW');
635: igs_ge_msg_stack.add;
636: app_exception.raise_exception;
637: END IF;
638:

Line 657: UPDATE igf_aw_dp_teach_prds

653: x_last_updated_by => x_last_updated_by,
654: x_last_update_login => x_last_update_login
655: );
656:
657: UPDATE igf_aw_dp_teach_prds
658: SET
659: adterms_id = new_references.adterms_id,
660: tp_cal_type = new_references.tp_cal_type,
661: tp_sequence_number = new_references.tp_sequence_number,

Line 701: FROM igf_aw_dp_teach_prds

697: || (reverse chronological order - newest change first)
698: */
699: CURSOR c1 IS
700: SELECT rowid
701: FROM igf_aw_dp_teach_prds
702: WHERE adteach_id = x_adteach_id;
703:
704: BEGIN
705:

Line 762: DELETE FROM igf_aw_dp_teach_prds

758: p_action => 'DELETE',
759: x_rowid => x_rowid
760: );
761:
762: DELETE FROM igf_aw_dp_teach_prds
763: WHERE rowid = x_rowid;
764:
765: IF (SQL%NOTFOUND) THEN
766: RAISE NO_DATA_FOUND;

Line 772: END igf_aw_dp_teach_prds_pkg;

768:
769: END delete_row;
770:
771:
772: END igf_aw_dp_teach_prds_pkg;