APPS.IGF_GR_ATTEND_PELL_PKG dependencies on IGF_GR_ATTEND_PELL

Line 1: PACKAGE BODY igf_gr_attend_pell_pkg AS

1: PACKAGE BODY igf_gr_attend_pell_pkg AS
2: /* $Header: IGFGI21B.pls 120.0 2005/06/01 15:38:41 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_attend_pell%ROWTYPE;

Line 5: old_references igf_gr_attend_pell%ROWTYPE;

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

Line 6: new_references igf_gr_attend_pell%ROWTYPE;

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

Line 36: FROM igf_gr_attend_pell

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

Line 120: FROM igf_gr_attend_pell

116: || (reverse chronological order - newest change first)
117: */
118: CURSOR cur_rowid IS
119: SELECT rowid
120: FROM igf_gr_attend_pell
121: WHERE acampus_id = x_acampus_id
122: FOR UPDATE NOWAIT;
123:
124: lv_rowid cur_rowid%RowType;

Line 155: FROM igf_gr_attend_pell

151: || (reverse chronological order - newest change first)
152: */
153: CURSOR cur_attend IS
154: SELECT *
155: FROM igf_gr_attend_pell
156: WHERE ((rcampus_id = x_rcampus_id));
157:
158: attend_rec cur_attend%rowtype;
159:

Line 301: fnd_message.set_token ('ROUTINE', 'IGF_GR_ATTEND_PELL_PKG.INSERT_ROW');

297: x_last_update_login := -1;
298: END IF;
299: ELSE
300: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
301: fnd_message.set_token ('ROUTINE', 'IGF_GR_ATTEND_PELL_PKG.INSERT_ROW');
302: igs_ge_msg_stack.add;
303: app_exception.raise_exception;
304: END IF;
305:

Line 325: INSERT INTO igf_gr_attend_pell (

321: x_last_updated_by => x_last_updated_by,
322: x_last_update_login => x_last_update_login
323: );
324:
325: INSERT INTO igf_gr_attend_pell (
326: acampus_id,
327: rcampus_id,
328: ci_cal_type,
329: ci_sequence_number,

Line 339: igf_gr_attend_pell_s.NEXTVAL,

335: last_update_date,
336: last_updated_by,
337: last_update_login
338: ) VALUES (
339: igf_gr_attend_pell_s.NEXTVAL,
340: new_references.rcampus_id,
341: new_references.ci_cal_type,
342: new_references.ci_sequence_number,
343: new_references.attending_pell_cd,

Line 383: FROM igf_gr_attend_pell

379: ci_sequence_number,
380: attending_pell_cd,
381: ope_cd,
382: atd_entity_id_txt
383: FROM igf_gr_attend_pell
384: WHERE rowid = x_rowid
385: FOR UPDATE NOWAIT;
386:
387: tlinfo c1%ROWTYPE;

Line 463: fnd_message.set_token ('ROUTINE', 'IGF_GR_ATTEND_PELL_PKG.UPDATE_ROW');

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

Line 485: UPDATE igf_gr_attend_pell

481: x_last_updated_by => x_last_updated_by,
482: x_last_update_login => x_last_update_login
483: );
484:
485: UPDATE igf_gr_attend_pell
486: SET
487: rcampus_id = new_references.rcampus_id,
488: ci_cal_type = new_references.ci_cal_type,
489: ci_sequence_number = new_references.ci_sequence_number,

Line 527: FROM igf_gr_attend_pell

523: || (reverse chronological order - newest change first)
524: */
525: CURSOR c1 IS
526: SELECT rowid
527: FROM igf_gr_attend_pell
528: WHERE acampus_id = x_acampus_id;
529:
530: BEGIN
531:

Line 586: DELETE FROM igf_gr_attend_pell

582: p_action => 'DELETE',
583: x_rowid => x_rowid
584: );
585:
586: DELETE FROM igf_gr_attend_pell
587: WHERE rowid = x_rowid;
588:
589: IF (SQL%NOTFOUND) THEN
590: RAISE NO_DATA_FOUND;

Line 637: FROM igf_gr_attend_pell

633: ) RETURN BOOLEAN AS
634:
635: CURSOR cur_rowid IS
636: SELECT rowid
637: FROM igf_gr_attend_pell
638: WHERE NVL(attending_pell_cd,'*') = NVL(x_attending_pell_cd,'*')
639: AND ci_cal_type = x_ci_cal_type
640: AND ci_sequence_number = x_ci_sequence_number
641: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 665: FROM igf_gr_attend_pell

661: ) RETURN BOOLEAN AS
662:
663: CURSOR cur_rowid IS
664: SELECT rowid
665: FROM igf_gr_attend_pell
666: WHERE NVL(atd_entity_id_txt,'*') = NVL(x_atd_entity_id_txt,'*')
667: AND ci_cal_type = x_ci_cal_type
668: AND ci_sequence_number = x_ci_sequence_number
669: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 686: END igf_gr_attend_pell_pkg;

682: END IF;
683: END get_uk2_for_validation ;
684:
685:
686: END igf_gr_attend_pell_pkg;