DBA Data[Home] [Help]

APPS.IGF_GR_YTD_LOAD_DATA dependencies on IGF_GR_LOAD_FILE_T

Line 27: PROCEDURE split_into_orig_fields ( p_record_data IN igf_gr_load_file_t.record_data%TYPE,

23: g_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;
24: g_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE;
25:
26:
27: PROCEDURE split_into_orig_fields ( p_record_data IN igf_gr_load_file_t.record_data%TYPE,
28: p_ytd_orig_row OUT NOCOPY igf_gr_ytd_orig%ROWTYPE)
29: AS
30: /***************************************************************
31: Created By : avenkatr

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

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

Line 211: PROCEDURE split_into_disb_fields ( p_record_data IN igf_gr_load_file_t.record_data%TYPE,

207:
208: END split_into_orig_fields;
209:
210:
211: PROCEDURE split_into_disb_fields ( p_record_data IN igf_gr_load_file_t.record_data%TYPE,
212: p_ytd_disb_row OUT NOCOPY igf_gr_ytd_disb%ROWTYPE)
213: AS
214: /***************************************************************
215: Created By : avenkatr

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

213: AS
214: /***************************************************************
215: Created By : avenkatr
216: Date Created By : 2000/12/20
217: Purpose : To split data in the single record_data column of igf_gr_load_file_t
218: into the different columns of igf_gr_ytd_disb table
219:
220: Known Limitations,Enhancements or Remarks
221: Change History :

Line 515: igf_gr_load_file_t

511: IS
512: SELECT
513: record_data
514: FROM
515: igf_gr_load_file_t
516: WHERE
517: gldr_id BETWEEN 2 AND (l_last_gldr_id - 1)
518: AND
519: file_type = 'YTD'

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

535: -- This file has Origination records and has to be uploaded in igf_gr_ytd_orig table
536: --
537: BEGIN
538: --
539: -- Split the data in the column of igf_gr_load_file_t into the columns of igf_gr_ytd_orig file
540: --
541: split_into_orig_fields (ytd_rec_data.record_data,
542: lv_ytdor_row);
543:

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

574: -- This file has Disbursement records and has to be updated in the igf_gr_ytd_disb file
575: --
576: BEGIN
577: --
578: -- Split the data in the column of igf_gr_load_file_t into the columns of igf_gr_ytd_orig file
579: --
580: split_into_disb_fields (ytd_rec_data.record_data,
581: lv_ytdds_row) ;
582: