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_PELL_SETUP_PKG dependencies on IGF_GR_PELL_SETUP_ALL

Line 5: old_references igf_gr_pell_setup_all%ROWTYPE;

1: PACKAGE BODY igf_gr_pell_setup_pkg AS
2: /* $Header: IGFGI02B.pls 120.1 2006/04/18 04:45:13 akomurav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_pell_setup_all%ROWTYPE;
6: new_references igf_gr_pell_setup_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_gr_pell_setup_all%ROWTYPE;

2: /* $Header: IGFGI02B.pls 120.1 2006/04/18 04:45:13 akomurav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_pell_setup_all%ROWTYPE;
6: new_references igf_gr_pell_setup_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 59: FROM IGF_GR_PELL_SETUP_ALL

55: */
56:
57: CURSOR cur_old_ref_values IS
58: SELECT *
59: FROM IGF_GR_PELL_SETUP_ALL
60: WHERE rowid = x_rowid;
61:
62: BEGIN
63:

Line 224: FROM igf_gr_pell_setup_all

220: || (reverse chronological order - newest change first)
221: */
222: CURSOR cur_rowid IS
223: SELECT rowid
224: FROM igf_gr_pell_setup_all
225: WHERE pell_seq_id = x_pell_seq_id
226: FOR UPDATE NOWAIT;
227:
228: lv_rowid cur_rowid%RowType;

Line 266: FROM igf_gr_pell_setup_all

262: || (reverse chronological order - newest change first)
263: */
264: CURSOR cur_rowid IS
265: SELECT rowid
266: FROM igf_gr_pell_setup_all
267: WHERE ci_cal_type = x_ci_cal_type
268: AND ci_sequence_number = x_ci_sequence_number
269: AND ((l_rowid IS NULL) OR (rowid <> l_rowid))
270: AND NVL(rep_pell_id,-1) = NVL(x_rep_pell_id,-1)

Line 306: FROM igf_gr_pell_setup_all

302: || (reverse chronological order - newest change first)
303: */
304: CURSOR cur_rowid IS
305: SELECT rowid
306: FROM igf_gr_pell_setup_all
307: WHERE ((ci_cal_type = x_cal_type) AND
308: (ci_sequence_number = x_sequence_number));
309:
310: lv_rowid cur_rowid%RowType;

Line 342: FROM igf_gr_pell_setup_all

338: || (reverse chronological order - newest change first)
339: */
340: CURSOR cur_rowid IS
341: SELECT rowid
342: FROM igf_gr_pell_setup_all
343: WHERE ((course_cd = x_course_cd) AND
344: (version_number = x_version_number));
345:
346: lv_rowid cur_rowid%RowType;

Line 377: FROM igf_gr_pell_setup_all

373: || (reverse chronological order - newest change first)
374: */
375: CURSOR cur_rowid IS
376: SELECT rowid
377: FROM igf_gr_pell_setup_all
378: WHERE rep_pell_id = x_rep_pell_cd ;
379:
380: lv_rowid cur_rowid%RowType;
381:

Line 411: FROM igf_gr_pell_setup_all

407: || (reverse chronological order - newest change first)
408: */
409: CURSOR cur_rowid IS
410: SELECT rowid
411: FROM igf_gr_pell_setup_all
412: WHERE rep_entity_id_txt = x_rep_entity_id_txt;
413:
414: lv_rowid cur_rowid%RowType;
415:

Line 451: FROM igf_gr_pell_setup_all

447: CURSOR cur_get_child(p_rep_pell_id VARCHAR2,
448: p_ci_cal_type VARCHAR2,
449: p_ci_sequence_number NUMBER) IS
450: SELECT COUNT(*) num_of_rec
451: FROM igf_gr_pell_setup_all
452: WHERE REP_PELL_ID = p_rep_pell_id
453: AND CI_CAL_TYPE = p_ci_cal_type
454: AND CI_SEQUENCE_NUMBER = p_ci_sequence_number;
455:

Line 651: FROM igf_gr_pell_setup_all

647: || (reverse chronological order - newest change first)
648: */
649: CURSOR c IS
650: SELECT rowid
651: FROM igf_gr_pell_setup_all
652: WHERE pell_seq_id = x_pell_seq_id;
653:
654: x_last_update_date DATE;
655: x_last_updated_by NUMBER;

Line 657: l_org_id igf_gr_pell_setup_all.org_id%TYPE;

653:
654: x_last_update_date DATE;
655: x_last_updated_by NUMBER;
656: x_last_update_login NUMBER;
657: l_org_id igf_gr_pell_setup_all.org_id%TYPE;
658:
659: BEGIN
660:
661: l_org_id := igf_aw_gen.get_org_id;

Line 723: INSERT INTO igf_gr_pell_setup_all (

719: x_term_start_offset_num => x_term_start_offset_num
720:
721: );
722:
723: INSERT INTO igf_gr_pell_setup_all (
724: pell_seq_id,
725: ci_cal_type,
726: ci_sequence_number,
727: rep_pell_id,

Line 874: FROM igf_gr_pell_setup_all

870: rep_entity_id_txt,
871: response_option_code,
872: term_start_offset_num
873:
874: FROM igf_gr_pell_setup_all
875: WHERE rowid = x_rowid
876: FOR UPDATE NOWAIT;
877:
878: tlinfo c1%ROWTYPE;

Line 1041: UPDATE igf_gr_pell_setup_all

1037: x_term_start_offset_num => x_term_start_offset_num
1038:
1039: );
1040:
1041: UPDATE igf_gr_pell_setup_all
1042: SET
1043: ci_cal_type = new_references.ci_cal_type,
1044: ci_sequence_number = new_references.ci_sequence_number,
1045: rep_pell_id = new_references.rep_pell_id,

Line 1126: FROM igf_gr_pell_setup_all

1122: || (reverse chronological order - newest change first)
1123: */
1124: CURSOR c1 IS
1125: SELECT rowid
1126: FROM igf_gr_pell_setup_all
1127: WHERE pell_seq_id = x_pell_seq_id;
1128:
1129: BEGIN
1130:

Line 1230: DELETE FROM igf_gr_pell_setup_all

1226: p_action => 'DELETE',
1227: x_rowid => x_rowid
1228: );
1229:
1230: DELETE FROM igf_gr_pell_setup_all
1231: WHERE rowid = x_rowid;
1232:
1233: IF (SQL%NOTFOUND) THEN
1234: RAISE NO_DATA_FOUND;