APPS.IGF_GR_ELEC_STAT_DET_PKG dependencies on IGF_GR_ELEC_STAT_DET_ALL

Line 5: old_references igf_gr_elec_stat_det_all%ROWTYPE;

1: PACKAGE BODY igf_gr_elec_stat_det_pkg AS
2: /* $Header: IGFGI10B.pls 115.6 2002/11/28 14:17:33 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_elec_stat_det_all%ROWTYPE;
6: new_references igf_gr_elec_stat_det_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_gr_elec_stat_det_all%ROWTYPE;

2: /* $Header: IGFGI10B.pls 115.6 2002/11/28 14:17:33 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_elec_stat_det_all%ROWTYPE;
6: new_references igf_gr_elec_stat_det_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 38: FROM igf_gr_elec_stat_det_all

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

Line 98: FROM igf_gr_elec_stat_det_all

94: || (reverse chronological order - newest change first)
95: */
96: CURSOR cur_rowid IS
97: SELECT rowid
98: FROM igf_gr_elec_stat_det_all
99: WHERE esd_id = x_esd_id
100: FOR UPDATE NOWAIT;
101:
102: lv_rowid cur_rowid%RowType;

Line 217: FROM igf_gr_elec_stat_det_all

213: || (reverse chronological order - newest change first)
214: */
215: CURSOR c IS
216: SELECT rowid
217: FROM igf_gr_elec_stat_det_all
218: WHERE esd_id = x_esd_id;
219:
220: x_last_update_date DATE;
221: x_last_updated_by NUMBER;

Line 228: l_org_id igf_gr_elec_stat_det_all.org_id%TYPE;

224: x_program_id NUMBER;
225: x_program_application_id NUMBER;
226: x_program_update_date DATE;
227:
228: l_org_id igf_gr_elec_stat_det_all.org_id%TYPE;
229:
230: BEGIN
231:
232: l_org_id := igf_aw_gen.get_org_id;

Line 285: INSERT INTO igf_gr_elec_stat_det_all (

281: x_last_updated_by => x_last_updated_by,
282: x_last_update_login => x_last_update_login
283: );
284:
285: INSERT INTO igf_gr_elec_stat_det_all (
286: esd_id,
287: rep_pell_id,
288: duns_id,
289: gaps_award_num,

Line 369: FROM igf_gr_elec_stat_det_all

365: db_cr_flag,
366: adj_amt,
367: gaps_process_date,
368: adj_batch_id
369: FROM igf_gr_elec_stat_det_all
370: WHERE rowid = x_rowid
371: FOR UPDATE NOWAIT;
372:
373: tlinfo c1%ROWTYPE;

Line 494: UPDATE igf_gr_elec_stat_det_all

490: x_program_update_date := SYSDATE;
491: END IF;
492: END IF;
493:
494: UPDATE igf_gr_elec_stat_det_all
495: SET
496: rep_pell_id = new_references.rep_pell_id,
497: duns_id = new_references.duns_id,
498: gaps_award_num = new_references.gaps_award_num,

Line 544: FROM igf_gr_elec_stat_det_all

540: || (reverse chronological order - newest change first)
541: */
542: CURSOR c1 IS
543: SELECT rowid
544: FROM igf_gr_elec_stat_det_all
545: WHERE esd_id = x_esd_id;
546:
547: BEGIN
548:

Line 607: DELETE FROM igf_gr_elec_stat_det_all

603: p_action => 'DELETE',
604: x_rowid => x_rowid
605: );
606:
607: DELETE FROM igf_gr_elec_stat_det_all
608: WHERE rowid = x_rowid;
609:
610: IF (SQL%NOTFOUND) THEN
611: RAISE NO_DATA_FOUND;