DBA Data[Home] [Help]

APPS.OKL_SEL_PVT dependencies on OKL_STRM_ELEMENTS

Line 13: stream_element_date OKL_STRM_ELEMENTS.STREAM_ELEMENT_DATE%TYPE,

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,

Line 15: comments OKL_STRM_ELEMENTS.COMMENTS%TYPE,

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,

Line 16: accrued_yn OKL_STRM_ELEMENTS.ACCRUED_YN%TYPE,

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,

Line 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,

Line 21: se_line_number OKL_STRM_ELEMENTS.SE_LINE_NUMBER%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,

Line 22: date_billed OKL_STRM_ELEMENTS.DATE_BILLED%TYPE,

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,

Line 24: creation_date OKL_STRM_ELEMENTS.CREATION_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

Line 26: last_update_date OKL_STRM_ELEMENTS.LAST_UPDATE_DATE%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
29: sel_id NUMBER,
30: --- Changes End

Line 33: source_table OKL_STRM_ELEMENTS.SOURCE_TABLE%TYPE,

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

Line 35: bill_adj_flag OKL_STRM_ELEMENTS.BILL_ADJ_FLAG%TYPE,

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;

Line 36: accrual_adj_flag OKL_STRM_ELEMENTS.ACCRUAL_ADJ_FLAG%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

Line 38: date_disbursed OKL_STRM_ELEMENTS.DATE_DISBURSED%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 (

Line 47: comments OKL_STRM_ELEMENTS_V.COMMENTS%TYPE ,

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 ,

Line 48: accrued_yn OKL_STRM_ELEMENTS_V.ACCRUED_YN%TYPE ,

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 ,

Line 49: stream_element_date OKL_STRM_ELEMENTS_V.STREAM_ELEMENT_DATE%TYPE ,

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 ,

Line 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 ,

Line 54: se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%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 ,

Line 55: date_billed OKL_STRM_ELEMENTS_V.DATE_BILLED%TYPE ,

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 ,

Line 57: creation_date OKL_STRM_ELEMENTS_V.CREATION_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 ,

Line 59: last_update_date OKL_STRM_ELEMENTS_V.LAST_UPDATE_DATE%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 ,
62: ---- Changed by Kjinger
63: sel_id NUMBER ,

Line 67: source_table OKL_STRM_ELEMENTS.SOURCE_TABLE%TYPE,

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

Line 69: bill_adj_flag OKL_STRM_ELEMENTS_V.BILL_ADJ_FLAG%TYPE,

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:

Line 70: accrual_adj_flag OKL_STRM_ELEMENTS_V.ACCRUAL_ADJ_FLAG%TYPE,

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:

Line 72: date_disbursed OKL_STRM_ELEMENTS_V.DATE_DISBURSED%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:
75: g_miss_selv_rec selv_rec_type;
76: TYPE selv_tbl_type IS TABLE OF selv_rec_type