9: TYPE sel_rec_type IS RECORD (
10: id NUMBER,
11: stm_id NUMBER,
12: object_version_number NUMBER,
13: stream_element_date OKL_STRM_ELEMENTS.STREAM_ELEMENT_DATE%TYPE,
14: amount NUMBER,
15: comments OKL_STRM_ELEMENTS.COMMENTS%TYPE,
16: accrued_yn OKL_STRM_ELEMENTS.ACCRUED_YN%TYPE,
17: program_id NUMBER,
11: stm_id NUMBER,
12: object_version_number NUMBER,
13: stream_element_date OKL_STRM_ELEMENTS.STREAM_ELEMENT_DATE%TYPE,
14: amount NUMBER,
15: comments OKL_STRM_ELEMENTS.COMMENTS%TYPE,
16: accrued_yn OKL_STRM_ELEMENTS.ACCRUED_YN%TYPE,
17: program_id NUMBER,
18: request_id NUMBER,
19: program_application_id NUMBER,
12: object_version_number NUMBER,
13: stream_element_date OKL_STRM_ELEMENTS.STREAM_ELEMENT_DATE%TYPE,
14: amount NUMBER,
15: comments OKL_STRM_ELEMENTS.COMMENTS%TYPE,
16: accrued_yn OKL_STRM_ELEMENTS.ACCRUED_YN%TYPE,
17: program_id NUMBER,
18: request_id NUMBER,
19: program_application_id NUMBER,
20: program_update_date OKL_STRM_ELEMENTS.PROGRAM_UPDATE_DATE%TYPE,
16: accrued_yn OKL_STRM_ELEMENTS.ACCRUED_YN%TYPE,
17: program_id NUMBER,
18: request_id NUMBER,
19: program_application_id NUMBER,
20: program_update_date OKL_STRM_ELEMENTS.PROGRAM_UPDATE_DATE%TYPE,
21: se_line_number OKL_STRM_ELEMENTS.SE_LINE_NUMBER%TYPE,
22: date_billed OKL_STRM_ELEMENTS.DATE_BILLED%TYPE,
23: created_by NUMBER,
24: creation_date OKL_STRM_ELEMENTS.CREATION_DATE%TYPE,
17: program_id NUMBER,
18: request_id NUMBER,
19: program_application_id NUMBER,
20: program_update_date OKL_STRM_ELEMENTS.PROGRAM_UPDATE_DATE%TYPE,
21: se_line_number OKL_STRM_ELEMENTS.SE_LINE_NUMBER%TYPE,
22: date_billed OKL_STRM_ELEMENTS.DATE_BILLED%TYPE,
23: created_by NUMBER,
24: creation_date OKL_STRM_ELEMENTS.CREATION_DATE%TYPE,
25: last_updated_by NUMBER,
18: request_id NUMBER,
19: program_application_id NUMBER,
20: program_update_date OKL_STRM_ELEMENTS.PROGRAM_UPDATE_DATE%TYPE,
21: se_line_number OKL_STRM_ELEMENTS.SE_LINE_NUMBER%TYPE,
22: date_billed OKL_STRM_ELEMENTS.DATE_BILLED%TYPE,
23: created_by NUMBER,
24: creation_date OKL_STRM_ELEMENTS.CREATION_DATE%TYPE,
25: last_updated_by NUMBER,
26: last_update_date OKL_STRM_ELEMENTS.LAST_UPDATE_DATE%TYPE,
20: program_update_date OKL_STRM_ELEMENTS.PROGRAM_UPDATE_DATE%TYPE,
21: se_line_number OKL_STRM_ELEMENTS.SE_LINE_NUMBER%TYPE,
22: date_billed OKL_STRM_ELEMENTS.DATE_BILLED%TYPE,
23: created_by NUMBER,
24: creation_date OKL_STRM_ELEMENTS.CREATION_DATE%TYPE,
25: last_updated_by NUMBER,
26: last_update_date OKL_STRM_ELEMENTS.LAST_UPDATE_DATE%TYPE,
27: last_update_login NUMBER,
28: ---- Changed by Kjinger
22: date_billed OKL_STRM_ELEMENTS.DATE_BILLED%TYPE,
23: created_by NUMBER,
24: creation_date OKL_STRM_ELEMENTS.CREATION_DATE%TYPE,
25: last_updated_by NUMBER,
26: last_update_date OKL_STRM_ELEMENTS.LAST_UPDATE_DATE%TYPE,
27: last_update_login NUMBER,
28: ---- Changed by Kjinger
29: sel_id NUMBER,
30: --- Changes End
29: sel_id NUMBER,
30: --- Changes End
31: --Added by Keerthi 15-Sep-2003
32: source_id NUMBER,
33: source_table OKL_STRM_ELEMENTS.SOURCE_TABLE%TYPE,
34: -- Added by rgooty: 4212626
35: bill_adj_flag OKL_STRM_ELEMENTS.BILL_ADJ_FLAG%TYPE,
36: accrual_adj_flag OKL_STRM_ELEMENTS.ACCRUAL_ADJ_FLAG%TYPE,
37: -- Added by hkpatel for bug 4350255
31: --Added by Keerthi 15-Sep-2003
32: source_id NUMBER,
33: source_table OKL_STRM_ELEMENTS.SOURCE_TABLE%TYPE,
34: -- Added by rgooty: 4212626
35: bill_adj_flag OKL_STRM_ELEMENTS.BILL_ADJ_FLAG%TYPE,
36: accrual_adj_flag OKL_STRM_ELEMENTS.ACCRUAL_ADJ_FLAG%TYPE,
37: -- Added by hkpatel for bug 4350255
38: date_disbursed OKL_STRM_ELEMENTS.DATE_DISBURSED%TYPE );
39: g_miss_sel_rec sel_rec_type;
32: source_id NUMBER,
33: source_table OKL_STRM_ELEMENTS.SOURCE_TABLE%TYPE,
34: -- Added by rgooty: 4212626
35: bill_adj_flag OKL_STRM_ELEMENTS.BILL_ADJ_FLAG%TYPE,
36: accrual_adj_flag OKL_STRM_ELEMENTS.ACCRUAL_ADJ_FLAG%TYPE,
37: -- Added by hkpatel for bug 4350255
38: date_disbursed OKL_STRM_ELEMENTS.DATE_DISBURSED%TYPE );
39: g_miss_sel_rec sel_rec_type;
40: TYPE sel_tbl_type IS TABLE OF sel_rec_type
34: -- Added by rgooty: 4212626
35: bill_adj_flag OKL_STRM_ELEMENTS.BILL_ADJ_FLAG%TYPE,
36: accrual_adj_flag OKL_STRM_ELEMENTS.ACCRUAL_ADJ_FLAG%TYPE,
37: -- Added by hkpatel for bug 4350255
38: date_disbursed OKL_STRM_ELEMENTS.DATE_DISBURSED%TYPE );
39: g_miss_sel_rec sel_rec_type;
40: TYPE sel_tbl_type IS TABLE OF sel_rec_type
41: INDEX BY BINARY_INTEGER;
42: TYPE selv_rec_type IS RECORD (
43: id NUMBER ,
44: object_version_number NUMBER ,
45: stm_id NUMBER ,
46: amount NUMBER ,
47: comments OKL_STRM_ELEMENTS_V.COMMENTS%TYPE ,
48: accrued_yn OKL_STRM_ELEMENTS_V.ACCRUED_YN%TYPE ,
49: stream_element_date OKL_STRM_ELEMENTS_V.STREAM_ELEMENT_DATE%TYPE ,
50: program_id NUMBER ,
51: request_id NUMBER ,
44: object_version_number NUMBER ,
45: stm_id NUMBER ,
46: amount NUMBER ,
47: comments OKL_STRM_ELEMENTS_V.COMMENTS%TYPE ,
48: accrued_yn OKL_STRM_ELEMENTS_V.ACCRUED_YN%TYPE ,
49: stream_element_date OKL_STRM_ELEMENTS_V.STREAM_ELEMENT_DATE%TYPE ,
50: program_id NUMBER ,
51: request_id NUMBER ,
52: program_application_id NUMBER ,
45: stm_id NUMBER ,
46: amount NUMBER ,
47: comments OKL_STRM_ELEMENTS_V.COMMENTS%TYPE ,
48: accrued_yn OKL_STRM_ELEMENTS_V.ACCRUED_YN%TYPE ,
49: stream_element_date OKL_STRM_ELEMENTS_V.STREAM_ELEMENT_DATE%TYPE ,
50: program_id NUMBER ,
51: request_id NUMBER ,
52: program_application_id NUMBER ,
53: program_update_date OKL_STRM_ELEMENTS_V.PROGRAM_UPDATE_DATE%TYPE ,
49: stream_element_date OKL_STRM_ELEMENTS_V.STREAM_ELEMENT_DATE%TYPE ,
50: program_id NUMBER ,
51: request_id NUMBER ,
52: program_application_id NUMBER ,
53: program_update_date OKL_STRM_ELEMENTS_V.PROGRAM_UPDATE_DATE%TYPE ,
54: se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE ,
55: date_billed OKL_STRM_ELEMENTS_V.DATE_BILLED%TYPE ,
56: created_by NUMBER ,
57: creation_date OKL_STRM_ELEMENTS_V.CREATION_DATE%TYPE ,
50: program_id NUMBER ,
51: request_id NUMBER ,
52: program_application_id NUMBER ,
53: program_update_date OKL_STRM_ELEMENTS_V.PROGRAM_UPDATE_DATE%TYPE ,
54: se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE ,
55: date_billed OKL_STRM_ELEMENTS_V.DATE_BILLED%TYPE ,
56: created_by NUMBER ,
57: creation_date OKL_STRM_ELEMENTS_V.CREATION_DATE%TYPE ,
58: last_updated_by NUMBER ,
51: request_id NUMBER ,
52: program_application_id NUMBER ,
53: program_update_date OKL_STRM_ELEMENTS_V.PROGRAM_UPDATE_DATE%TYPE ,
54: se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE ,
55: date_billed OKL_STRM_ELEMENTS_V.DATE_BILLED%TYPE ,
56: created_by NUMBER ,
57: creation_date OKL_STRM_ELEMENTS_V.CREATION_DATE%TYPE ,
58: last_updated_by NUMBER ,
59: last_update_date OKL_STRM_ELEMENTS_V.LAST_UPDATE_DATE%TYPE ,
53: program_update_date OKL_STRM_ELEMENTS_V.PROGRAM_UPDATE_DATE%TYPE ,
54: se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE ,
55: date_billed OKL_STRM_ELEMENTS_V.DATE_BILLED%TYPE ,
56: created_by NUMBER ,
57: creation_date OKL_STRM_ELEMENTS_V.CREATION_DATE%TYPE ,
58: last_updated_by NUMBER ,
59: last_update_date OKL_STRM_ELEMENTS_V.LAST_UPDATE_DATE%TYPE ,
60: last_update_login NUMBER ,
61: parent_index NUMBER ,
55: date_billed OKL_STRM_ELEMENTS_V.DATE_BILLED%TYPE ,
56: created_by NUMBER ,
57: creation_date OKL_STRM_ELEMENTS_V.CREATION_DATE%TYPE ,
58: last_updated_by NUMBER ,
59: last_update_date OKL_STRM_ELEMENTS_V.LAST_UPDATE_DATE%TYPE ,
60: last_update_login NUMBER ,
61: parent_index NUMBER ,
62: ---- Changed by Kjinger
63: sel_id NUMBER ,
63: sel_id NUMBER ,
64: ---- Changes End
65: --Added by Keerthi 15-Sep-2003
66: source_id NUMBER ,
67: source_table OKL_STRM_ELEMENTS.SOURCE_TABLE%TYPE,
68: -- Added by rgooty: 4212626
69: bill_adj_flag OKL_STRM_ELEMENTS_V.BILL_ADJ_FLAG%TYPE,
70: accrual_adj_flag OKL_STRM_ELEMENTS_V.ACCRUAL_ADJ_FLAG%TYPE,
71: -- Added by hkpatel for bug 4350255
65: --Added by Keerthi 15-Sep-2003
66: source_id NUMBER ,
67: source_table OKL_STRM_ELEMENTS.SOURCE_TABLE%TYPE,
68: -- Added by rgooty: 4212626
69: bill_adj_flag OKL_STRM_ELEMENTS_V.BILL_ADJ_FLAG%TYPE,
70: accrual_adj_flag OKL_STRM_ELEMENTS_V.ACCRUAL_ADJ_FLAG%TYPE,
71: -- Added by hkpatel for bug 4350255
72: date_disbursed OKL_STRM_ELEMENTS_V.DATE_DISBURSED%TYPE );
73:
66: source_id NUMBER ,
67: source_table OKL_STRM_ELEMENTS.SOURCE_TABLE%TYPE,
68: -- Added by rgooty: 4212626
69: bill_adj_flag OKL_STRM_ELEMENTS_V.BILL_ADJ_FLAG%TYPE,
70: accrual_adj_flag OKL_STRM_ELEMENTS_V.ACCRUAL_ADJ_FLAG%TYPE,
71: -- Added by hkpatel for bug 4350255
72: date_disbursed OKL_STRM_ELEMENTS_V.DATE_DISBURSED%TYPE );
73:
74:
68: -- Added by rgooty: 4212626
69: bill_adj_flag OKL_STRM_ELEMENTS_V.BILL_ADJ_FLAG%TYPE,
70: accrual_adj_flag OKL_STRM_ELEMENTS_V.ACCRUAL_ADJ_FLAG%TYPE,
71: -- Added by hkpatel for bug 4350255
72: date_disbursed OKL_STRM_ELEMENTS_V.DATE_DISBURSED%TYPE );
73:
74:
75: g_miss_selv_rec selv_rec_type;
76: TYPE selv_tbl_type IS TABLE OF selv_rec_type