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_MRR_LOAD_DATA dependencies on IGF_GR_MRR

Line 1: PACKAGE BODY igf_gr_mrr_load_data AS

1: PACKAGE BODY igf_gr_mrr_load_data AS
2: /* $Header: IGFGR05B.pls 120.2 2006/04/06 06:10:12 veramach ship $ */
3:
4: /***************************************************************
5: Created By : avenkatr

Line 7: Purpose : To upload data into the IGF_GR_MRR table

3:
4: /***************************************************************
5: Created By : avenkatr
6: Date Created By : 2000/12/20
7: Purpose : To upload data into the IGF_GR_MRR table
8:
9: Known Limitations,Enhancements or Remarks
10: Change History :
11: Who When What

Line 25: p_igf_gr_mrr_row OUT NOCOPY igf_gr_mrr%ROWTYPE )

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

Line 31: into the different columns of igf_gr_mrr table

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

Line 44: p_igf_gr_mrr_row.record_type := SUBSTR( p_record_data, 1, 2);

40:
41: IF g_ver_num IN ('2002-2003', '2003-2004','2004-2005','2005-2006','2006-2007') THEN
42:
43: BEGIN
44: p_igf_gr_mrr_row.record_type := SUBSTR( p_record_data, 1, 2);
45: p_igf_gr_mrr_row.req_inst_pell_id := SUBSTR( p_record_data, 3, 6);
46: p_igf_gr_mrr_row.mrr_code1 := SUBSTR( p_record_data, 9, 1);
47: p_igf_gr_mrr_row.mrr_code2 := SUBSTR( p_record_data, 10, 1);
48: p_igf_gr_mrr_row.mr_stud_id := SUBSTR( p_record_data, 11, 11);

Line 45: p_igf_gr_mrr_row.req_inst_pell_id := SUBSTR( p_record_data, 3, 6);

41: IF g_ver_num IN ('2002-2003', '2003-2004','2004-2005','2005-2006','2006-2007') THEN
42:
43: BEGIN
44: p_igf_gr_mrr_row.record_type := SUBSTR( p_record_data, 1, 2);
45: p_igf_gr_mrr_row.req_inst_pell_id := SUBSTR( p_record_data, 3, 6);
46: p_igf_gr_mrr_row.mrr_code1 := SUBSTR( p_record_data, 9, 1);
47: p_igf_gr_mrr_row.mrr_code2 := SUBSTR( p_record_data, 10, 1);
48: p_igf_gr_mrr_row.mr_stud_id := SUBSTR( p_record_data, 11, 11);
49: p_igf_gr_mrr_row.mr_inst_pell_id := SUBSTR( p_record_data, 22, 6);

Line 46: p_igf_gr_mrr_row.mrr_code1 := SUBSTR( p_record_data, 9, 1);

42:
43: BEGIN
44: p_igf_gr_mrr_row.record_type := SUBSTR( p_record_data, 1, 2);
45: p_igf_gr_mrr_row.req_inst_pell_id := SUBSTR( p_record_data, 3, 6);
46: p_igf_gr_mrr_row.mrr_code1 := SUBSTR( p_record_data, 9, 1);
47: p_igf_gr_mrr_row.mrr_code2 := SUBSTR( p_record_data, 10, 1);
48: p_igf_gr_mrr_row.mr_stud_id := SUBSTR( p_record_data, 11, 11);
49: p_igf_gr_mrr_row.mr_inst_pell_id := SUBSTR( p_record_data, 22, 6);
50: p_igf_gr_mrr_row.stud_orig_ssn := SUBSTR( p_record_data, 28, 9);

Line 47: p_igf_gr_mrr_row.mrr_code2 := SUBSTR( p_record_data, 10, 1);

43: BEGIN
44: p_igf_gr_mrr_row.record_type := SUBSTR( p_record_data, 1, 2);
45: p_igf_gr_mrr_row.req_inst_pell_id := SUBSTR( p_record_data, 3, 6);
46: p_igf_gr_mrr_row.mrr_code1 := SUBSTR( p_record_data, 9, 1);
47: p_igf_gr_mrr_row.mrr_code2 := SUBSTR( p_record_data, 10, 1);
48: p_igf_gr_mrr_row.mr_stud_id := SUBSTR( p_record_data, 11, 11);
49: p_igf_gr_mrr_row.mr_inst_pell_id := SUBSTR( p_record_data, 22, 6);
50: p_igf_gr_mrr_row.stud_orig_ssn := SUBSTR( p_record_data, 28, 9);
51: p_igf_gr_mrr_row.orig_name_cd := SUBSTR( p_record_data, 37, 2);

Line 48: p_igf_gr_mrr_row.mr_stud_id := SUBSTR( p_record_data, 11, 11);

44: p_igf_gr_mrr_row.record_type := SUBSTR( p_record_data, 1, 2);
45: p_igf_gr_mrr_row.req_inst_pell_id := SUBSTR( p_record_data, 3, 6);
46: p_igf_gr_mrr_row.mrr_code1 := SUBSTR( p_record_data, 9, 1);
47: p_igf_gr_mrr_row.mrr_code2 := SUBSTR( p_record_data, 10, 1);
48: p_igf_gr_mrr_row.mr_stud_id := SUBSTR( p_record_data, 11, 11);
49: p_igf_gr_mrr_row.mr_inst_pell_id := SUBSTR( p_record_data, 22, 6);
50: p_igf_gr_mrr_row.stud_orig_ssn := SUBSTR( p_record_data, 28, 9);
51: p_igf_gr_mrr_row.orig_name_cd := SUBSTR( p_record_data, 37, 2);
52: p_igf_gr_mrr_row.inst_pell_id := SUBSTR( p_record_data, 39, 6);

Line 49: p_igf_gr_mrr_row.mr_inst_pell_id := SUBSTR( p_record_data, 22, 6);

45: p_igf_gr_mrr_row.req_inst_pell_id := SUBSTR( p_record_data, 3, 6);
46: p_igf_gr_mrr_row.mrr_code1 := SUBSTR( p_record_data, 9, 1);
47: p_igf_gr_mrr_row.mrr_code2 := SUBSTR( p_record_data, 10, 1);
48: p_igf_gr_mrr_row.mr_stud_id := SUBSTR( p_record_data, 11, 11);
49: p_igf_gr_mrr_row.mr_inst_pell_id := SUBSTR( p_record_data, 22, 6);
50: p_igf_gr_mrr_row.stud_orig_ssn := SUBSTR( p_record_data, 28, 9);
51: p_igf_gr_mrr_row.orig_name_cd := SUBSTR( p_record_data, 37, 2);
52: p_igf_gr_mrr_row.inst_pell_id := SUBSTR( p_record_data, 39, 6);
53: p_igf_gr_mrr_row.inst_name := SUBSTR( p_record_data, 45, 70);

Line 50: p_igf_gr_mrr_row.stud_orig_ssn := SUBSTR( p_record_data, 28, 9);

46: p_igf_gr_mrr_row.mrr_code1 := SUBSTR( p_record_data, 9, 1);
47: p_igf_gr_mrr_row.mrr_code2 := SUBSTR( p_record_data, 10, 1);
48: p_igf_gr_mrr_row.mr_stud_id := SUBSTR( p_record_data, 11, 11);
49: p_igf_gr_mrr_row.mr_inst_pell_id := SUBSTR( p_record_data, 22, 6);
50: p_igf_gr_mrr_row.stud_orig_ssn := SUBSTR( p_record_data, 28, 9);
51: p_igf_gr_mrr_row.orig_name_cd := SUBSTR( p_record_data, 37, 2);
52: p_igf_gr_mrr_row.inst_pell_id := SUBSTR( p_record_data, 39, 6);
53: p_igf_gr_mrr_row.inst_name := SUBSTR( p_record_data, 45, 70);
54: p_igf_gr_mrr_row.inst_addr1 := SUBSTR( p_record_data, 115, 35);

Line 51: p_igf_gr_mrr_row.orig_name_cd := SUBSTR( p_record_data, 37, 2);

47: p_igf_gr_mrr_row.mrr_code2 := SUBSTR( p_record_data, 10, 1);
48: p_igf_gr_mrr_row.mr_stud_id := SUBSTR( p_record_data, 11, 11);
49: p_igf_gr_mrr_row.mr_inst_pell_id := SUBSTR( p_record_data, 22, 6);
50: p_igf_gr_mrr_row.stud_orig_ssn := SUBSTR( p_record_data, 28, 9);
51: p_igf_gr_mrr_row.orig_name_cd := SUBSTR( p_record_data, 37, 2);
52: p_igf_gr_mrr_row.inst_pell_id := SUBSTR( p_record_data, 39, 6);
53: p_igf_gr_mrr_row.inst_name := SUBSTR( p_record_data, 45, 70);
54: p_igf_gr_mrr_row.inst_addr1 := SUBSTR( p_record_data, 115, 35);
55: p_igf_gr_mrr_row.inst_addr2 := SUBSTR( p_record_data, 150, 35);

Line 52: p_igf_gr_mrr_row.inst_pell_id := SUBSTR( p_record_data, 39, 6);

48: p_igf_gr_mrr_row.mr_stud_id := SUBSTR( p_record_data, 11, 11);
49: p_igf_gr_mrr_row.mr_inst_pell_id := SUBSTR( p_record_data, 22, 6);
50: p_igf_gr_mrr_row.stud_orig_ssn := SUBSTR( p_record_data, 28, 9);
51: p_igf_gr_mrr_row.orig_name_cd := SUBSTR( p_record_data, 37, 2);
52: p_igf_gr_mrr_row.inst_pell_id := SUBSTR( p_record_data, 39, 6);
53: p_igf_gr_mrr_row.inst_name := SUBSTR( p_record_data, 45, 70);
54: p_igf_gr_mrr_row.inst_addr1 := SUBSTR( p_record_data, 115, 35);
55: p_igf_gr_mrr_row.inst_addr2 := SUBSTR( p_record_data, 150, 35);
56: p_igf_gr_mrr_row.inst_city := SUBSTR( p_record_data, 185, 25);

Line 53: p_igf_gr_mrr_row.inst_name := SUBSTR( p_record_data, 45, 70);

49: p_igf_gr_mrr_row.mr_inst_pell_id := SUBSTR( p_record_data, 22, 6);
50: p_igf_gr_mrr_row.stud_orig_ssn := SUBSTR( p_record_data, 28, 9);
51: p_igf_gr_mrr_row.orig_name_cd := SUBSTR( p_record_data, 37, 2);
52: p_igf_gr_mrr_row.inst_pell_id := SUBSTR( p_record_data, 39, 6);
53: p_igf_gr_mrr_row.inst_name := SUBSTR( p_record_data, 45, 70);
54: p_igf_gr_mrr_row.inst_addr1 := SUBSTR( p_record_data, 115, 35);
55: p_igf_gr_mrr_row.inst_addr2 := SUBSTR( p_record_data, 150, 35);
56: p_igf_gr_mrr_row.inst_city := SUBSTR( p_record_data, 185, 25);
57: p_igf_gr_mrr_row.inst_state := SUBSTR( p_record_data, 210, 2);

Line 54: p_igf_gr_mrr_row.inst_addr1 := SUBSTR( p_record_data, 115, 35);

50: p_igf_gr_mrr_row.stud_orig_ssn := SUBSTR( p_record_data, 28, 9);
51: p_igf_gr_mrr_row.orig_name_cd := SUBSTR( p_record_data, 37, 2);
52: p_igf_gr_mrr_row.inst_pell_id := SUBSTR( p_record_data, 39, 6);
53: p_igf_gr_mrr_row.inst_name := SUBSTR( p_record_data, 45, 70);
54: p_igf_gr_mrr_row.inst_addr1 := SUBSTR( p_record_data, 115, 35);
55: p_igf_gr_mrr_row.inst_addr2 := SUBSTR( p_record_data, 150, 35);
56: p_igf_gr_mrr_row.inst_city := SUBSTR( p_record_data, 185, 25);
57: p_igf_gr_mrr_row.inst_state := SUBSTR( p_record_data, 210, 2);
58: p_igf_gr_mrr_row.zip_code := SUBSTR( p_record_data, 212, 9);

Line 55: p_igf_gr_mrr_row.inst_addr2 := SUBSTR( p_record_data, 150, 35);

51: p_igf_gr_mrr_row.orig_name_cd := SUBSTR( p_record_data, 37, 2);
52: p_igf_gr_mrr_row.inst_pell_id := SUBSTR( p_record_data, 39, 6);
53: p_igf_gr_mrr_row.inst_name := SUBSTR( p_record_data, 45, 70);
54: p_igf_gr_mrr_row.inst_addr1 := SUBSTR( p_record_data, 115, 35);
55: p_igf_gr_mrr_row.inst_addr2 := SUBSTR( p_record_data, 150, 35);
56: p_igf_gr_mrr_row.inst_city := SUBSTR( p_record_data, 185, 25);
57: p_igf_gr_mrr_row.inst_state := SUBSTR( p_record_data, 210, 2);
58: p_igf_gr_mrr_row.zip_code := SUBSTR( p_record_data, 212, 9);
59: p_igf_gr_mrr_row.faa_name := SUBSTR( p_record_data, 221, 30);

Line 56: p_igf_gr_mrr_row.inst_city := SUBSTR( p_record_data, 185, 25);

52: p_igf_gr_mrr_row.inst_pell_id := SUBSTR( p_record_data, 39, 6);
53: p_igf_gr_mrr_row.inst_name := SUBSTR( p_record_data, 45, 70);
54: p_igf_gr_mrr_row.inst_addr1 := SUBSTR( p_record_data, 115, 35);
55: p_igf_gr_mrr_row.inst_addr2 := SUBSTR( p_record_data, 150, 35);
56: p_igf_gr_mrr_row.inst_city := SUBSTR( p_record_data, 185, 25);
57: p_igf_gr_mrr_row.inst_state := SUBSTR( p_record_data, 210, 2);
58: p_igf_gr_mrr_row.zip_code := SUBSTR( p_record_data, 212, 9);
59: p_igf_gr_mrr_row.faa_name := SUBSTR( p_record_data, 221, 30);
60: p_igf_gr_mrr_row.faa_tel := SUBSTR( p_record_data, 251, 10);

Line 57: p_igf_gr_mrr_row.inst_state := SUBSTR( p_record_data, 210, 2);

53: p_igf_gr_mrr_row.inst_name := SUBSTR( p_record_data, 45, 70);
54: p_igf_gr_mrr_row.inst_addr1 := SUBSTR( p_record_data, 115, 35);
55: p_igf_gr_mrr_row.inst_addr2 := SUBSTR( p_record_data, 150, 35);
56: p_igf_gr_mrr_row.inst_city := SUBSTR( p_record_data, 185, 25);
57: p_igf_gr_mrr_row.inst_state := SUBSTR( p_record_data, 210, 2);
58: p_igf_gr_mrr_row.zip_code := SUBSTR( p_record_data, 212, 9);
59: p_igf_gr_mrr_row.faa_name := SUBSTR( p_record_data, 221, 30);
60: p_igf_gr_mrr_row.faa_tel := SUBSTR( p_record_data, 251, 10);
61: p_igf_gr_mrr_row.faa_fax := SUBSTR( p_record_data, 261, 10);

Line 58: p_igf_gr_mrr_row.zip_code := SUBSTR( p_record_data, 212, 9);

54: p_igf_gr_mrr_row.inst_addr1 := SUBSTR( p_record_data, 115, 35);
55: p_igf_gr_mrr_row.inst_addr2 := SUBSTR( p_record_data, 150, 35);
56: p_igf_gr_mrr_row.inst_city := SUBSTR( p_record_data, 185, 25);
57: p_igf_gr_mrr_row.inst_state := SUBSTR( p_record_data, 210, 2);
58: p_igf_gr_mrr_row.zip_code := SUBSTR( p_record_data, 212, 9);
59: p_igf_gr_mrr_row.faa_name := SUBSTR( p_record_data, 221, 30);
60: p_igf_gr_mrr_row.faa_tel := SUBSTR( p_record_data, 251, 10);
61: p_igf_gr_mrr_row.faa_fax := SUBSTR( p_record_data, 261, 10);
62: p_igf_gr_mrr_row.faa_internet_addr := SUBSTR( p_record_data, 271, 50);

Line 59: p_igf_gr_mrr_row.faa_name := SUBSTR( p_record_data, 221, 30);

55: p_igf_gr_mrr_row.inst_addr2 := SUBSTR( p_record_data, 150, 35);
56: p_igf_gr_mrr_row.inst_city := SUBSTR( p_record_data, 185, 25);
57: p_igf_gr_mrr_row.inst_state := SUBSTR( p_record_data, 210, 2);
58: p_igf_gr_mrr_row.zip_code := SUBSTR( p_record_data, 212, 9);
59: p_igf_gr_mrr_row.faa_name := SUBSTR( p_record_data, 221, 30);
60: p_igf_gr_mrr_row.faa_tel := SUBSTR( p_record_data, 251, 10);
61: p_igf_gr_mrr_row.faa_fax := SUBSTR( p_record_data, 261, 10);
62: p_igf_gr_mrr_row.faa_internet_addr := SUBSTR( p_record_data, 271, 50);
63: p_igf_gr_mrr_row.schd_pell_grant := TO_NUMBER(SUBSTR( p_record_data, 321, 7))/100;

Line 60: p_igf_gr_mrr_row.faa_tel := SUBSTR( p_record_data, 251, 10);

56: p_igf_gr_mrr_row.inst_city := SUBSTR( p_record_data, 185, 25);
57: p_igf_gr_mrr_row.inst_state := SUBSTR( p_record_data, 210, 2);
58: p_igf_gr_mrr_row.zip_code := SUBSTR( p_record_data, 212, 9);
59: p_igf_gr_mrr_row.faa_name := SUBSTR( p_record_data, 221, 30);
60: p_igf_gr_mrr_row.faa_tel := SUBSTR( p_record_data, 251, 10);
61: p_igf_gr_mrr_row.faa_fax := SUBSTR( p_record_data, 261, 10);
62: p_igf_gr_mrr_row.faa_internet_addr := SUBSTR( p_record_data, 271, 50);
63: p_igf_gr_mrr_row.schd_pell_grant := TO_NUMBER(SUBSTR( p_record_data, 321, 7))/100;
64: p_igf_gr_mrr_row.orig_awd_amt := TO_NUMBER(SUBSTR( p_record_data, 328, 7))/100;

Line 61: p_igf_gr_mrr_row.faa_fax := SUBSTR( p_record_data, 261, 10);

57: p_igf_gr_mrr_row.inst_state := SUBSTR( p_record_data, 210, 2);
58: p_igf_gr_mrr_row.zip_code := SUBSTR( p_record_data, 212, 9);
59: p_igf_gr_mrr_row.faa_name := SUBSTR( p_record_data, 221, 30);
60: p_igf_gr_mrr_row.faa_tel := SUBSTR( p_record_data, 251, 10);
61: p_igf_gr_mrr_row.faa_fax := SUBSTR( p_record_data, 261, 10);
62: p_igf_gr_mrr_row.faa_internet_addr := SUBSTR( p_record_data, 271, 50);
63: p_igf_gr_mrr_row.schd_pell_grant := TO_NUMBER(SUBSTR( p_record_data, 321, 7))/100;
64: p_igf_gr_mrr_row.orig_awd_amt := TO_NUMBER(SUBSTR( p_record_data, 328, 7))/100;
65: p_igf_gr_mrr_row.tran_num := SUBSTR( p_record_data, 335, 2);

Line 62: p_igf_gr_mrr_row.faa_internet_addr := SUBSTR( p_record_data, 271, 50);

58: p_igf_gr_mrr_row.zip_code := SUBSTR( p_record_data, 212, 9);
59: p_igf_gr_mrr_row.faa_name := SUBSTR( p_record_data, 221, 30);
60: p_igf_gr_mrr_row.faa_tel := SUBSTR( p_record_data, 251, 10);
61: p_igf_gr_mrr_row.faa_fax := SUBSTR( p_record_data, 261, 10);
62: p_igf_gr_mrr_row.faa_internet_addr := SUBSTR( p_record_data, 271, 50);
63: p_igf_gr_mrr_row.schd_pell_grant := TO_NUMBER(SUBSTR( p_record_data, 321, 7))/100;
64: p_igf_gr_mrr_row.orig_awd_amt := TO_NUMBER(SUBSTR( p_record_data, 328, 7))/100;
65: p_igf_gr_mrr_row.tran_num := SUBSTR( p_record_data, 335, 2);
66: p_igf_gr_mrr_row.efc := TO_NUMBER(SUBSTR( p_record_data, 337, 5));

Line 63: p_igf_gr_mrr_row.schd_pell_grant := TO_NUMBER(SUBSTR( p_record_data, 321, 7))/100;

59: p_igf_gr_mrr_row.faa_name := SUBSTR( p_record_data, 221, 30);
60: p_igf_gr_mrr_row.faa_tel := SUBSTR( p_record_data, 251, 10);
61: p_igf_gr_mrr_row.faa_fax := SUBSTR( p_record_data, 261, 10);
62: p_igf_gr_mrr_row.faa_internet_addr := SUBSTR( p_record_data, 271, 50);
63: p_igf_gr_mrr_row.schd_pell_grant := TO_NUMBER(SUBSTR( p_record_data, 321, 7))/100;
64: p_igf_gr_mrr_row.orig_awd_amt := TO_NUMBER(SUBSTR( p_record_data, 328, 7))/100;
65: p_igf_gr_mrr_row.tran_num := SUBSTR( p_record_data, 335, 2);
66: p_igf_gr_mrr_row.efc := TO_NUMBER(SUBSTR( p_record_data, 337, 5));
67: p_igf_gr_mrr_row.enrl_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 342, 8), 'YYYYMMDD');

Line 64: p_igf_gr_mrr_row.orig_awd_amt := TO_NUMBER(SUBSTR( p_record_data, 328, 7))/100;

60: p_igf_gr_mrr_row.faa_tel := SUBSTR( p_record_data, 251, 10);
61: p_igf_gr_mrr_row.faa_fax := SUBSTR( p_record_data, 261, 10);
62: p_igf_gr_mrr_row.faa_internet_addr := SUBSTR( p_record_data, 271, 50);
63: p_igf_gr_mrr_row.schd_pell_grant := TO_NUMBER(SUBSTR( p_record_data, 321, 7))/100;
64: p_igf_gr_mrr_row.orig_awd_amt := TO_NUMBER(SUBSTR( p_record_data, 328, 7))/100;
65: p_igf_gr_mrr_row.tran_num := SUBSTR( p_record_data, 335, 2);
66: p_igf_gr_mrr_row.efc := TO_NUMBER(SUBSTR( p_record_data, 337, 5));
67: p_igf_gr_mrr_row.enrl_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 342, 8), 'YYYYMMDD');
68: p_igf_gr_mrr_row.orig_creation_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 350, 8), 'YYYYMMDD');

Line 65: p_igf_gr_mrr_row.tran_num := SUBSTR( p_record_data, 335, 2);

61: p_igf_gr_mrr_row.faa_fax := SUBSTR( p_record_data, 261, 10);
62: p_igf_gr_mrr_row.faa_internet_addr := SUBSTR( p_record_data, 271, 50);
63: p_igf_gr_mrr_row.schd_pell_grant := TO_NUMBER(SUBSTR( p_record_data, 321, 7))/100;
64: p_igf_gr_mrr_row.orig_awd_amt := TO_NUMBER(SUBSTR( p_record_data, 328, 7))/100;
65: p_igf_gr_mrr_row.tran_num := SUBSTR( p_record_data, 335, 2);
66: p_igf_gr_mrr_row.efc := TO_NUMBER(SUBSTR( p_record_data, 337, 5));
67: p_igf_gr_mrr_row.enrl_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 342, 8), 'YYYYMMDD');
68: p_igf_gr_mrr_row.orig_creation_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 350, 8), 'YYYYMMDD');
69: p_igf_gr_mrr_row.disb_accepted_amt := TO_NUMBER(SUBSTR( p_record_data, 358, 7))/100;

Line 66: p_igf_gr_mrr_row.efc := TO_NUMBER(SUBSTR( p_record_data, 337, 5));

62: p_igf_gr_mrr_row.faa_internet_addr := SUBSTR( p_record_data, 271, 50);
63: p_igf_gr_mrr_row.schd_pell_grant := TO_NUMBER(SUBSTR( p_record_data, 321, 7))/100;
64: p_igf_gr_mrr_row.orig_awd_amt := TO_NUMBER(SUBSTR( p_record_data, 328, 7))/100;
65: p_igf_gr_mrr_row.tran_num := SUBSTR( p_record_data, 335, 2);
66: p_igf_gr_mrr_row.efc := TO_NUMBER(SUBSTR( p_record_data, 337, 5));
67: p_igf_gr_mrr_row.enrl_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 342, 8), 'YYYYMMDD');
68: p_igf_gr_mrr_row.orig_creation_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 350, 8), 'YYYYMMDD');
69: p_igf_gr_mrr_row.disb_accepted_amt := TO_NUMBER(SUBSTR( p_record_data, 358, 7))/100;
70: p_igf_gr_mrr_row.last_active_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 365, 8), 'YYYYMMDD');

Line 67: p_igf_gr_mrr_row.enrl_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 342, 8), 'YYYYMMDD');

63: p_igf_gr_mrr_row.schd_pell_grant := TO_NUMBER(SUBSTR( p_record_data, 321, 7))/100;
64: p_igf_gr_mrr_row.orig_awd_amt := TO_NUMBER(SUBSTR( p_record_data, 328, 7))/100;
65: p_igf_gr_mrr_row.tran_num := SUBSTR( p_record_data, 335, 2);
66: p_igf_gr_mrr_row.efc := TO_NUMBER(SUBSTR( p_record_data, 337, 5));
67: p_igf_gr_mrr_row.enrl_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 342, 8), 'YYYYMMDD');
68: p_igf_gr_mrr_row.orig_creation_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 350, 8), 'YYYYMMDD');
69: p_igf_gr_mrr_row.disb_accepted_amt := TO_NUMBER(SUBSTR( p_record_data, 358, 7))/100;
70: p_igf_gr_mrr_row.last_active_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 365, 8), 'YYYYMMDD');
71: p_igf_gr_mrr_row.next_est_disb_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 373, 8), 'YYYYMMDD');

Line 68: p_igf_gr_mrr_row.orig_creation_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 350, 8), 'YYYYMMDD');

64: p_igf_gr_mrr_row.orig_awd_amt := TO_NUMBER(SUBSTR( p_record_data, 328, 7))/100;
65: p_igf_gr_mrr_row.tran_num := SUBSTR( p_record_data, 335, 2);
66: p_igf_gr_mrr_row.efc := TO_NUMBER(SUBSTR( p_record_data, 337, 5));
67: p_igf_gr_mrr_row.enrl_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 342, 8), 'YYYYMMDD');
68: p_igf_gr_mrr_row.orig_creation_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 350, 8), 'YYYYMMDD');
69: p_igf_gr_mrr_row.disb_accepted_amt := TO_NUMBER(SUBSTR( p_record_data, 358, 7))/100;
70: p_igf_gr_mrr_row.last_active_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 365, 8), 'YYYYMMDD');
71: p_igf_gr_mrr_row.next_est_disb_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 373, 8), 'YYYYMMDD');
72: p_igf_gr_mrr_row.eligibility_used := TO_NUMBER(SUBSTR( p_record_data, 381, 5));

Line 69: p_igf_gr_mrr_row.disb_accepted_amt := TO_NUMBER(SUBSTR( p_record_data, 358, 7))/100;

65: p_igf_gr_mrr_row.tran_num := SUBSTR( p_record_data, 335, 2);
66: p_igf_gr_mrr_row.efc := TO_NUMBER(SUBSTR( p_record_data, 337, 5));
67: p_igf_gr_mrr_row.enrl_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 342, 8), 'YYYYMMDD');
68: p_igf_gr_mrr_row.orig_creation_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 350, 8), 'YYYYMMDD');
69: p_igf_gr_mrr_row.disb_accepted_amt := TO_NUMBER(SUBSTR( p_record_data, 358, 7))/100;
70: p_igf_gr_mrr_row.last_active_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 365, 8), 'YYYYMMDD');
71: p_igf_gr_mrr_row.next_est_disb_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 373, 8), 'YYYYMMDD');
72: p_igf_gr_mrr_row.eligibility_used := TO_NUMBER(SUBSTR( p_record_data, 381, 5));
73: p_igf_gr_mrr_row.ed_use_flags := SUBSTR( p_record_data, 386, 10);

Line 70: p_igf_gr_mrr_row.last_active_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 365, 8), 'YYYYMMDD');

66: p_igf_gr_mrr_row.efc := TO_NUMBER(SUBSTR( p_record_data, 337, 5));
67: p_igf_gr_mrr_row.enrl_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 342, 8), 'YYYYMMDD');
68: p_igf_gr_mrr_row.orig_creation_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 350, 8), 'YYYYMMDD');
69: p_igf_gr_mrr_row.disb_accepted_amt := TO_NUMBER(SUBSTR( p_record_data, 358, 7))/100;
70: p_igf_gr_mrr_row.last_active_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 365, 8), 'YYYYMMDD');
71: p_igf_gr_mrr_row.next_est_disb_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 373, 8), 'YYYYMMDD');
72: p_igf_gr_mrr_row.eligibility_used := TO_NUMBER(SUBSTR( p_record_data, 381, 5));
73: p_igf_gr_mrr_row.ed_use_flags := SUBSTR( p_record_data, 386, 10);
74: p_igf_gr_mrr_row.stud_last_name := SUBSTR( p_record_data, 396, 16);

Line 71: p_igf_gr_mrr_row.next_est_disb_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 373, 8), 'YYYYMMDD');

67: p_igf_gr_mrr_row.enrl_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 342, 8), 'YYYYMMDD');
68: p_igf_gr_mrr_row.orig_creation_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 350, 8), 'YYYYMMDD');
69: p_igf_gr_mrr_row.disb_accepted_amt := TO_NUMBER(SUBSTR( p_record_data, 358, 7))/100;
70: p_igf_gr_mrr_row.last_active_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 365, 8), 'YYYYMMDD');
71: p_igf_gr_mrr_row.next_est_disb_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 373, 8), 'YYYYMMDD');
72: p_igf_gr_mrr_row.eligibility_used := TO_NUMBER(SUBSTR( p_record_data, 381, 5));
73: p_igf_gr_mrr_row.ed_use_flags := SUBSTR( p_record_data, 386, 10);
74: p_igf_gr_mrr_row.stud_last_name := SUBSTR( p_record_data, 396, 16);
75: p_igf_gr_mrr_row.stud_first_name := SUBSTR( p_record_data, 412, 12);

Line 72: p_igf_gr_mrr_row.eligibility_used := TO_NUMBER(SUBSTR( p_record_data, 381, 5));

68: p_igf_gr_mrr_row.orig_creation_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 350, 8), 'YYYYMMDD');
69: p_igf_gr_mrr_row.disb_accepted_amt := TO_NUMBER(SUBSTR( p_record_data, 358, 7))/100;
70: p_igf_gr_mrr_row.last_active_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 365, 8), 'YYYYMMDD');
71: p_igf_gr_mrr_row.next_est_disb_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 373, 8), 'YYYYMMDD');
72: p_igf_gr_mrr_row.eligibility_used := TO_NUMBER(SUBSTR( p_record_data, 381, 5));
73: p_igf_gr_mrr_row.ed_use_flags := SUBSTR( p_record_data, 386, 10);
74: p_igf_gr_mrr_row.stud_last_name := SUBSTR( p_record_data, 396, 16);
75: p_igf_gr_mrr_row.stud_first_name := SUBSTR( p_record_data, 412, 12);
76: p_igf_gr_mrr_row.stud_middle_name := SUBSTR( p_record_data, 424, 1);

Line 73: p_igf_gr_mrr_row.ed_use_flags := SUBSTR( p_record_data, 386, 10);

69: p_igf_gr_mrr_row.disb_accepted_amt := TO_NUMBER(SUBSTR( p_record_data, 358, 7))/100;
70: p_igf_gr_mrr_row.last_active_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 365, 8), 'YYYYMMDD');
71: p_igf_gr_mrr_row.next_est_disb_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 373, 8), 'YYYYMMDD');
72: p_igf_gr_mrr_row.eligibility_used := TO_NUMBER(SUBSTR( p_record_data, 381, 5));
73: p_igf_gr_mrr_row.ed_use_flags := SUBSTR( p_record_data, 386, 10);
74: p_igf_gr_mrr_row.stud_last_name := SUBSTR( p_record_data, 396, 16);
75: p_igf_gr_mrr_row.stud_first_name := SUBSTR( p_record_data, 412, 12);
76: p_igf_gr_mrr_row.stud_middle_name := SUBSTR( p_record_data, 424, 1);
77: p_igf_gr_mrr_row.stud_dob := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 425, 8), 'YYYYMMDD');

Line 74: p_igf_gr_mrr_row.stud_last_name := SUBSTR( p_record_data, 396, 16);

70: p_igf_gr_mrr_row.last_active_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 365, 8), 'YYYYMMDD');
71: p_igf_gr_mrr_row.next_est_disb_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 373, 8), 'YYYYMMDD');
72: p_igf_gr_mrr_row.eligibility_used := TO_NUMBER(SUBSTR( p_record_data, 381, 5));
73: p_igf_gr_mrr_row.ed_use_flags := SUBSTR( p_record_data, 386, 10);
74: p_igf_gr_mrr_row.stud_last_name := SUBSTR( p_record_data, 396, 16);
75: p_igf_gr_mrr_row.stud_first_name := SUBSTR( p_record_data, 412, 12);
76: p_igf_gr_mrr_row.stud_middle_name := SUBSTR( p_record_data, 424, 1);
77: p_igf_gr_mrr_row.stud_dob := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 425, 8), 'YYYYMMDD');
78: p_igf_gr_mrr_row.current_ssn := SUBSTR(p_record_data,433,9);

Line 75: p_igf_gr_mrr_row.stud_first_name := SUBSTR( p_record_data, 412, 12);

71: p_igf_gr_mrr_row.next_est_disb_dt := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 373, 8), 'YYYYMMDD');
72: p_igf_gr_mrr_row.eligibility_used := TO_NUMBER(SUBSTR( p_record_data, 381, 5));
73: p_igf_gr_mrr_row.ed_use_flags := SUBSTR( p_record_data, 386, 10);
74: p_igf_gr_mrr_row.stud_last_name := SUBSTR( p_record_data, 396, 16);
75: p_igf_gr_mrr_row.stud_first_name := SUBSTR( p_record_data, 412, 12);
76: p_igf_gr_mrr_row.stud_middle_name := SUBSTR( p_record_data, 424, 1);
77: p_igf_gr_mrr_row.stud_dob := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 425, 8), 'YYYYMMDD');
78: p_igf_gr_mrr_row.current_ssn := SUBSTR(p_record_data,433,9);
79:

Line 76: p_igf_gr_mrr_row.stud_middle_name := SUBSTR( p_record_data, 424, 1);

72: p_igf_gr_mrr_row.eligibility_used := TO_NUMBER(SUBSTR( p_record_data, 381, 5));
73: p_igf_gr_mrr_row.ed_use_flags := SUBSTR( p_record_data, 386, 10);
74: p_igf_gr_mrr_row.stud_last_name := SUBSTR( p_record_data, 396, 16);
75: p_igf_gr_mrr_row.stud_first_name := SUBSTR( p_record_data, 412, 12);
76: p_igf_gr_mrr_row.stud_middle_name := SUBSTR( p_record_data, 424, 1);
77: p_igf_gr_mrr_row.stud_dob := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 425, 8), 'YYYYMMDD');
78: p_igf_gr_mrr_row.current_ssn := SUBSTR(p_record_data,433,9);
79:
80: EXCEPTION

Line 77: p_igf_gr_mrr_row.stud_dob := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 425, 8), 'YYYYMMDD');

73: p_igf_gr_mrr_row.ed_use_flags := SUBSTR( p_record_data, 386, 10);
74: p_igf_gr_mrr_row.stud_last_name := SUBSTR( p_record_data, 396, 16);
75: p_igf_gr_mrr_row.stud_first_name := SUBSTR( p_record_data, 412, 12);
76: p_igf_gr_mrr_row.stud_middle_name := SUBSTR( p_record_data, 424, 1);
77: p_igf_gr_mrr_row.stud_dob := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 425, 8), 'YYYYMMDD');
78: p_igf_gr_mrr_row.current_ssn := SUBSTR(p_record_data,433,9);
79:
80: EXCEPTION
81: WHEN OTHERS THEN -- Number / Date format exception

Line 78: p_igf_gr_mrr_row.current_ssn := SUBSTR(p_record_data,433,9);

74: p_igf_gr_mrr_row.stud_last_name := SUBSTR( p_record_data, 396, 16);
75: p_igf_gr_mrr_row.stud_first_name := SUBSTR( p_record_data, 412, 12);
76: p_igf_gr_mrr_row.stud_middle_name := SUBSTR( p_record_data, 424, 1);
77: p_igf_gr_mrr_row.stud_dob := FND_DATE.STRING_TO_DATE(SUBSTR( p_record_data, 425, 8), 'YYYYMMDD');
78: p_igf_gr_mrr_row.current_ssn := SUBSTR(p_record_data,433,9);
79:
80: EXCEPTION
81: WHEN OTHERS THEN -- Number / Date format exception
82: RAISE igf_gr_gen.skip_this_record;

Line 100: fnd_message.set_token('NAME','igf_gr_mrr_load_data.split_into_fields');

96: RAISE;
97:
98: WHEN OTHERS THEN
99: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
100: fnd_message.set_token('NAME','igf_gr_mrr_load_data.split_into_fields');
101: igs_ge_msg_stack.add;
102: app_exception.raise_exception;
103:
104: END split_into_fields;

Line 107: PROCEDURE insert_in_mrr_table ( p_mrr_rec IN igf_gr_mrr%ROWTYPE )

103:
104: END split_into_fields;
105:
106:
107: PROCEDURE insert_in_mrr_table ( p_mrr_rec IN igf_gr_mrr%ROWTYPE )
108: AS
109: /***************************************************************
110: Created By : avenkatr
111: Date Created By : 2000/12/19

Line 112: Purpose : To Load data into IGF_GR_MRR table

108: AS
109: /***************************************************************
110: Created By : avenkatr
111: Date Created By : 2000/12/19
112: Purpose : To Load data into IGF_GR_MRR table
113:
114: Known Limitations,Enhancements or Remarks
115: Change History :
116: Who When What

Line 122: /* Call the table handler of the table igf_gr_mrr to insert data */

118: lv_rowid VARCHAR2(25);
119: lv_mrr_id NUMBER;
120:
121: BEGIN
122: /* Call the table handler of the table igf_gr_mrr to insert data */
123: igf_gr_mrr_pkg.insert_row (
124: x_rowid => lv_rowid,
125: x_mrr_id => lv_mrr_id,
126: x_record_type => p_mrr_rec.record_type,

Line 123: igf_gr_mrr_pkg.insert_row (

119: lv_mrr_id NUMBER;
120:
121: BEGIN
122: /* Call the table handler of the table igf_gr_mrr to insert data */
123: igf_gr_mrr_pkg.insert_row (
124: x_rowid => lv_rowid,
125: x_mrr_id => lv_mrr_id,
126: x_record_type => p_mrr_rec.record_type,
127: x_req_inst_pell_id => p_mrr_rec.req_inst_pell_id,

Line 167: fnd_message.set_token('NAME','igf_gr_mrr_load_data.insert_in_mrr_table');

163:
164: EXCEPTION
165: WHEN OTHERS THEN
166: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
167: fnd_message.set_token('NAME','igf_gr_mrr_load_data.insert_in_mrr_table');
168: igs_ge_msg_stack.add;
169: app_exception.raise_exception;
170: END insert_in_mrr_table;
171:

Line 234: lv_mrr_row igf_gr_mrr%ROWTYPE;

230: ORDER BY
231: gldr_id;
232:
233: mrr_rec_data c_mrr_data%ROWTYPE;
234: lv_mrr_row igf_gr_mrr%ROWTYPE;
235:
236: BEGIN
237: --
238: -- Check for the type of data in the Flat File

Line 260: fnd_message.set_name('IGF','IGF_GR_MRR_LOAD_PASS');

256: insert_in_mrr_table (lv_mrr_row );
257: --
258: -- Make an entry in the log file indicating Success
259: --
260: fnd_message.set_name('IGF','IGF_GR_MRR_LOAD_PASS');
261: fnd_message.set_token('STUD_ORIG_SSN',lv_mrr_row.stud_orig_ssn);
262: fnd_file.put_line(fnd_file.log,fnd_message.get());
263: lp_count := lp_count + 1;
264:

Line 268: fnd_message.set_name('IGF','IGF_GR_MRR_LOAD_FAIL');

264:
265: EXCEPTION
266:
267: WHEN igf_gr_gen.skip_this_record THEN
268: fnd_message.set_name('IGF','IGF_GR_MRR_LOAD_FAIL');
269: fnd_message.set_token('STUD_ORIG_SSN',SUBSTR( mrr_rec_data.record_data, 28, 9));
270: fnd_file.put_line(fnd_file.log,fnd_message.get());
271: lf_count := lf_count + 1;
272: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

Line 325: fnd_message.set_token('NAME','igf_gr_mrr_load_data.load_ack');

321: RAISE;
322:
323: WHEN OTHERS THEN
324: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
325: fnd_message.set_token('NAME','igf_gr_mrr_load_data.load_ack');
326: igs_ge_msg_stack.add;
327: app_exception.raise_exception;
328:
329: END load_ack;

Line 346: Purpose : To Load data into IGF_GR_MRR table

342: AS
343: /***************************************************************
344: Created By : avenkatr
345: Date Created By : 2000/12/19
346: Purpose : To Load data into IGF_GR_MRR table
347:
348: Known Limitations,Enhancements or Remarks
349: Change History :
350: Who When What

Line 422: END igf_gr_mrr_load_data;

418:
419: END mrr_load_file;
420:
421:
422: END igf_gr_mrr_load_data;