DBA Data[Home] [Help]

APPS.IGF_GR_MRR_LOAD_DATA dependencies on IGF_GR_LOAD_FILE_T

Line 24: PROCEDURE split_into_fields ( p_record_data IN igf_gr_load_file_t.record_data%TYPE,

20:
21: g_ver_num VARCHAR2(30) DEFAULT NULL; -- Flat File Version Number
22: g_c_alt_code VARCHAR2(80) DEFAULT NULL; -- To hold alternate code.
23:
24: PROCEDURE split_into_fields ( p_record_data IN igf_gr_load_file_t.record_data%TYPE,
25: p_igf_gr_mrr_row OUT NOCOPY igf_gr_mrr%ROWTYPE )
26: AS
27: /***************************************************************
28: Created By : avenkatr

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

26: AS
27: /***************************************************************
28: Created By : avenkatr
29: Date Created By : 2000/12/20
30: Purpose : To split data in the single record_data column of igf_gr_load_file_t
31: into the different columns of igf_gr_mrr table
32:
33: Known Limitations,Enhancements or Remarks
34: Change History :

Line 225: igf_gr_load_file_t

221: IS
222: SELECT
223: record_data
224: FROM
225: igf_gr_load_file_t
226: WHERE
227: gldr_id BETWEEN 2 AND (l_last_gldr_id - 1)
228: AND
229: file_type = 'MRR'

Line 248: -- Split the data in the column of igf_gr_load_file_t into the columns of igf_gr_ytd_orig file

244: -- This file has Origination records and has to be uploaded in igf_gr_ytd_orig table
245: --
246: BEGIN
247: --
248: -- Split the data in the column of igf_gr_load_file_t into the columns of igf_gr_ytd_orig file
249: --
250: split_into_fields (mrr_rec_data.record_data,
251: lv_mrr_row);
252: