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_ESS_ESD_DATA dependencies on IGF_GR_ELEC_STAT_SUM

Line 7: Purpose : To Load the data into IGF_GR_ELEC_STAT_SUM and IGF_GR_ELEC_STAT_DET tables

3:
4: /***************************************************************
5: Created By : adhawan
6: Date Created By : 2000/12/20
7: Purpose : To Load the data into IGF_GR_ELEC_STAT_SUM and IGF_GR_ELEC_STAT_DET tables
8:
9: Known Limitations,Enhancements or Remarks
10: Change History :
11: Who When What

Line 31: p_ess_rec OUT NOCOPY igf_gr_elec_stat_sum%ROWTYPE )

27: g_c_alt_code VARCHAR2(80) DEFAULT NULL; -- To hold alternate code.
28:
29:
30: PROCEDURE split_ess_fields ( p_record_data IN igf_gr_load_file_t.record_data%TYPE,
31: p_ess_rec OUT NOCOPY igf_gr_elec_stat_sum%ROWTYPE )
32: AS
33: /***************************************************************
34: Created By : avenkatr
35: Date Created By : 2000/12/20

Line 37: into the different columns of igf_gr_elec_stat_sum table

33: /***************************************************************
34: Created By : avenkatr
35: Date Created By : 2000/12/20
36: Purpose : To split data in the single record_data column of igf_gr_load_file_t
37: into the different columns of igf_gr_elec_stat_sum table
38:
39: Known Limitations,Enhancements or Remarks
40: Change History :
41: Who When What

Line 131: into the different columns of igf_gr_elec_stat_sum table

127: /***************************************************************
128: Created By : avenkatr
129: Date Created By : 2000/12/20
130: Purpose : To split data in the single record_data column of igf_gr_load_file_t
131: into the different columns of igf_gr_elec_stat_sum table
132:
133: Known Limitations,Enhancements or Remarks
134: Change History :
135: Who When What

Line 196: PROCEDURE insert_in_ess_table ( p_ess_rec IN igf_gr_elec_stat_sum%ROWTYPE )

192:
193: END split_esd_fields;
194:
195:
196: PROCEDURE insert_in_ess_table ( p_ess_rec IN igf_gr_elec_stat_sum%ROWTYPE )
197: AS
198: /***************************************************************
199: Created By : avenkatr
200: Date Created By : 2000/12/19

Line 201: Purpose : To Load data into igf_gr_elec_stat_sum table

197: AS
198: /***************************************************************
199: Created By : avenkatr
200: Date Created By : 2000/12/19
201: Purpose : To Load data into igf_gr_elec_stat_sum table
202:
203: Known Limitations,Enhancements or Remarks
204: Change History :
205: Who When What

Line 212: /* Call the table handler of the table igf_gr_elec_stat_sum to insert data */

208: lv_rowid VARCHAR2(25);
209: lv_ess_id NUMBER;
210:
211: BEGIN
212: /* Call the table handler of the table igf_gr_elec_stat_sum to insert data */
213: igf_gr_elec_stat_sum_pkg.insert_row (
214: x_mode => 'R',
215: x_rowid => lv_rowid,
216: x_acct_schedule_number => p_ess_rec.acct_schedule_number,

Line 213: igf_gr_elec_stat_sum_pkg.insert_row (

209: lv_ess_id NUMBER;
210:
211: BEGIN
212: /* Call the table handler of the table igf_gr_elec_stat_sum to insert data */
213: igf_gr_elec_stat_sum_pkg.insert_row (
214: x_mode => 'R',
215: x_rowid => lv_rowid,
216: x_acct_schedule_number => p_ess_rec.acct_schedule_number,
217: x_acct_schedule_date => p_ess_rec.acct_schedule_date,

Line 251: Purpose : To Load data into igf_gr_elec_stat_sum table

247: AS
248: /***************************************************************
249: Created By : avenkatr
250: Date Created By : 2000/12/19
251: Purpose : To Load data into igf_gr_elec_stat_sum table
252:
253: Known Limitations,Enhancements or Remarks
254: Change History :
255: Who When What

Line 290: Purpose : To Load the data into IGF_GR_ELEC_STAT_SUM table

286: PROCEDURE ess_load IS
287: /***************************************************************
288: Created By : adhawan
289: Date Created By : 2000/12/20
290: Purpose : To Load the data into IGF_GR_ELEC_STAT_SUM table
291:
292: Known Limitations,Enhancements or Remarks
293: Change History :
294: -- Who When What

Line 347: lv_ess_row igf_gr_elec_stat_sum%ROWTYPE;

343: ORDER BY
344: gldr_id;
345:
346: ess_rec_data c_ess_data%ROWTYPE;
347: lv_ess_row igf_gr_elec_stat_sum%ROWTYPE;
348:
349: BEGIN
350: --
351: -- Check for the type of data in the Flat File

Line 441: Purpose : To Load the data into IGF_GR_ELEC_STAT_SUM table

437: PROCEDURE esd_load IS
438: /***************************************************************
439: Created By : adhawan
440: Date Created By : 2000/12/20
441: Purpose : To Load the data into IGF_GR_ELEC_STAT_SUM table
442:
443: Known Limitations,Enhancements or Remarks
444: Change History :
445: -- Who When What

Line 593: Purpose : To Load the IGF_GR_ELEC_STAT_SUM and IGF_GR_ELEC_STAT_DET table

589: AS
590: /***************************************************************
591: Created By : adhawan
592: Date Created By : 2000/12/20
593: Purpose : To Load the IGF_GR_ELEC_STAT_SUM and IGF_GR_ELEC_STAT_DET table
594:
595: Known Limitations,Enhancements or Remarks
596: Change History :
597: Who When What

Line 693: Purpose : To Load the IGF_GR_ELEC_STAT_SUM and IGF_GR_ELEC_STAT_DET table

689: AS
690: /***************************************************************
691: Created By : adhawan
692: Date Created By : 2000/12/20
693: Purpose : To Load the IGF_GR_ELEC_STAT_SUM and IGF_GR_ELEC_STAT_DET table
694:
695: Known Limitations,Enhancements or Remarks
696: Change History :
697: Who When What