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_GR_REPORT_PELL_PKG dependencies on IGF_GR_REPORT_PELL

Line 1: PACKAGE BODY IGF_GR_REPORT_PELL_PKG AS

1: PACKAGE BODY IGF_GR_REPORT_PELL_PKG AS
2: /* $Header: IGFGI20B.pls 120.0 2005/06/01 13:50:49 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_report_pell%ROWTYPE;

Line 5: old_references igf_gr_report_pell%ROWTYPE;

1: PACKAGE BODY IGF_GR_REPORT_PELL_PKG AS
2: /* $Header: IGFGI20B.pls 120.0 2005/06/01 13:50:49 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_report_pell%ROWTYPE;
6: new_references igf_gr_report_pell%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_gr_report_pell%ROWTYPE;

2: /* $Header: IGFGI20B.pls 120.0 2005/06/01 13:50:49 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_report_pell%ROWTYPE;
6: new_references igf_gr_report_pell%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 35: FROM igf_gr_report_pell

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

Line 119: igf_gr_attend_pell_pkg.get_fk_igf_gr_report_pell (

115: || (reverse chronological order - newest change first)
116: */
117: BEGIN
118:
119: igf_gr_attend_pell_pkg.get_fk_igf_gr_report_pell (
120: old_references.rcampus_id
121: );
122:
123: igf_gr_pell_setup_pkg.get_fk_igf_gr_report_pell (

Line 123: igf_gr_pell_setup_pkg.get_fk_igf_gr_report_pell (

119: igf_gr_attend_pell_pkg.get_fk_igf_gr_report_pell (
120: old_references.rcampus_id
121: );
122:
123: igf_gr_pell_setup_pkg.get_fk_igf_gr_report_pell (
124: old_references.reporting_pell_cd
125: );
126:
127: igf_gr_pell_setup_pkg.get_fk_igf_gr_report_ent (

Line 147: FROM igf_gr_report_pell

143: || (reverse chronological order - newest change first)
144: */
145: CURSOR cur_rowid IS
146: SELECT rowid
147: FROM igf_gr_report_pell
148: WHERE rcampus_id = x_rcampus_id
149: FOR UPDATE NOWAIT;
150:
151: lv_rowid cur_rowid%RowType;

Line 183: FROM igf_gr_report_pell

179: || (reverse chronological order - newest change first)
180: */
181: CURSOR cur_rowid IS
182: SELECT rowid
183: FROM igf_gr_report_pell
184: WHERE ((ci_cal_type = x_cal_type) AND
185: (ci_sequence_number = x_sequence_number));
186:
187: lv_rowid cur_rowid%RowType;

Line 326: fnd_message.set_token ('ROUTINE', 'IGF_GR_REPORT_PELL_PKG.INSERT_ROW');

322: x_last_update_login := -1;
323: END IF;
324: ELSE
325: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
326: fnd_message.set_token ('ROUTINE', 'IGF_GR_REPORT_PELL_PKG.INSERT_ROW');
327: igs_ge_msg_stack.add;
328: app_exception.raise_exception;
329: END IF;
330:

Line 349: INSERT INTO igf_gr_report_pell (

345: x_last_updated_by => x_last_updated_by,
346: x_last_update_login => x_last_update_login
347: );
348:
349: INSERT INTO igf_gr_report_pell (
350: rcampus_id,
351: ci_cal_type,
352: ci_sequence_number,
353: reporting_pell_cd,

Line 362: igf_gr_report_pell_s.NEXTVAL,

358: last_update_date,
359: last_updated_by,
360: last_update_login
361: ) VALUES (
362: igf_gr_report_pell_s.NEXTVAL,
363: new_references.ci_cal_type,
364: new_references.ci_sequence_number,
365: new_references.reporting_pell_cd,
366: new_references.ope_cd,

Line 404: FROM igf_gr_report_pell

400: ci_sequence_number,
401: reporting_pell_cd,
402: ope_cd,
403: rep_entity_id_txt
404: FROM igf_gr_report_pell
405: WHERE rowid = x_rowid
406: FOR UPDATE NOWAIT;
407:
408: tlinfo c1%ROWTYPE;

Line 482: fnd_message.set_token ('ROUTINE', 'IGF_GR_REPORT_PELL_PKG.UPDATE_ROW');

478: x_last_update_login := -1;
479: END IF;
480: ELSE
481: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
482: fnd_message.set_token ('ROUTINE', 'IGF_GR_REPORT_PELL_PKG.UPDATE_ROW');
483: igs_ge_msg_stack.add;
484: app_exception.raise_exception;
485: END IF;
486:

Line 503: UPDATE igf_gr_report_pell

499: x_last_updated_by => x_last_updated_by,
500: x_last_update_login => x_last_update_login
501: );
502:
503: UPDATE igf_gr_report_pell
504: SET
505: ci_cal_type = new_references.ci_cal_type,
506: ci_sequence_number = new_references.ci_sequence_number,
507: reporting_pell_cd = new_references.reporting_pell_cd,

Line 543: FROM igf_gr_report_pell

539: || (reverse chronological order - newest change first)
540: */
541: CURSOR c1 IS
542: SELECT rowid
543: FROM igf_gr_report_pell
544: WHERE rcampus_id = x_rcampus_id;
545:
546: BEGIN
547:

Line 600: DELETE FROM igf_gr_report_pell

596: p_action => 'DELETE',
597: x_rowid => x_rowid
598: );
599:
600: DELETE FROM igf_gr_report_pell
601: WHERE rowid = x_rowid;
602:
603: IF (SQL%NOTFOUND) THEN
604: RAISE NO_DATA_FOUND;

Line 664: FROM igf_gr_report_pell

660: || (reverse chronological order - newest change first)
661: */
662: CURSOR cur_rowid IS
663: SELECT rowid
664: FROM igf_gr_report_pell
665: WHERE NVL(reporting_pell_cd,'*') = NVL(x_rep_pell,'*')
666: AND ci_cal_type = x_ci_cal_type
667: AND ci_sequence_number = x_ci_sequence_number
668: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 700: FROM igf_gr_report_pell

696: || (reverse chronological order - newest change first)
697: */
698: CURSOR cur_rowid IS
699: SELECT rowid
700: FROM igf_gr_report_pell
701: WHERE NVL(rep_entity_id_txt,'*') = NVL(x_rep_entity_id_txt,'*')
702: AND ci_cal_type = x_ci_cal_type
703: AND ci_sequence_number = x_ci_sequence_number
704: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 721: END igf_gr_report_pell_pkg;

717: END IF;
718: END get_uk2_for_validation ;
719:
720:
721: END igf_gr_report_pell_pkg;
722: