APPS.IGF_GR_MRR_PKG dependencies on IGF_GR_MRR_ALL

Line 5: old_references igf_gr_mrr_all%ROWTYPE;

1: PACKAGE BODY igf_gr_mrr_pkg AS
2: /* $Header: IGFGI12B.pls 115.7 2002/11/28 14:18:06 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_mrr_all%ROWTYPE;
6: new_references igf_gr_mrr_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_gr_mrr_all%ROWTYPE;

2: /* $Header: IGFGI12B.pls 115.7 2002/11/28 14:18:06 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_mrr_all%ROWTYPE;
6: new_references igf_gr_mrr_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 65: FROM igf_gr_mrr_all

61: */
62:
63: CURSOR cur_old_ref_values IS
64: SELECT *
65: FROM igf_gr_mrr_all
66: WHERE rowid = x_rowid;
67:
68: BEGIN
69:

Line 152: FROM igf_gr_mrr_all

148: || (reverse chronological order - newest change first)
149: */
150: CURSOR cur_rowid IS
151: SELECT rowid
152: FROM igf_gr_mrr_all
153: WHERE mrr_id = x_mrr_id
154: FOR UPDATE NOWAIT;
155:
156: lv_rowid cur_rowid%RowType;

Line 352: FROM igf_gr_mrr_all

348: || (reverse chronological order - newest change first)
349: */
350: CURSOR c IS
351: SELECT rowid
352: FROM igf_gr_mrr_all
353: WHERE mrr_id = x_mrr_id;
354:
355: x_last_update_date DATE;
356: x_last_updated_by NUMBER;

Line 363: l_org_id igf_gr_mrr_all.org_id%TYPE;

359: x_program_id NUMBER;
360: x_program_application_id NUMBER;
361: x_program_update_date DATE;
362:
363: l_org_id igf_gr_mrr_all.org_id%TYPE;
364:
365: BEGIN
366:
367: l_org_id := igf_aw_gen.get_org_id;

Line 448: INSERT INTO igf_gr_mrr_all (

444: x_last_update_login => x_last_update_login,
445: x_current_ssn => x_current_ssn
446: );
447:
448: INSERT INTO igf_gr_mrr_all (
449: mrr_id,
450: record_type,
451: req_inst_pell_id,
452: mrr_code1,

Line 640: FROM igf_gr_mrr_all

636: stud_first_name,
637: stud_middle_name,
638: stud_dob,
639: current_ssn
640: FROM igf_gr_mrr_all
641: WHERE rowid = x_rowid
642: FOR UPDATE NOWAIT;
643:
644: tlinfo c1%ROWTYPE;

Line 846: UPDATE igf_gr_mrr_all

842: x_program_update_date := SYSDATE;
843: END IF;
844: END IF;
845:
846: UPDATE igf_gr_mrr_all
847: SET
848: record_type = new_references.record_type,
849: req_inst_pell_id = new_references.req_inst_pell_id,
850: mrr_code1 = new_references.mrr_code1,

Line 950: FROM igf_gr_mrr_all

946: || (reverse chronological order - newest change first)
947: */
948: CURSOR c1 IS
949: SELECT rowid
950: FROM igf_gr_mrr_all
951: WHERE mrr_id = x_mrr_id;
952:
953: BEGIN
954:

Line 1067: DELETE FROM igf_gr_mrr_all

1063: p_action => 'DELETE',
1064: x_rowid => x_rowid
1065: );
1066:
1067: DELETE FROM igf_gr_mrr_all
1068: WHERE rowid = x_rowid;
1069:
1070: IF (SQL%NOTFOUND) THEN
1071: RAISE NO_DATA_FOUND;