APPS.IGF_GR_ESS_ESD_DATA dependencies on IGF_GR_LOAD_FILE_T

Line 30: PROCEDURE split_ess_fields ( p_record_data IN igf_gr_load_file_t.record_data%TYPE,

26: g_ver_num VARCHAR2(30) DEFAULT NULL; -- Flat File Version Number
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

Line 36: Purpose : To split data in the single record_data column of igf_gr_load_file_t

32: AS
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 :

Line 124: PROCEDURE split_esd_fields ( p_record_data IN igf_gr_load_file_t.record_data%TYPE,

120:
121: END split_ess_fields;
122:
123:
124: PROCEDURE split_esd_fields ( p_record_data IN igf_gr_load_file_t.record_data%TYPE,
125: p_esd_rec OUT NOCOPY igf_gr_elec_stat_det%ROWTYPE )
126: AS
127: /***************************************************************
128: Created By : avenkatr

Line 130: Purpose : To split data in the single record_data column of igf_gr_load_file_t

126: AS
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 :

Line 338: igf_gr_load_file_t

334: IS
335: SELECT
336: record_data
337: FROM
338: igf_gr_load_file_t
339: WHERE
340: gldr_id BETWEEN 2 AND (l_last_gldr_id - 1)
341: AND
342: file_type = 'ESS'

Line 487: igf_gr_load_file_t

483: IS
484: SELECT
485: record_data
486: FROM
487: igf_gr_load_file_t
488: WHERE
489: gldr_id BETWEEN 2 AND (l_last_gldr_id - 1)
490: AND
491: file_type = 'ESD'