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_RPC_PVT dependencies on OKC_API

Line 7: id NUMBER := OKC_API.G_MISS_NUM,

3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE okl_repair_costs_tl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: language OKL_REPAIR_COSTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKL_REPAIR_COSTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKL_REPAIR_COSTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: repair_type OKL_REPAIR_COSTS_TL.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,

Line 8: language OKL_REPAIR_COSTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE okl_repair_costs_tl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: language OKL_REPAIR_COSTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKL_REPAIR_COSTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKL_REPAIR_COSTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: repair_type OKL_REPAIR_COSTS_TL.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
12: description OKL_REPAIR_COSTS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

Line 9: source_lang OKL_REPAIR_COSTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,

5: ---------------------------------------------------------------------------
6: TYPE okl_repair_costs_tl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: language OKL_REPAIR_COSTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKL_REPAIR_COSTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKL_REPAIR_COSTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: repair_type OKL_REPAIR_COSTS_TL.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
12: description OKL_REPAIR_COSTS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 10: sfwt_flag OKL_REPAIR_COSTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,

6: TYPE okl_repair_costs_tl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: language OKL_REPAIR_COSTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKL_REPAIR_COSTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKL_REPAIR_COSTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: repair_type OKL_REPAIR_COSTS_TL.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
12: description OKL_REPAIR_COSTS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_REPAIR_COSTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 11: repair_type OKL_REPAIR_COSTS_TL.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,

7: id NUMBER := OKC_API.G_MISS_NUM,
8: language OKL_REPAIR_COSTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKL_REPAIR_COSTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKL_REPAIR_COSTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: repair_type OKL_REPAIR_COSTS_TL.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
12: description OKL_REPAIR_COSTS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_REPAIR_COSTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 12: description OKL_REPAIR_COSTS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

8: language OKL_REPAIR_COSTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKL_REPAIR_COSTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKL_REPAIR_COSTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: repair_type OKL_REPAIR_COSTS_TL.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
12: description OKL_REPAIR_COSTS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_REPAIR_COSTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_REPAIR_COSTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 13: created_by NUMBER := OKC_API.G_MISS_NUM,

9: source_lang OKL_REPAIR_COSTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKL_REPAIR_COSTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: repair_type OKL_REPAIR_COSTS_TL.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
12: description OKL_REPAIR_COSTS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_REPAIR_COSTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_REPAIR_COSTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);

Line 14: creation_date OKL_REPAIR_COSTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

10: sfwt_flag OKL_REPAIR_COSTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: repair_type OKL_REPAIR_COSTS_TL.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
12: description OKL_REPAIR_COSTS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_REPAIR_COSTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_REPAIR_COSTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18:

Line 15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

11: repair_type OKL_REPAIR_COSTS_TL.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
12: description OKL_REPAIR_COSTS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_REPAIR_COSTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_REPAIR_COSTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18:
19: g_miss_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;

Line 16: last_update_date OKL_REPAIR_COSTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

12: description OKL_REPAIR_COSTS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_REPAIR_COSTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_REPAIR_COSTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18:
19: g_miss_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
20: TYPE okl_repair_costs_tl_tbl_type IS TABLE OF okl_repair_costs_tl_rec_type

Line 17: last_update_login NUMBER := OKC_API.G_MISS_NUM);

13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_REPAIR_COSTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_REPAIR_COSTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18:
19: g_miss_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
20: TYPE okl_repair_costs_tl_tbl_type IS TABLE OF okl_repair_costs_tl_rec_type
21: INDEX BY BINARY_INTEGER;

Line 23: id NUMBER := OKC_API.G_MISS_NUM,

19: g_miss_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
20: TYPE okl_repair_costs_tl_tbl_type IS TABLE OF okl_repair_costs_tl_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE rpc_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: enabled_yn OKL_REPAIR_COSTS_B.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
26: cost NUMBER := OKC_API.G_MISS_NUM,
27: org_id NUMBER := OKC_API.G_MISS_NUM,

Line 24: object_version_number NUMBER := OKC_API.G_MISS_NUM,

20: TYPE okl_repair_costs_tl_tbl_type IS TABLE OF okl_repair_costs_tl_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE rpc_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: enabled_yn OKL_REPAIR_COSTS_B.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
26: cost NUMBER := OKC_API.G_MISS_NUM,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 25: enabled_yn OKL_REPAIR_COSTS_B.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,

21: INDEX BY BINARY_INTEGER;
22: TYPE rpc_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: enabled_yn OKL_REPAIR_COSTS_B.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
26: cost NUMBER := OKC_API.G_MISS_NUM,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_REPAIR_COSTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 26: cost NUMBER := OKC_API.G_MISS_NUM,

22: TYPE rpc_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: enabled_yn OKL_REPAIR_COSTS_B.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
26: cost NUMBER := OKC_API.G_MISS_NUM,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_REPAIR_COSTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 27: org_id NUMBER := OKC_API.G_MISS_NUM,

23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: enabled_yn OKL_REPAIR_COSTS_B.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
26: cost NUMBER := OKC_API.G_MISS_NUM,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_REPAIR_COSTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_REPAIR_COSTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 28: created_by NUMBER := OKC_API.G_MISS_NUM,

24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: enabled_yn OKL_REPAIR_COSTS_B.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
26: cost NUMBER := OKC_API.G_MISS_NUM,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_REPAIR_COSTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_REPAIR_COSTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,

Line 29: creation_date OKL_REPAIR_COSTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

25: enabled_yn OKL_REPAIR_COSTS_B.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
26: cost NUMBER := OKC_API.G_MISS_NUM,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_REPAIR_COSTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_REPAIR_COSTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: -- SPILLAIP - 2667636 - Start

Line 30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

26: cost NUMBER := OKC_API.G_MISS_NUM,
27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_REPAIR_COSTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_REPAIR_COSTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: -- SPILLAIP - 2667636 - Start
34: currency_code OKL_REPAIR_COSTS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 31: last_update_date OKL_REPAIR_COSTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

27: org_id NUMBER := OKC_API.G_MISS_NUM,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_REPAIR_COSTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_REPAIR_COSTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: -- SPILLAIP - 2667636 - Start
34: currency_code OKL_REPAIR_COSTS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
35: currency_conversion_code OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 32: last_update_login NUMBER := OKC_API.G_MISS_NUM,

28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_REPAIR_COSTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_REPAIR_COSTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: -- SPILLAIP - 2667636 - Start
34: currency_code OKL_REPAIR_COSTS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
35: currency_conversion_code OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: currency_conversion_type OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,

Line 34: currency_code OKL_REPAIR_COSTS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,

30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_REPAIR_COSTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: -- SPILLAIP - 2667636 - Start
34: currency_code OKL_REPAIR_COSTS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
35: currency_conversion_code OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: currency_conversion_type OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
37: currency_conversion_rate OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
38: currency_conversion_date OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);

Line 35: currency_conversion_code OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,

31: last_update_date OKL_REPAIR_COSTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: -- SPILLAIP - 2667636 - Start
34: currency_code OKL_REPAIR_COSTS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
35: currency_conversion_code OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: currency_conversion_type OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
37: currency_conversion_rate OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
38: currency_conversion_date OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
39: -- SPILLAIP - 2667636 - End

Line 36: currency_conversion_type OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,

32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: -- SPILLAIP - 2667636 - Start
34: currency_code OKL_REPAIR_COSTS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
35: currency_conversion_code OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: currency_conversion_type OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
37: currency_conversion_rate OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
38: currency_conversion_date OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
39: -- SPILLAIP - 2667636 - End
40: g_miss_rpc_rec rpc_rec_type;

Line 37: currency_conversion_rate OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,

33: -- SPILLAIP - 2667636 - Start
34: currency_code OKL_REPAIR_COSTS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
35: currency_conversion_code OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: currency_conversion_type OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
37: currency_conversion_rate OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
38: currency_conversion_date OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
39: -- SPILLAIP - 2667636 - End
40: g_miss_rpc_rec rpc_rec_type;
41: TYPE rpc_tbl_type IS TABLE OF rpc_rec_type

Line 38: currency_conversion_date OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);

34: currency_code OKL_REPAIR_COSTS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
35: currency_conversion_code OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: currency_conversion_type OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
37: currency_conversion_rate OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
38: currency_conversion_date OKL_REPAIR_COSTS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
39: -- SPILLAIP - 2667636 - End
40: g_miss_rpc_rec rpc_rec_type;
41: TYPE rpc_tbl_type IS TABLE OF rpc_rec_type
42: INDEX BY BINARY_INTEGER;

Line 44: id NUMBER := OKC_API.G_MISS_NUM,

40: g_miss_rpc_rec rpc_rec_type;
41: TYPE rpc_tbl_type IS TABLE OF rpc_rec_type
42: INDEX BY BINARY_INTEGER;
43: TYPE rpcv_rec_type IS RECORD (
44: id NUMBER := OKC_API.G_MISS_NUM,
45: object_version_number NUMBER := OKC_API.G_MISS_NUM,
46: sfwt_flag OKL_REPAIR_COSTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47: enabled_yn OKL_REPAIR_COSTS_V.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
48: cost NUMBER := OKC_API.G_MISS_NUM,

Line 45: object_version_number NUMBER := OKC_API.G_MISS_NUM,

41: TYPE rpc_tbl_type IS TABLE OF rpc_rec_type
42: INDEX BY BINARY_INTEGER;
43: TYPE rpcv_rec_type IS RECORD (
44: id NUMBER := OKC_API.G_MISS_NUM,
45: object_version_number NUMBER := OKC_API.G_MISS_NUM,
46: sfwt_flag OKL_REPAIR_COSTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47: enabled_yn OKL_REPAIR_COSTS_V.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
48: cost NUMBER := OKC_API.G_MISS_NUM,
49: repair_type OKL_REPAIR_COSTS_V.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,

Line 46: sfwt_flag OKL_REPAIR_COSTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,

42: INDEX BY BINARY_INTEGER;
43: TYPE rpcv_rec_type IS RECORD (
44: id NUMBER := OKC_API.G_MISS_NUM,
45: object_version_number NUMBER := OKC_API.G_MISS_NUM,
46: sfwt_flag OKL_REPAIR_COSTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47: enabled_yn OKL_REPAIR_COSTS_V.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
48: cost NUMBER := OKC_API.G_MISS_NUM,
49: repair_type OKL_REPAIR_COSTS_V.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: description OKL_REPAIR_COSTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

Line 47: enabled_yn OKL_REPAIR_COSTS_V.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,

43: TYPE rpcv_rec_type IS RECORD (
44: id NUMBER := OKC_API.G_MISS_NUM,
45: object_version_number NUMBER := OKC_API.G_MISS_NUM,
46: sfwt_flag OKL_REPAIR_COSTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47: enabled_yn OKL_REPAIR_COSTS_V.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
48: cost NUMBER := OKC_API.G_MISS_NUM,
49: repair_type OKL_REPAIR_COSTS_V.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: description OKL_REPAIR_COSTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: org_id NUMBER := OKC_API.G_MISS_NUM,

Line 48: cost NUMBER := OKC_API.G_MISS_NUM,

44: id NUMBER := OKC_API.G_MISS_NUM,
45: object_version_number NUMBER := OKC_API.G_MISS_NUM,
46: sfwt_flag OKL_REPAIR_COSTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47: enabled_yn OKL_REPAIR_COSTS_V.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
48: cost NUMBER := OKC_API.G_MISS_NUM,
49: repair_type OKL_REPAIR_COSTS_V.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: description OKL_REPAIR_COSTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: org_id NUMBER := OKC_API.G_MISS_NUM,
52: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 49: repair_type OKL_REPAIR_COSTS_V.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,

45: object_version_number NUMBER := OKC_API.G_MISS_NUM,
46: sfwt_flag OKL_REPAIR_COSTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47: enabled_yn OKL_REPAIR_COSTS_V.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
48: cost NUMBER := OKC_API.G_MISS_NUM,
49: repair_type OKL_REPAIR_COSTS_V.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: description OKL_REPAIR_COSTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: org_id NUMBER := OKC_API.G_MISS_NUM,
52: created_by NUMBER := OKC_API.G_MISS_NUM,
53: creation_date OKL_REPAIR_COSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 50: description OKL_REPAIR_COSTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

46: sfwt_flag OKL_REPAIR_COSTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
47: enabled_yn OKL_REPAIR_COSTS_V.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
48: cost NUMBER := OKC_API.G_MISS_NUM,
49: repair_type OKL_REPAIR_COSTS_V.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: description OKL_REPAIR_COSTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: org_id NUMBER := OKC_API.G_MISS_NUM,
52: created_by NUMBER := OKC_API.G_MISS_NUM,
53: creation_date OKL_REPAIR_COSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
54: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 51: org_id NUMBER := OKC_API.G_MISS_NUM,

47: enabled_yn OKL_REPAIR_COSTS_V.ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
48: cost NUMBER := OKC_API.G_MISS_NUM,
49: repair_type OKL_REPAIR_COSTS_V.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: description OKL_REPAIR_COSTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: org_id NUMBER := OKC_API.G_MISS_NUM,
52: created_by NUMBER := OKC_API.G_MISS_NUM,
53: creation_date OKL_REPAIR_COSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
54: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
55: last_update_date OKL_REPAIR_COSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 52: created_by NUMBER := OKC_API.G_MISS_NUM,

48: cost NUMBER := OKC_API.G_MISS_NUM,
49: repair_type OKL_REPAIR_COSTS_V.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: description OKL_REPAIR_COSTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: org_id NUMBER := OKC_API.G_MISS_NUM,
52: created_by NUMBER := OKC_API.G_MISS_NUM,
53: creation_date OKL_REPAIR_COSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
54: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
55: last_update_date OKL_REPAIR_COSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_update_login NUMBER := OKC_API.G_MISS_NUM,

Line 53: creation_date OKL_REPAIR_COSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

49: repair_type OKL_REPAIR_COSTS_V.REPAIR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: description OKL_REPAIR_COSTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: org_id NUMBER := OKC_API.G_MISS_NUM,
52: created_by NUMBER := OKC_API.G_MISS_NUM,
53: creation_date OKL_REPAIR_COSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
54: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
55: last_update_date OKL_REPAIR_COSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_update_login NUMBER := OKC_API.G_MISS_NUM,
57: -- SPILLAIP - 2667636 - Start

Line 54: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

50: description OKL_REPAIR_COSTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: org_id NUMBER := OKC_API.G_MISS_NUM,
52: created_by NUMBER := OKC_API.G_MISS_NUM,
53: creation_date OKL_REPAIR_COSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
54: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
55: last_update_date OKL_REPAIR_COSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_update_login NUMBER := OKC_API.G_MISS_NUM,
57: -- SPILLAIP - 2667636 - Start
58: currency_code OKL_REPAIR_COSTS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 55: last_update_date OKL_REPAIR_COSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

51: org_id NUMBER := OKC_API.G_MISS_NUM,
52: created_by NUMBER := OKC_API.G_MISS_NUM,
53: creation_date OKL_REPAIR_COSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
54: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
55: last_update_date OKL_REPAIR_COSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_update_login NUMBER := OKC_API.G_MISS_NUM,
57: -- SPILLAIP - 2667636 - Start
58: currency_code OKL_REPAIR_COSTS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: currency_conversion_code OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 56: last_update_login NUMBER := OKC_API.G_MISS_NUM,

52: created_by NUMBER := OKC_API.G_MISS_NUM,
53: creation_date OKL_REPAIR_COSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
54: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
55: last_update_date OKL_REPAIR_COSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_update_login NUMBER := OKC_API.G_MISS_NUM,
57: -- SPILLAIP - 2667636 - Start
58: currency_code OKL_REPAIR_COSTS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: currency_conversion_code OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: currency_conversion_type OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,

Line 58: currency_code OKL_REPAIR_COSTS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,

54: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
55: last_update_date OKL_REPAIR_COSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_update_login NUMBER := OKC_API.G_MISS_NUM,
57: -- SPILLAIP - 2667636 - Start
58: currency_code OKL_REPAIR_COSTS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: currency_conversion_code OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: currency_conversion_type OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: currency_conversion_rate OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
62: currency_conversion_date OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);

Line 59: currency_conversion_code OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,

55: last_update_date OKL_REPAIR_COSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
56: last_update_login NUMBER := OKC_API.G_MISS_NUM,
57: -- SPILLAIP - 2667636 - Start
58: currency_code OKL_REPAIR_COSTS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: currency_conversion_code OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: currency_conversion_type OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: currency_conversion_rate OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
62: currency_conversion_date OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
63: -- SPILLAIP - 2667636 - End

Line 60: currency_conversion_type OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,

56: last_update_login NUMBER := OKC_API.G_MISS_NUM,
57: -- SPILLAIP - 2667636 - Start
58: currency_code OKL_REPAIR_COSTS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: currency_conversion_code OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: currency_conversion_type OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: currency_conversion_rate OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
62: currency_conversion_date OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
63: -- SPILLAIP - 2667636 - End
64: g_miss_rpcv_rec rpcv_rec_type;

Line 61: currency_conversion_rate OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,

57: -- SPILLAIP - 2667636 - Start
58: currency_code OKL_REPAIR_COSTS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: currency_conversion_code OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: currency_conversion_type OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: currency_conversion_rate OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
62: currency_conversion_date OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
63: -- SPILLAIP - 2667636 - End
64: g_miss_rpcv_rec rpcv_rec_type;
65: TYPE rpcv_tbl_type IS TABLE OF rpcv_rec_type

Line 62: currency_conversion_date OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);

58: currency_code OKL_REPAIR_COSTS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: currency_conversion_code OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: currency_conversion_type OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: currency_conversion_rate OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
62: currency_conversion_date OKL_REPAIR_COSTS_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
63: -- SPILLAIP - 2667636 - End
64: g_miss_rpcv_rec rpcv_rec_type;
65: TYPE rpcv_tbl_type IS TABLE OF rpcv_rec_type
66: INDEX BY BINARY_INTEGER;

Line 70: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

66: INDEX BY BINARY_INTEGER;
67: ---------------------------------------------------------------------------
68: -- GLOBAL MESSAGE CONSTANTS
69: ---------------------------------------------------------------------------
70: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
71: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
72: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
73: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
74: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line 71: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

67: ---------------------------------------------------------------------------
68: -- GLOBAL MESSAGE CONSTANTS
69: ---------------------------------------------------------------------------
70: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
71: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
72: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
73: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
74: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
75: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

Line 72: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

68: -- GLOBAL MESSAGE CONSTANTS
69: ---------------------------------------------------------------------------
70: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
71: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
72: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
73: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
74: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
75: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
76: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

Line 73: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

69: ---------------------------------------------------------------------------
70: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
71: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
72: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
73: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
74: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
75: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
76: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
77: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

Line 74: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

70: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
71: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
72: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
73: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
74: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
75: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
76: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
77: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
78: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

Line 75: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

71: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
72: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
73: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
74: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
75: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
76: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
77: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
78: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
79: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 76: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

72: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
73: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
74: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
75: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
76: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
77: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
78: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
79: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
80: ---------------------------------------------------------------------------

Line 77: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

73: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
74: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
75: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
76: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
77: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
78: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
79: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
80: ---------------------------------------------------------------------------
81: -- GLOBAL VARIABLES

Line 78: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

74: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
75: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
76: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
77: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
78: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
79: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
80: ---------------------------------------------------------------------------
81: -- GLOBAL VARIABLES
82: ---------------------------------------------------------------------------

Line 79: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

75: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
76: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
77: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
78: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
79: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
80: ---------------------------------------------------------------------------
81: -- GLOBAL VARIABLES
82: ---------------------------------------------------------------------------
83: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_RPC_PVT';

Line 84: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

80: ---------------------------------------------------------------------------
81: -- GLOBAL VARIABLES
82: ---------------------------------------------------------------------------
83: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_RPC_PVT';
84: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
85: ---------------------------------------------------------------------------
86: -- Procedures and Functions
87: ---------------------------------------------------------------------------
88:

Line 95: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

91: PROCEDURE api_copy;
92: PROCEDURE add_language;
93: PROCEDURE insert_row(
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,
98: x_msg_data OUT NOCOPY VARCHAR2,
99: p_rpcv_rec IN rpcv_rec_type,

Line 104: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

100: x_rpcv_rec OUT NOCOPY rpcv_rec_type);
101:
102: PROCEDURE insert_row(
103: p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,
108: p_rpcv_tbl IN rpcv_tbl_type,

Line 113: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

109: x_rpcv_tbl OUT NOCOPY rpcv_tbl_type);
110:
111: PROCEDURE lock_row(
112: p_api_version IN NUMBER,
113: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
114: x_return_status OUT NOCOPY VARCHAR2,
115: x_msg_count OUT NOCOPY NUMBER,
116: x_msg_data OUT NOCOPY VARCHAR2,
117: p_rpcv_rec IN rpcv_rec_type);

Line 121: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

117: p_rpcv_rec IN rpcv_rec_type);
118:
119: PROCEDURE lock_row(
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: p_rpcv_tbl IN rpcv_tbl_type);

Line 129: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

125: p_rpcv_tbl IN rpcv_tbl_type);
126:
127: PROCEDURE update_row(
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_rpcv_rec IN rpcv_rec_type,

Line 138: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

134: x_rpcv_rec OUT NOCOPY rpcv_rec_type);
135:
136: PROCEDURE update_row(
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: p_rpcv_tbl IN rpcv_tbl_type,

Line 147: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

143: x_rpcv_tbl OUT NOCOPY rpcv_tbl_type);
144:
145: PROCEDURE delete_row(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_rpcv_rec IN rpcv_rec_type);

Line 155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

151: p_rpcv_rec IN rpcv_rec_type);
152:
153: PROCEDURE delete_row(
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_rpcv_tbl IN rpcv_tbl_type);

Line 163: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

159: p_rpcv_tbl IN rpcv_tbl_type);
160:
161: PROCEDURE validate_row(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_rpcv_rec IN rpcv_rec_type);

Line 171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

167: p_rpcv_rec IN rpcv_rec_type);
168:
169: PROCEDURE validate_row(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_rpcv_tbl IN rpcv_tbl_type);