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_YTD_LOAD_DATA dependencies on IGF_GR_YTD_ORIG

Line 7: Purpose : To upload data into IGF_GR_YTD_ORIG and IGF_GR_YTD_DISB files

3:
4: /***************************************************************
5: Created By : avenkatr
6: Date Created By : 2000/12/20
7: Purpose : To upload data into IGF_GR_YTD_ORIG and IGF_GR_YTD_DISB files
8:
9: Known Limitations,Enhancements or Remarks
10: Change History : Big Id : 1706091 Wrong error message and token
11: Who When What

Line 28: p_ytd_orig_row OUT NOCOPY igf_gr_ytd_orig%ROWTYPE)

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
32: Date Created By : 2000/12/20

Line 34: into the different columns of igf_gr_ytd_orig table

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 :
38: Who When What

Line 329: PROCEDURE insert_in_ytdor_table ( p_orig_rec IN igf_gr_ytd_orig%ROWTYPE )

325:
326: END split_into_disb_fields ;
327:
328:
329: PROCEDURE insert_in_ytdor_table ( p_orig_rec IN igf_gr_ytd_orig%ROWTYPE )
330: AS
331: /***************************************************************
332: Created By : avenkatr
333: Date Created By : 2000/12/19

Line 345: igf_gr_ytd_orig_pkg.insert_row (

341: lv_ytdor_id NUMBER;
342:
343: BEGIN
344:
345: igf_gr_ytd_orig_pkg.insert_row (
346: x_rowid => lv_rowid,
347: x_ytdor_id => lv_ytdor_id,
348: x_origination_id => p_orig_rec.origination_id,
349: x_original_ssn => p_orig_rec.original_ssn,

Line 524: lv_ytdor_row igf_gr_ytd_orig%ROWTYPE;

520: ORDER BY
521: gldr_id;
522:
523: ytd_rec_data c_ytd_data%ROWTYPE;
524: lv_ytdor_row igf_gr_ytd_orig%ROWTYPE;
525: lv_ytdds_row igf_gr_ytd_disb%ROWTYPE;
526:
527: BEGIN
528: --

Line 535: -- This file has Origination records and has to be uploaded in igf_gr_ytd_orig table

531: FOR ytd_rec_data IN c_ytd_data LOOP
532:
533: IF ( (SUBSTR(ytd_rec_data.record_data, 1, 1)) = 'O' ) THEN
534: --
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

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 545: -- Insert this new record into the igf_gr_ytd_orig table

541: split_into_orig_fields (ytd_rec_data.record_data,
542: lv_ytdor_row);
543:
544: --
545: -- Insert this new record into the igf_gr_ytd_orig table
546: --
547: insert_in_ytdor_table (lv_ytdor_row );
548: --
549: -- Make an entry in the log file indicating Success

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:

Line 584: -- Insert this new record into the igf_gr_ytd_orig table

580: split_into_disb_fields (ytd_rec_data.record_data,
581: lv_ytdds_row) ;
582:
583: --
584: -- Insert this new record into the igf_gr_ytd_orig table
585: --
586: insert_in_ytdds_table (lv_ytdds_row ) ;
587: --
588: -- Make an entry in the log file indicating Success

Line 675: Purpose : To Load the IGF_GR_YTD_ORIG and IGF_GR_YTD_DISB tables

671: AS
672: /***************************************************************
673: Created By : avenkatr
674: Date Created By : 2000/12/19
675: Purpose : To Load the IGF_GR_YTD_ORIG and IGF_GR_YTD_DISB tables
676:
677: Known Limitations,Enhancements or Remarks
678: Change History :
679: Who When What