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_TMG_PVT dependencies on OKL_API

Line 7: id NUMBER := OKL_API.G_MISS_NUM

3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE tmgv_rec_type IS RECORD (
7: id NUMBER := OKL_API.G_MISS_NUM
8: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
9: ,bch_id NUMBER := OKL_API.G_MISS_NUM
10: ,tmg_message_name OKL_TRX_MSGS_V.TMG_MESSAGE_NAME%TYPE := OKL_API.G_MISS_CHAR
11: ,tmg_application_id NUMBER := OKL_API.G_MISS_NUM

Line 8: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE tmgv_rec_type IS RECORD (
7: id NUMBER := OKL_API.G_MISS_NUM
8: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
9: ,bch_id NUMBER := OKL_API.G_MISS_NUM
10: ,tmg_message_name OKL_TRX_MSGS_V.TMG_MESSAGE_NAME%TYPE := OKL_API.G_MISS_CHAR
11: ,tmg_application_id NUMBER := OKL_API.G_MISS_NUM
12: ,tmg_language_code OKL_TRX_MSGS_V.TMG_LANGUAGE_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 9: ,bch_id NUMBER := OKL_API.G_MISS_NUM

5: ---------------------------------------------------------------------------
6: TYPE tmgv_rec_type IS RECORD (
7: id NUMBER := OKL_API.G_MISS_NUM
8: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
9: ,bch_id NUMBER := OKL_API.G_MISS_NUM
10: ,tmg_message_name OKL_TRX_MSGS_V.TMG_MESSAGE_NAME%TYPE := OKL_API.G_MISS_CHAR
11: ,tmg_application_id NUMBER := OKL_API.G_MISS_NUM
12: ,tmg_language_code OKL_TRX_MSGS_V.TMG_LANGUAGE_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,message_text OKL_TRX_MSGS_V.MESSAGE_TEXT%TYPE := OKL_API.G_MISS_CHAR

Line 10: ,tmg_message_name OKL_TRX_MSGS_V.TMG_MESSAGE_NAME%TYPE := OKL_API.G_MISS_CHAR

6: TYPE tmgv_rec_type IS RECORD (
7: id NUMBER := OKL_API.G_MISS_NUM
8: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
9: ,bch_id NUMBER := OKL_API.G_MISS_NUM
10: ,tmg_message_name OKL_TRX_MSGS_V.TMG_MESSAGE_NAME%TYPE := OKL_API.G_MISS_CHAR
11: ,tmg_application_id NUMBER := OKL_API.G_MISS_NUM
12: ,tmg_language_code OKL_TRX_MSGS_V.TMG_LANGUAGE_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,message_text OKL_TRX_MSGS_V.MESSAGE_TEXT%TYPE := OKL_API.G_MISS_CHAR
14: ,trx_id NUMBER := OKL_API.G_MISS_NUM

Line 11: ,tmg_application_id NUMBER := OKL_API.G_MISS_NUM

7: id NUMBER := OKL_API.G_MISS_NUM
8: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
9: ,bch_id NUMBER := OKL_API.G_MISS_NUM
10: ,tmg_message_name OKL_TRX_MSGS_V.TMG_MESSAGE_NAME%TYPE := OKL_API.G_MISS_CHAR
11: ,tmg_application_id NUMBER := OKL_API.G_MISS_NUM
12: ,tmg_language_code OKL_TRX_MSGS_V.TMG_LANGUAGE_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,message_text OKL_TRX_MSGS_V.MESSAGE_TEXT%TYPE := OKL_API.G_MISS_CHAR
14: ,trx_id NUMBER := OKL_API.G_MISS_NUM
15: ,trx_source_table OKL_TRX_MSGS_V.TRX_SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR

Line 12: ,tmg_language_code OKL_TRX_MSGS_V.TMG_LANGUAGE_CODE%TYPE := OKL_API.G_MISS_CHAR

8: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
9: ,bch_id NUMBER := OKL_API.G_MISS_NUM
10: ,tmg_message_name OKL_TRX_MSGS_V.TMG_MESSAGE_NAME%TYPE := OKL_API.G_MISS_CHAR
11: ,tmg_application_id NUMBER := OKL_API.G_MISS_NUM
12: ,tmg_language_code OKL_TRX_MSGS_V.TMG_LANGUAGE_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,message_text OKL_TRX_MSGS_V.MESSAGE_TEXT%TYPE := OKL_API.G_MISS_CHAR
14: ,trx_id NUMBER := OKL_API.G_MISS_NUM
15: ,trx_source_table OKL_TRX_MSGS_V.TRX_SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR
16: ,sequence_number NUMBER := OKL_API.G_MISS_NUM

Line 13: ,message_text OKL_TRX_MSGS_V.MESSAGE_TEXT%TYPE := OKL_API.G_MISS_CHAR

9: ,bch_id NUMBER := OKL_API.G_MISS_NUM
10: ,tmg_message_name OKL_TRX_MSGS_V.TMG_MESSAGE_NAME%TYPE := OKL_API.G_MISS_CHAR
11: ,tmg_application_id NUMBER := OKL_API.G_MISS_NUM
12: ,tmg_language_code OKL_TRX_MSGS_V.TMG_LANGUAGE_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,message_text OKL_TRX_MSGS_V.MESSAGE_TEXT%TYPE := OKL_API.G_MISS_CHAR
14: ,trx_id NUMBER := OKL_API.G_MISS_NUM
15: ,trx_source_table OKL_TRX_MSGS_V.TRX_SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR
16: ,sequence_number NUMBER := OKL_API.G_MISS_NUM
17: ,request_id NUMBER := OKL_API.G_MISS_NUM

Line 14: ,trx_id NUMBER := OKL_API.G_MISS_NUM

10: ,tmg_message_name OKL_TRX_MSGS_V.TMG_MESSAGE_NAME%TYPE := OKL_API.G_MISS_CHAR
11: ,tmg_application_id NUMBER := OKL_API.G_MISS_NUM
12: ,tmg_language_code OKL_TRX_MSGS_V.TMG_LANGUAGE_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,message_text OKL_TRX_MSGS_V.MESSAGE_TEXT%TYPE := OKL_API.G_MISS_CHAR
14: ,trx_id NUMBER := OKL_API.G_MISS_NUM
15: ,trx_source_table OKL_TRX_MSGS_V.TRX_SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR
16: ,sequence_number NUMBER := OKL_API.G_MISS_NUM
17: ,request_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

Line 15: ,trx_source_table OKL_TRX_MSGS_V.TRX_SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR

11: ,tmg_application_id NUMBER := OKL_API.G_MISS_NUM
12: ,tmg_language_code OKL_TRX_MSGS_V.TMG_LANGUAGE_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,message_text OKL_TRX_MSGS_V.MESSAGE_TEXT%TYPE := OKL_API.G_MISS_CHAR
14: ,trx_id NUMBER := OKL_API.G_MISS_NUM
15: ,trx_source_table OKL_TRX_MSGS_V.TRX_SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR
16: ,sequence_number NUMBER := OKL_API.G_MISS_NUM
17: ,request_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
19: ,program_id NUMBER := OKL_API.G_MISS_NUM

Line 16: ,sequence_number NUMBER := OKL_API.G_MISS_NUM

12: ,tmg_language_code OKL_TRX_MSGS_V.TMG_LANGUAGE_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,message_text OKL_TRX_MSGS_V.MESSAGE_TEXT%TYPE := OKL_API.G_MISS_CHAR
14: ,trx_id NUMBER := OKL_API.G_MISS_NUM
15: ,trx_source_table OKL_TRX_MSGS_V.TRX_SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR
16: ,sequence_number NUMBER := OKL_API.G_MISS_NUM
17: ,request_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
19: ,program_id NUMBER := OKL_API.G_MISS_NUM
20: ,program_update_date OKL_TRX_MSGS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 17: ,request_id NUMBER := OKL_API.G_MISS_NUM

13: ,message_text OKL_TRX_MSGS_V.MESSAGE_TEXT%TYPE := OKL_API.G_MISS_CHAR
14: ,trx_id NUMBER := OKL_API.G_MISS_NUM
15: ,trx_source_table OKL_TRX_MSGS_V.TRX_SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR
16: ,sequence_number NUMBER := OKL_API.G_MISS_NUM
17: ,request_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
19: ,program_id NUMBER := OKL_API.G_MISS_NUM
20: ,program_update_date OKL_TRX_MSGS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
21: ,created_by NUMBER := OKL_API.G_MISS_NUM

Line 18: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

14: ,trx_id NUMBER := OKL_API.G_MISS_NUM
15: ,trx_source_table OKL_TRX_MSGS_V.TRX_SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR
16: ,sequence_number NUMBER := OKL_API.G_MISS_NUM
17: ,request_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
19: ,program_id NUMBER := OKL_API.G_MISS_NUM
20: ,program_update_date OKL_TRX_MSGS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
21: ,created_by NUMBER := OKL_API.G_MISS_NUM
22: ,creation_date OKL_TRX_MSGS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

Line 19: ,program_id NUMBER := OKL_API.G_MISS_NUM

15: ,trx_source_table OKL_TRX_MSGS_V.TRX_SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR
16: ,sequence_number NUMBER := OKL_API.G_MISS_NUM
17: ,request_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
19: ,program_id NUMBER := OKL_API.G_MISS_NUM
20: ,program_update_date OKL_TRX_MSGS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
21: ,created_by NUMBER := OKL_API.G_MISS_NUM
22: ,creation_date OKL_TRX_MSGS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

Line 20: ,program_update_date OKL_TRX_MSGS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

16: ,sequence_number NUMBER := OKL_API.G_MISS_NUM
17: ,request_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
19: ,program_id NUMBER := OKL_API.G_MISS_NUM
20: ,program_update_date OKL_TRX_MSGS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
21: ,created_by NUMBER := OKL_API.G_MISS_NUM
22: ,creation_date OKL_TRX_MSGS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
24: ,last_update_date OKL_TRX_MSGS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 21: ,created_by NUMBER := OKL_API.G_MISS_NUM

17: ,request_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
19: ,program_id NUMBER := OKL_API.G_MISS_NUM
20: ,program_update_date OKL_TRX_MSGS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
21: ,created_by NUMBER := OKL_API.G_MISS_NUM
22: ,creation_date OKL_TRX_MSGS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
24: ,last_update_date OKL_TRX_MSGS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
25: ,last_update_login NUMBER := OKL_API.G_MISS_NUM

Line 22: ,creation_date OKL_TRX_MSGS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

18: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
19: ,program_id NUMBER := OKL_API.G_MISS_NUM
20: ,program_update_date OKL_TRX_MSGS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
21: ,created_by NUMBER := OKL_API.G_MISS_NUM
22: ,creation_date OKL_TRX_MSGS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
24: ,last_update_date OKL_TRX_MSGS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
25: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
26: -- RMUNJULU 3018641 Added column

Line 23: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

19: ,program_id NUMBER := OKL_API.G_MISS_NUM
20: ,program_update_date OKL_TRX_MSGS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
21: ,created_by NUMBER := OKL_API.G_MISS_NUM
22: ,creation_date OKL_TRX_MSGS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
24: ,last_update_date OKL_TRX_MSGS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
25: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
26: -- RMUNJULU 3018641 Added column
27: ,tmg_run NUMBER := OKL_API.G_MISS_NUM);

Line 24: ,last_update_date OKL_TRX_MSGS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

20: ,program_update_date OKL_TRX_MSGS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
21: ,created_by NUMBER := OKL_API.G_MISS_NUM
22: ,creation_date OKL_TRX_MSGS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
24: ,last_update_date OKL_TRX_MSGS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
25: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
26: -- RMUNJULU 3018641 Added column
27: ,tmg_run NUMBER := OKL_API.G_MISS_NUM);
28: G_MISS_tmgv_rec tmgv_rec_type;

Line 25: ,last_update_login NUMBER := OKL_API.G_MISS_NUM

21: ,created_by NUMBER := OKL_API.G_MISS_NUM
22: ,creation_date OKL_TRX_MSGS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
24: ,last_update_date OKL_TRX_MSGS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
25: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
26: -- RMUNJULU 3018641 Added column
27: ,tmg_run NUMBER := OKL_API.G_MISS_NUM);
28: G_MISS_tmgv_rec tmgv_rec_type;
29: TYPE tmgv_tbl_type IS TABLE OF tmgv_rec_type

Line 27: ,tmg_run NUMBER := OKL_API.G_MISS_NUM);

23: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
24: ,last_update_date OKL_TRX_MSGS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
25: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
26: -- RMUNJULU 3018641 Added column
27: ,tmg_run NUMBER := OKL_API.G_MISS_NUM);
28: G_MISS_tmgv_rec tmgv_rec_type;
29: TYPE tmgv_tbl_type IS TABLE OF tmgv_rec_type
30: INDEX BY BINARY_INTEGER;
31: TYPE tmg_rec_type IS RECORD (

Line 32: id NUMBER := OKL_API.G_MISS_NUM

28: G_MISS_tmgv_rec tmgv_rec_type;
29: TYPE tmgv_tbl_type IS TABLE OF tmgv_rec_type
30: INDEX BY BINARY_INTEGER;
31: TYPE tmg_rec_type IS RECORD (
32: id NUMBER := OKL_API.G_MISS_NUM
33: ,sequence_number NUMBER := OKL_API.G_MISS_NUM
34: ,trx_id NUMBER := OKL_API.G_MISS_NUM
35: ,trx_source_table OKL_TRX_MSGS.TRX_SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR
36: ,bch_id NUMBER := OKL_API.G_MISS_NUM

Line 33: ,sequence_number NUMBER := OKL_API.G_MISS_NUM

29: TYPE tmgv_tbl_type IS TABLE OF tmgv_rec_type
30: INDEX BY BINARY_INTEGER;
31: TYPE tmg_rec_type IS RECORD (
32: id NUMBER := OKL_API.G_MISS_NUM
33: ,sequence_number NUMBER := OKL_API.G_MISS_NUM
34: ,trx_id NUMBER := OKL_API.G_MISS_NUM
35: ,trx_source_table OKL_TRX_MSGS.TRX_SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR
36: ,bch_id NUMBER := OKL_API.G_MISS_NUM
37: ,tmg_language_code OKL_TRX_MSGS.TMG_LANGUAGE_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 34: ,trx_id NUMBER := OKL_API.G_MISS_NUM

30: INDEX BY BINARY_INTEGER;
31: TYPE tmg_rec_type IS RECORD (
32: id NUMBER := OKL_API.G_MISS_NUM
33: ,sequence_number NUMBER := OKL_API.G_MISS_NUM
34: ,trx_id NUMBER := OKL_API.G_MISS_NUM
35: ,trx_source_table OKL_TRX_MSGS.TRX_SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR
36: ,bch_id NUMBER := OKL_API.G_MISS_NUM
37: ,tmg_language_code OKL_TRX_MSGS.TMG_LANGUAGE_CODE%TYPE := OKL_API.G_MISS_CHAR
38: ,tmg_message_name OKL_TRX_MSGS.TMG_MESSAGE_NAME%TYPE := OKL_API.G_MISS_CHAR

Line 35: ,trx_source_table OKL_TRX_MSGS.TRX_SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR

31: TYPE tmg_rec_type IS RECORD (
32: id NUMBER := OKL_API.G_MISS_NUM
33: ,sequence_number NUMBER := OKL_API.G_MISS_NUM
34: ,trx_id NUMBER := OKL_API.G_MISS_NUM
35: ,trx_source_table OKL_TRX_MSGS.TRX_SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR
36: ,bch_id NUMBER := OKL_API.G_MISS_NUM
37: ,tmg_language_code OKL_TRX_MSGS.TMG_LANGUAGE_CODE%TYPE := OKL_API.G_MISS_CHAR
38: ,tmg_message_name OKL_TRX_MSGS.TMG_MESSAGE_NAME%TYPE := OKL_API.G_MISS_CHAR
39: ,tmg_application_id NUMBER := OKL_API.G_MISS_NUM

Line 36: ,bch_id NUMBER := OKL_API.G_MISS_NUM

32: id NUMBER := OKL_API.G_MISS_NUM
33: ,sequence_number NUMBER := OKL_API.G_MISS_NUM
34: ,trx_id NUMBER := OKL_API.G_MISS_NUM
35: ,trx_source_table OKL_TRX_MSGS.TRX_SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR
36: ,bch_id NUMBER := OKL_API.G_MISS_NUM
37: ,tmg_language_code OKL_TRX_MSGS.TMG_LANGUAGE_CODE%TYPE := OKL_API.G_MISS_CHAR
38: ,tmg_message_name OKL_TRX_MSGS.TMG_MESSAGE_NAME%TYPE := OKL_API.G_MISS_CHAR
39: ,tmg_application_id NUMBER := OKL_API.G_MISS_NUM
40: ,message_text OKL_TRX_MSGS.MESSAGE_TEXT%TYPE := OKL_API.G_MISS_CHAR

Line 37: ,tmg_language_code OKL_TRX_MSGS.TMG_LANGUAGE_CODE%TYPE := OKL_API.G_MISS_CHAR

33: ,sequence_number NUMBER := OKL_API.G_MISS_NUM
34: ,trx_id NUMBER := OKL_API.G_MISS_NUM
35: ,trx_source_table OKL_TRX_MSGS.TRX_SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR
36: ,bch_id NUMBER := OKL_API.G_MISS_NUM
37: ,tmg_language_code OKL_TRX_MSGS.TMG_LANGUAGE_CODE%TYPE := OKL_API.G_MISS_CHAR
38: ,tmg_message_name OKL_TRX_MSGS.TMG_MESSAGE_NAME%TYPE := OKL_API.G_MISS_CHAR
39: ,tmg_application_id NUMBER := OKL_API.G_MISS_NUM
40: ,message_text OKL_TRX_MSGS.MESSAGE_TEXT%TYPE := OKL_API.G_MISS_CHAR
41: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

Line 38: ,tmg_message_name OKL_TRX_MSGS.TMG_MESSAGE_NAME%TYPE := OKL_API.G_MISS_CHAR

34: ,trx_id NUMBER := OKL_API.G_MISS_NUM
35: ,trx_source_table OKL_TRX_MSGS.TRX_SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR
36: ,bch_id NUMBER := OKL_API.G_MISS_NUM
37: ,tmg_language_code OKL_TRX_MSGS.TMG_LANGUAGE_CODE%TYPE := OKL_API.G_MISS_CHAR
38: ,tmg_message_name OKL_TRX_MSGS.TMG_MESSAGE_NAME%TYPE := OKL_API.G_MISS_CHAR
39: ,tmg_application_id NUMBER := OKL_API.G_MISS_NUM
40: ,message_text OKL_TRX_MSGS.MESSAGE_TEXT%TYPE := OKL_API.G_MISS_CHAR
41: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
42: ,request_id NUMBER := OKL_API.G_MISS_NUM

Line 39: ,tmg_application_id NUMBER := OKL_API.G_MISS_NUM

35: ,trx_source_table OKL_TRX_MSGS.TRX_SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR
36: ,bch_id NUMBER := OKL_API.G_MISS_NUM
37: ,tmg_language_code OKL_TRX_MSGS.TMG_LANGUAGE_CODE%TYPE := OKL_API.G_MISS_CHAR
38: ,tmg_message_name OKL_TRX_MSGS.TMG_MESSAGE_NAME%TYPE := OKL_API.G_MISS_CHAR
39: ,tmg_application_id NUMBER := OKL_API.G_MISS_NUM
40: ,message_text OKL_TRX_MSGS.MESSAGE_TEXT%TYPE := OKL_API.G_MISS_CHAR
41: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
42: ,request_id NUMBER := OKL_API.G_MISS_NUM
43: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

Line 40: ,message_text OKL_TRX_MSGS.MESSAGE_TEXT%TYPE := OKL_API.G_MISS_CHAR

36: ,bch_id NUMBER := OKL_API.G_MISS_NUM
37: ,tmg_language_code OKL_TRX_MSGS.TMG_LANGUAGE_CODE%TYPE := OKL_API.G_MISS_CHAR
38: ,tmg_message_name OKL_TRX_MSGS.TMG_MESSAGE_NAME%TYPE := OKL_API.G_MISS_CHAR
39: ,tmg_application_id NUMBER := OKL_API.G_MISS_NUM
40: ,message_text OKL_TRX_MSGS.MESSAGE_TEXT%TYPE := OKL_API.G_MISS_CHAR
41: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
42: ,request_id NUMBER := OKL_API.G_MISS_NUM
43: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
44: ,program_id NUMBER := OKL_API.G_MISS_NUM

Line 41: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

37: ,tmg_language_code OKL_TRX_MSGS.TMG_LANGUAGE_CODE%TYPE := OKL_API.G_MISS_CHAR
38: ,tmg_message_name OKL_TRX_MSGS.TMG_MESSAGE_NAME%TYPE := OKL_API.G_MISS_CHAR
39: ,tmg_application_id NUMBER := OKL_API.G_MISS_NUM
40: ,message_text OKL_TRX_MSGS.MESSAGE_TEXT%TYPE := OKL_API.G_MISS_CHAR
41: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
42: ,request_id NUMBER := OKL_API.G_MISS_NUM
43: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
44: ,program_id NUMBER := OKL_API.G_MISS_NUM
45: ,program_update_date OKL_TRX_MSGS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 42: ,request_id NUMBER := OKL_API.G_MISS_NUM

38: ,tmg_message_name OKL_TRX_MSGS.TMG_MESSAGE_NAME%TYPE := OKL_API.G_MISS_CHAR
39: ,tmg_application_id NUMBER := OKL_API.G_MISS_NUM
40: ,message_text OKL_TRX_MSGS.MESSAGE_TEXT%TYPE := OKL_API.G_MISS_CHAR
41: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
42: ,request_id NUMBER := OKL_API.G_MISS_NUM
43: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
44: ,program_id NUMBER := OKL_API.G_MISS_NUM
45: ,program_update_date OKL_TRX_MSGS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
46: ,created_by NUMBER := OKL_API.G_MISS_NUM

Line 43: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

39: ,tmg_application_id NUMBER := OKL_API.G_MISS_NUM
40: ,message_text OKL_TRX_MSGS.MESSAGE_TEXT%TYPE := OKL_API.G_MISS_CHAR
41: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
42: ,request_id NUMBER := OKL_API.G_MISS_NUM
43: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
44: ,program_id NUMBER := OKL_API.G_MISS_NUM
45: ,program_update_date OKL_TRX_MSGS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
46: ,created_by NUMBER := OKL_API.G_MISS_NUM
47: ,creation_date OKL_TRX_MSGS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

Line 44: ,program_id NUMBER := OKL_API.G_MISS_NUM

40: ,message_text OKL_TRX_MSGS.MESSAGE_TEXT%TYPE := OKL_API.G_MISS_CHAR
41: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
42: ,request_id NUMBER := OKL_API.G_MISS_NUM
43: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
44: ,program_id NUMBER := OKL_API.G_MISS_NUM
45: ,program_update_date OKL_TRX_MSGS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
46: ,created_by NUMBER := OKL_API.G_MISS_NUM
47: ,creation_date OKL_TRX_MSGS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
48: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

Line 45: ,program_update_date OKL_TRX_MSGS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

41: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
42: ,request_id NUMBER := OKL_API.G_MISS_NUM
43: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
44: ,program_id NUMBER := OKL_API.G_MISS_NUM
45: ,program_update_date OKL_TRX_MSGS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
46: ,created_by NUMBER := OKL_API.G_MISS_NUM
47: ,creation_date OKL_TRX_MSGS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
48: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
49: ,last_update_date OKL_TRX_MSGS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 46: ,created_by NUMBER := OKL_API.G_MISS_NUM

42: ,request_id NUMBER := OKL_API.G_MISS_NUM
43: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
44: ,program_id NUMBER := OKL_API.G_MISS_NUM
45: ,program_update_date OKL_TRX_MSGS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
46: ,created_by NUMBER := OKL_API.G_MISS_NUM
47: ,creation_date OKL_TRX_MSGS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
48: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
49: ,last_update_date OKL_TRX_MSGS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
50: ,last_update_login NUMBER := OKL_API.G_MISS_NUM

Line 47: ,creation_date OKL_TRX_MSGS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

43: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
44: ,program_id NUMBER := OKL_API.G_MISS_NUM
45: ,program_update_date OKL_TRX_MSGS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
46: ,created_by NUMBER := OKL_API.G_MISS_NUM
47: ,creation_date OKL_TRX_MSGS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
48: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
49: ,last_update_date OKL_TRX_MSGS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
50: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
51: -- RMUNJULU 3018641 Added column

Line 48: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

44: ,program_id NUMBER := OKL_API.G_MISS_NUM
45: ,program_update_date OKL_TRX_MSGS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
46: ,created_by NUMBER := OKL_API.G_MISS_NUM
47: ,creation_date OKL_TRX_MSGS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
48: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
49: ,last_update_date OKL_TRX_MSGS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
50: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
51: -- RMUNJULU 3018641 Added column
52: ,tmg_run NUMBER := OKL_API.G_MISS_NUM);

Line 49: ,last_update_date OKL_TRX_MSGS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

45: ,program_update_date OKL_TRX_MSGS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
46: ,created_by NUMBER := OKL_API.G_MISS_NUM
47: ,creation_date OKL_TRX_MSGS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
48: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
49: ,last_update_date OKL_TRX_MSGS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
50: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
51: -- RMUNJULU 3018641 Added column
52: ,tmg_run NUMBER := OKL_API.G_MISS_NUM);
53: G_MISS_tmg_rec tmg_rec_type;

Line 50: ,last_update_login NUMBER := OKL_API.G_MISS_NUM

46: ,created_by NUMBER := OKL_API.G_MISS_NUM
47: ,creation_date OKL_TRX_MSGS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
48: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
49: ,last_update_date OKL_TRX_MSGS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
50: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
51: -- RMUNJULU 3018641 Added column
52: ,tmg_run NUMBER := OKL_API.G_MISS_NUM);
53: G_MISS_tmg_rec tmg_rec_type;
54: TYPE tmg_tbl_type IS TABLE OF tmg_rec_type

Line 52: ,tmg_run NUMBER := OKL_API.G_MISS_NUM);

48: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
49: ,last_update_date OKL_TRX_MSGS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
50: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
51: -- RMUNJULU 3018641 Added column
52: ,tmg_run NUMBER := OKL_API.G_MISS_NUM);
53: G_MISS_tmg_rec tmg_rec_type;
54: TYPE tmg_tbl_type IS TABLE OF tmg_rec_type
55: INDEX BY BINARY_INTEGER;
56: ---------------------------------------------------------------------------

Line 59: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;

55: INDEX BY BINARY_INTEGER;
56: ---------------------------------------------------------------------------
57: -- GLOBAL MESSAGE CONSTANTS
58: ---------------------------------------------------------------------------
59: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
60: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
61: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

Line 60: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;

56: ---------------------------------------------------------------------------
57: -- GLOBAL MESSAGE CONSTANTS
58: ---------------------------------------------------------------------------
59: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
60: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
61: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

Line 61: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;

57: -- GLOBAL MESSAGE CONSTANTS
58: ---------------------------------------------------------------------------
59: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
60: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
61: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

Line 62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;

58: ---------------------------------------------------------------------------
59: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
60: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
61: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
66: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

Line 63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

59: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
60: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
61: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
66: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
67: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

Line 64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

60: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
61: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
66: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
67: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
68: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

Line 65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

61: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
66: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
67: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
68: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
69: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

Line 66: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
66: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
67: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
68: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
69: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
70: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 67: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
66: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
67: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
68: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
69: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
70: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
71: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 68: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
66: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
67: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
68: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
69: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
70: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
71: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
72:

Line 82: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

78: ---------------------------------------------------------------------------
79: -- GLOBAL VARIABLES
80: ---------------------------------------------------------------------------
81: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TMG_PVT';
82: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
83: ---------------------------------------------------------------------------
84: -- Procedures and Functions
85: ---------------------------------------------------------------------------
86:

Line 92: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

88: PROCEDURE change_version;
89: PROCEDURE api_copy;
90: PROCEDURE insert_row(
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
93: x_return_status OUT NOCOPY VARCHAR2,
94: x_msg_count OUT NOCOPY NUMBER,
95: x_msg_data OUT NOCOPY VARCHAR2,
96: p_tmgv_rec IN tmgv_rec_type,

Line 100: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

96: p_tmgv_rec IN tmgv_rec_type,
97: x_tmgv_rec OUT NOCOPY tmgv_rec_type);
98: PROCEDURE insert_row(
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_tmgv_tbl IN tmgv_tbl_type,

Line 106: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_tmgv_tbl IN tmgv_tbl_type,
105: x_tmgv_tbl OUT NOCOPY tmgv_tbl_type,
106: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
107: PROCEDURE insert_row(
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
110: x_return_status OUT NOCOPY VARCHAR2,

Line 109: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

105: x_tmgv_tbl OUT NOCOPY tmgv_tbl_type,
106: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
107: PROCEDURE insert_row(
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2,
113: p_tmgv_tbl IN tmgv_tbl_type,

Line 117: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

113: p_tmgv_tbl IN tmgv_tbl_type,
114: x_tmgv_tbl OUT NOCOPY tmgv_tbl_type);
115: PROCEDURE lock_row(
116: p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
121: p_tmgv_rec IN tmgv_rec_type);

Line 124: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

120: x_msg_data OUT NOCOPY VARCHAR2,
121: p_tmgv_rec IN tmgv_rec_type);
122: PROCEDURE lock_row(
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_tmgv_tbl IN tmgv_tbl_type,

Line 129: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_tmgv_tbl IN tmgv_tbl_type,
129: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
130: PROCEDURE lock_row(
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
133: x_return_status OUT NOCOPY VARCHAR2,

Line 132: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

128: p_tmgv_tbl IN tmgv_tbl_type,
129: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
130: PROCEDURE lock_row(
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,
136: p_tmgv_tbl IN tmgv_tbl_type);

Line 139: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

135: x_msg_data OUT NOCOPY VARCHAR2,
136: p_tmgv_tbl IN tmgv_tbl_type);
137: PROCEDURE update_row(
138: p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_tmgv_rec IN tmgv_rec_type,

Line 147: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

143: p_tmgv_rec IN tmgv_rec_type,
144: x_tmgv_rec OUT NOCOPY tmgv_rec_type);
145: PROCEDURE update_row(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
151: p_tmgv_tbl IN tmgv_tbl_type,

Line 153: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
151: p_tmgv_tbl IN tmgv_tbl_type,
152: x_tmgv_tbl OUT NOCOPY tmgv_tbl_type,
153: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
154: PROCEDURE update_row(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
157: x_return_status OUT NOCOPY VARCHAR2,

Line 156: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

152: x_tmgv_tbl OUT NOCOPY tmgv_tbl_type,
153: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
154: PROCEDURE update_row(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_tmgv_tbl IN tmgv_tbl_type,

Line 164: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

160: p_tmgv_tbl IN tmgv_tbl_type,
161: x_tmgv_tbl OUT NOCOPY tmgv_tbl_type);
162: PROCEDURE delete_row(
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_tmgv_rec IN tmgv_rec_type);

Line 171: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_tmgv_rec IN tmgv_rec_type);
169: PROCEDURE delete_row(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_tmgv_tbl IN tmgv_tbl_type,

Line 176: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_tmgv_tbl IN tmgv_tbl_type,
176: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
177: PROCEDURE delete_row(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
180: x_return_status OUT NOCOPY VARCHAR2,

Line 179: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

175: p_tmgv_tbl IN tmgv_tbl_type,
176: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
177: PROCEDURE delete_row(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_tmgv_tbl IN tmgv_tbl_type);

Line 186: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_tmgv_tbl IN tmgv_tbl_type);
184: PROCEDURE validate_row(
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
189: x_msg_data OUT NOCOPY VARCHAR2,
190: p_tmgv_rec IN tmgv_rec_type);

Line 193: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

189: x_msg_data OUT NOCOPY VARCHAR2,
190: p_tmgv_rec IN tmgv_rec_type);
191: PROCEDURE validate_row(
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_tmgv_tbl IN tmgv_tbl_type,

Line 198: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_tmgv_tbl IN tmgv_tbl_type,
198: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
199: PROCEDURE validate_row(
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
202: x_return_status OUT NOCOPY VARCHAR2,

Line 201: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

197: p_tmgv_tbl IN tmgv_tbl_type,
198: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
199: PROCEDURE validate_row(
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_tmgv_tbl IN tmgv_tbl_type);