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.OKL_STM_PVT dependencies on OKL_STREAMS

Line 11: sgn_code OKL_STREAMS.SGN_CODE%TYPE ,

7: id NUMBER ,
8: sty_id NUMBER ,
9: khr_id NUMBER ,
10: kle_id NUMBER ,
11: sgn_code OKL_STREAMS.SGN_CODE%TYPE ,
12: say_code OKL_STREAMS.SAY_CODE%TYPE ,
13: transaction_number OKL_STREAMS.TRANSACTION_NUMBER%TYPE ,
14: active_yn OKL_STREAMS.ACTIVE_YN%TYPE ,
15: object_version_number NUMBER ,

Line 12: say_code OKL_STREAMS.SAY_CODE%TYPE ,

8: sty_id NUMBER ,
9: khr_id NUMBER ,
10: kle_id NUMBER ,
11: sgn_code OKL_STREAMS.SGN_CODE%TYPE ,
12: say_code OKL_STREAMS.SAY_CODE%TYPE ,
13: transaction_number OKL_STREAMS.TRANSACTION_NUMBER%TYPE ,
14: active_yn OKL_STREAMS.ACTIVE_YN%TYPE ,
15: object_version_number NUMBER ,
16: created_by NUMBER ,

Line 13: transaction_number OKL_STREAMS.TRANSACTION_NUMBER%TYPE ,

9: khr_id NUMBER ,
10: kle_id NUMBER ,
11: sgn_code OKL_STREAMS.SGN_CODE%TYPE ,
12: say_code OKL_STREAMS.SAY_CODE%TYPE ,
13: transaction_number OKL_STREAMS.TRANSACTION_NUMBER%TYPE ,
14: active_yn OKL_STREAMS.ACTIVE_YN%TYPE ,
15: object_version_number NUMBER ,
16: created_by NUMBER ,
17: creation_date OKL_STREAMS.CREATION_DATE%TYPE ,

Line 14: active_yn OKL_STREAMS.ACTIVE_YN%TYPE ,

10: kle_id NUMBER ,
11: sgn_code OKL_STREAMS.SGN_CODE%TYPE ,
12: say_code OKL_STREAMS.SAY_CODE%TYPE ,
13: transaction_number OKL_STREAMS.TRANSACTION_NUMBER%TYPE ,
14: active_yn OKL_STREAMS.ACTIVE_YN%TYPE ,
15: object_version_number NUMBER ,
16: created_by NUMBER ,
17: creation_date OKL_STREAMS.CREATION_DATE%TYPE ,
18: last_updated_by NUMBER ,

Line 17: creation_date OKL_STREAMS.CREATION_DATE%TYPE ,

13: transaction_number OKL_STREAMS.TRANSACTION_NUMBER%TYPE ,
14: active_yn OKL_STREAMS.ACTIVE_YN%TYPE ,
15: object_version_number NUMBER ,
16: created_by NUMBER ,
17: creation_date OKL_STREAMS.CREATION_DATE%TYPE ,
18: last_updated_by NUMBER ,
19: last_update_date OKL_STREAMS.LAST_UPDATE_DATE%TYPE ,
20: date_current OKL_STREAMS.DATE_CURRENT%TYPE ,
21: date_working OKL_STREAMS.DATE_WORKING%TYPE ,

Line 19: last_update_date OKL_STREAMS.LAST_UPDATE_DATE%TYPE ,

15: object_version_number NUMBER ,
16: created_by NUMBER ,
17: creation_date OKL_STREAMS.CREATION_DATE%TYPE ,
18: last_updated_by NUMBER ,
19: last_update_date OKL_STREAMS.LAST_UPDATE_DATE%TYPE ,
20: date_current OKL_STREAMS.DATE_CURRENT%TYPE ,
21: date_working OKL_STREAMS.DATE_WORKING%TYPE ,
22: date_history OKL_STREAMS.DATE_HISTORY%TYPE ,
23: comments OKL_STREAMS.COMMENTS%TYPE ,

Line 20: date_current OKL_STREAMS.DATE_CURRENT%TYPE ,

16: created_by NUMBER ,
17: creation_date OKL_STREAMS.CREATION_DATE%TYPE ,
18: last_updated_by NUMBER ,
19: last_update_date OKL_STREAMS.LAST_UPDATE_DATE%TYPE ,
20: date_current OKL_STREAMS.DATE_CURRENT%TYPE ,
21: date_working OKL_STREAMS.DATE_WORKING%TYPE ,
22: date_history OKL_STREAMS.DATE_HISTORY%TYPE ,
23: comments OKL_STREAMS.COMMENTS%TYPE ,
24: program_id NUMBER ,

Line 21: date_working OKL_STREAMS.DATE_WORKING%TYPE ,

17: creation_date OKL_STREAMS.CREATION_DATE%TYPE ,
18: last_updated_by NUMBER ,
19: last_update_date OKL_STREAMS.LAST_UPDATE_DATE%TYPE ,
20: date_current OKL_STREAMS.DATE_CURRENT%TYPE ,
21: date_working OKL_STREAMS.DATE_WORKING%TYPE ,
22: date_history OKL_STREAMS.DATE_HISTORY%TYPE ,
23: comments OKL_STREAMS.COMMENTS%TYPE ,
24: program_id NUMBER ,
25: request_id NUMBER ,

Line 22: date_history OKL_STREAMS.DATE_HISTORY%TYPE ,

18: last_updated_by NUMBER ,
19: last_update_date OKL_STREAMS.LAST_UPDATE_DATE%TYPE ,
20: date_current OKL_STREAMS.DATE_CURRENT%TYPE ,
21: date_working OKL_STREAMS.DATE_WORKING%TYPE ,
22: date_history OKL_STREAMS.DATE_HISTORY%TYPE ,
23: comments OKL_STREAMS.COMMENTS%TYPE ,
24: program_id NUMBER ,
25: request_id NUMBER ,
26: program_application_id NUMBER ,

Line 23: comments OKL_STREAMS.COMMENTS%TYPE ,

19: last_update_date OKL_STREAMS.LAST_UPDATE_DATE%TYPE ,
20: date_current OKL_STREAMS.DATE_CURRENT%TYPE ,
21: date_working OKL_STREAMS.DATE_WORKING%TYPE ,
22: date_history OKL_STREAMS.DATE_HISTORY%TYPE ,
23: comments OKL_STREAMS.COMMENTS%TYPE ,
24: program_id NUMBER ,
25: request_id NUMBER ,
26: program_application_id NUMBER ,
27: program_update_date OKL_STREAMS.PROGRAM_UPDATE_DATE%TYPE ,

Line 27: program_update_date OKL_STREAMS.PROGRAM_UPDATE_DATE%TYPE ,

23: comments OKL_STREAMS.COMMENTS%TYPE ,
24: program_id NUMBER ,
25: request_id NUMBER ,
26: program_application_id NUMBER ,
27: program_update_date OKL_STREAMS.PROGRAM_UPDATE_DATE%TYPE ,
28: last_update_login NUMBER ,
29: -- mvasudev, Bug#2650599
30: purpose_code OKL_STREAMS.PURPOSE_CODE%TYPE ,
31: --sty_code OKL_STREAMS.STY_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 30: purpose_code OKL_STREAMS.PURPOSE_CODE%TYPE ,

26: program_application_id NUMBER ,
27: program_update_date OKL_STREAMS.PROGRAM_UPDATE_DATE%TYPE ,
28: last_update_login NUMBER ,
29: -- mvasudev, Bug#2650599
30: purpose_code OKL_STREAMS.PURPOSE_CODE%TYPE ,
31: --sty_code OKL_STREAMS.STY_CODE%TYPE := OKC_API.G_MISS_CHAR
32: -- end, mvasudev, Bug#2650599
33: --- Changed by Kjinger
34: stm_id NUMBER ,

Line 31: --sty_code OKL_STREAMS.STY_CODE%TYPE := OKC_API.G_MISS_CHAR

27: program_update_date OKL_STREAMS.PROGRAM_UPDATE_DATE%TYPE ,
28: last_update_login NUMBER ,
29: -- mvasudev, Bug#2650599
30: purpose_code OKL_STREAMS.PURPOSE_CODE%TYPE ,
31: --sty_code OKL_STREAMS.STY_CODE%TYPE := OKC_API.G_MISS_CHAR
32: -- end, mvasudev, Bug#2650599
33: --- Changed by Kjinger
34: stm_id NUMBER ,
35: -- Change Ends

Line 38: source_table OKL_STREAMS.SOURCE_TABLE%TYPE,

34: stm_id NUMBER ,
35: -- Change Ends
36: -- Added by Keerthi for Bug 3166890
37: source_id NUMBER ,
38: source_table OKL_STREAMS.SOURCE_TABLE%TYPE,
39: -- Change Ends
40: -- rgooty : Start
41: trx_id NUMBER,
42: link_hist_stream_id NUMBER

Line 53: sgn_code OKL_STREAMS_V.SGN_CODE%TYPE ,

49: id NUMBER ,
50: sty_id NUMBER ,
51: khr_id NUMBER ,
52: kle_id NUMBER ,
53: sgn_code OKL_STREAMS_V.SGN_CODE%TYPE ,
54: say_code OKL_STREAMS_V.SAY_CODE%TYPE ,
55: transaction_number OKL_STREAMS_V.TRANSACTION_NUMBER%TYPE ,
56: active_yn OKL_STREAMS_V.ACTIVE_YN%TYPE ,
57: object_version_number NUMBER ,

Line 54: say_code OKL_STREAMS_V.SAY_CODE%TYPE ,

50: sty_id NUMBER ,
51: khr_id NUMBER ,
52: kle_id NUMBER ,
53: sgn_code OKL_STREAMS_V.SGN_CODE%TYPE ,
54: say_code OKL_STREAMS_V.SAY_CODE%TYPE ,
55: transaction_number OKL_STREAMS_V.TRANSACTION_NUMBER%TYPE ,
56: active_yn OKL_STREAMS_V.ACTIVE_YN%TYPE ,
57: object_version_number NUMBER ,
58: created_by NUMBER ,

Line 55: transaction_number OKL_STREAMS_V.TRANSACTION_NUMBER%TYPE ,

51: khr_id NUMBER ,
52: kle_id NUMBER ,
53: sgn_code OKL_STREAMS_V.SGN_CODE%TYPE ,
54: say_code OKL_STREAMS_V.SAY_CODE%TYPE ,
55: transaction_number OKL_STREAMS_V.TRANSACTION_NUMBER%TYPE ,
56: active_yn OKL_STREAMS_V.ACTIVE_YN%TYPE ,
57: object_version_number NUMBER ,
58: created_by NUMBER ,
59: creation_date OKL_STREAMS_V.CREATION_DATE%TYPE ,

Line 56: active_yn OKL_STREAMS_V.ACTIVE_YN%TYPE ,

52: kle_id NUMBER ,
53: sgn_code OKL_STREAMS_V.SGN_CODE%TYPE ,
54: say_code OKL_STREAMS_V.SAY_CODE%TYPE ,
55: transaction_number OKL_STREAMS_V.TRANSACTION_NUMBER%TYPE ,
56: active_yn OKL_STREAMS_V.ACTIVE_YN%TYPE ,
57: object_version_number NUMBER ,
58: created_by NUMBER ,
59: creation_date OKL_STREAMS_V.CREATION_DATE%TYPE ,
60: last_updated_by NUMBER ,

Line 59: creation_date OKL_STREAMS_V.CREATION_DATE%TYPE ,

55: transaction_number OKL_STREAMS_V.TRANSACTION_NUMBER%TYPE ,
56: active_yn OKL_STREAMS_V.ACTIVE_YN%TYPE ,
57: object_version_number NUMBER ,
58: created_by NUMBER ,
59: creation_date OKL_STREAMS_V.CREATION_DATE%TYPE ,
60: last_updated_by NUMBER ,
61: last_update_date OKL_STREAMS_V.LAST_UPDATE_DATE%TYPE ,
62: date_current OKL_STREAMS_V.DATE_CURRENT%TYPE ,
63: date_working OKL_STREAMS_V.DATE_WORKING%TYPE ,

Line 61: last_update_date OKL_STREAMS_V.LAST_UPDATE_DATE%TYPE ,

57: object_version_number NUMBER ,
58: created_by NUMBER ,
59: creation_date OKL_STREAMS_V.CREATION_DATE%TYPE ,
60: last_updated_by NUMBER ,
61: last_update_date OKL_STREAMS_V.LAST_UPDATE_DATE%TYPE ,
62: date_current OKL_STREAMS_V.DATE_CURRENT%TYPE ,
63: date_working OKL_STREAMS_V.DATE_WORKING%TYPE ,
64: date_history OKL_STREAMS_V.DATE_HISTORY%TYPE ,
65: comments OKL_STREAMS_V.COMMENTS%TYPE ,

Line 62: date_current OKL_STREAMS_V.DATE_CURRENT%TYPE ,

58: created_by NUMBER ,
59: creation_date OKL_STREAMS_V.CREATION_DATE%TYPE ,
60: last_updated_by NUMBER ,
61: last_update_date OKL_STREAMS_V.LAST_UPDATE_DATE%TYPE ,
62: date_current OKL_STREAMS_V.DATE_CURRENT%TYPE ,
63: date_working OKL_STREAMS_V.DATE_WORKING%TYPE ,
64: date_history OKL_STREAMS_V.DATE_HISTORY%TYPE ,
65: comments OKL_STREAMS_V.COMMENTS%TYPE ,
66: program_id NUMBER ,

Line 63: date_working OKL_STREAMS_V.DATE_WORKING%TYPE ,

59: creation_date OKL_STREAMS_V.CREATION_DATE%TYPE ,
60: last_updated_by NUMBER ,
61: last_update_date OKL_STREAMS_V.LAST_UPDATE_DATE%TYPE ,
62: date_current OKL_STREAMS_V.DATE_CURRENT%TYPE ,
63: date_working OKL_STREAMS_V.DATE_WORKING%TYPE ,
64: date_history OKL_STREAMS_V.DATE_HISTORY%TYPE ,
65: comments OKL_STREAMS_V.COMMENTS%TYPE ,
66: program_id NUMBER ,
67: request_id NUMBER ,

Line 64: date_history OKL_STREAMS_V.DATE_HISTORY%TYPE ,

60: last_updated_by NUMBER ,
61: last_update_date OKL_STREAMS_V.LAST_UPDATE_DATE%TYPE ,
62: date_current OKL_STREAMS_V.DATE_CURRENT%TYPE ,
63: date_working OKL_STREAMS_V.DATE_WORKING%TYPE ,
64: date_history OKL_STREAMS_V.DATE_HISTORY%TYPE ,
65: comments OKL_STREAMS_V.COMMENTS%TYPE ,
66: program_id NUMBER ,
67: request_id NUMBER ,
68: program_application_id NUMBER ,

Line 65: comments OKL_STREAMS_V.COMMENTS%TYPE ,

61: last_update_date OKL_STREAMS_V.LAST_UPDATE_DATE%TYPE ,
62: date_current OKL_STREAMS_V.DATE_CURRENT%TYPE ,
63: date_working OKL_STREAMS_V.DATE_WORKING%TYPE ,
64: date_history OKL_STREAMS_V.DATE_HISTORY%TYPE ,
65: comments OKL_STREAMS_V.COMMENTS%TYPE ,
66: program_id NUMBER ,
67: request_id NUMBER ,
68: program_application_id NUMBER ,
69: program_update_date OKL_STREAMS_V.PROGRAM_UPDATE_DATE%TYPE ,

Line 69: program_update_date OKL_STREAMS_V.PROGRAM_UPDATE_DATE%TYPE ,

65: comments OKL_STREAMS_V.COMMENTS%TYPE ,
66: program_id NUMBER ,
67: request_id NUMBER ,
68: program_application_id NUMBER ,
69: program_update_date OKL_STREAMS_V.PROGRAM_UPDATE_DATE%TYPE ,
70: last_update_login NUMBER ,
71: -- mvasudev, Bug#2650599
72: purpose_code OKL_STREAMS_V.PURPOSE_CODE%TYPE ,
73: --sty_code OKL_STREAMS_V.STY_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 72: purpose_code OKL_STREAMS_V.PURPOSE_CODE%TYPE ,

68: program_application_id NUMBER ,
69: program_update_date OKL_STREAMS_V.PROGRAM_UPDATE_DATE%TYPE ,
70: last_update_login NUMBER ,
71: -- mvasudev, Bug#2650599
72: purpose_code OKL_STREAMS_V.PURPOSE_CODE%TYPE ,
73: --sty_code OKL_STREAMS_V.STY_CODE%TYPE := OKC_API.G_MISS_CHAR
74: -- end, mvasudev, Bug#2650599
75: --- Changed by Kjinger
76: stm_id NUMBER ,

Line 73: --sty_code OKL_STREAMS_V.STY_CODE%TYPE := OKC_API.G_MISS_CHAR

69: program_update_date OKL_STREAMS_V.PROGRAM_UPDATE_DATE%TYPE ,
70: last_update_login NUMBER ,
71: -- mvasudev, Bug#2650599
72: purpose_code OKL_STREAMS_V.PURPOSE_CODE%TYPE ,
73: --sty_code OKL_STREAMS_V.STY_CODE%TYPE := OKC_API.G_MISS_CHAR
74: -- end, mvasudev, Bug#2650599
75: --- Changed by Kjinger
76: stm_id NUMBER ,
77: --- Change Ends

Line 80: source_table OKL_STREAMS.SOURCE_TABLE%TYPE,

76: stm_id NUMBER ,
77: --- Change Ends
78: -- Added by Keerthi for Bug 3166890
79: source_id NUMBER ,
80: source_table OKL_STREAMS.SOURCE_TABLE%TYPE,
81: -- rgooty : Start
82: trx_id NUMBER,
83: link_hist_stream_id NUMBER
84: -- rgooty : End