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.OKS_BSD_PRINT_PREVIEW_PVT dependencies on OKC_API

Line 7: id NUMBER := OKC_API.G_MISS_NUM

3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE bsd_pr_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,bsl_id NUMBER := OKC_API.G_MISS_NUM
9: ,bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM
10: ,bsd_id NUMBER := OKC_API.G_MISS_NUM
11: ,bsd_id_applied NUMBER := OKC_API.G_MISS_NUM

Line 8: ,bsl_id NUMBER := OKC_API.G_MISS_NUM

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE bsd_pr_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,bsl_id NUMBER := OKC_API.G_MISS_NUM
9: ,bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM
10: ,bsd_id NUMBER := OKC_API.G_MISS_NUM
11: ,bsd_id_applied NUMBER := OKC_API.G_MISS_NUM
12: ,unit_of_measure OKS_BSD_PR.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR

Line 9: ,bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM

5: ---------------------------------------------------------------------------
6: TYPE bsd_pr_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,bsl_id NUMBER := OKC_API.G_MISS_NUM
9: ,bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM
10: ,bsd_id NUMBER := OKC_API.G_MISS_NUM
11: ,bsd_id_applied NUMBER := OKC_API.G_MISS_NUM
12: ,unit_of_measure OKS_BSD_PR.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR
13: ,amcv_yn OKS_BSD_PR.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR

Line 10: ,bsd_id NUMBER := OKC_API.G_MISS_NUM

6: TYPE bsd_pr_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,bsl_id NUMBER := OKC_API.G_MISS_NUM
9: ,bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM
10: ,bsd_id NUMBER := OKC_API.G_MISS_NUM
11: ,bsd_id_applied NUMBER := OKC_API.G_MISS_NUM
12: ,unit_of_measure OKS_BSD_PR.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR
13: ,amcv_yn OKS_BSD_PR.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,result NUMBER := OKC_API.G_MISS_NUM

Line 11: ,bsd_id_applied NUMBER := OKC_API.G_MISS_NUM

7: id NUMBER := OKC_API.G_MISS_NUM
8: ,bsl_id NUMBER := OKC_API.G_MISS_NUM
9: ,bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM
10: ,bsd_id NUMBER := OKC_API.G_MISS_NUM
11: ,bsd_id_applied NUMBER := OKC_API.G_MISS_NUM
12: ,unit_of_measure OKS_BSD_PR.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR
13: ,amcv_yn OKS_BSD_PR.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,result NUMBER := OKC_API.G_MISS_NUM
15: ,amount NUMBER := OKC_API.G_MISS_NUM

Line 12: ,unit_of_measure OKS_BSD_PR.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR

8: ,bsl_id NUMBER := OKC_API.G_MISS_NUM
9: ,bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM
10: ,bsd_id NUMBER := OKC_API.G_MISS_NUM
11: ,bsd_id_applied NUMBER := OKC_API.G_MISS_NUM
12: ,unit_of_measure OKS_BSD_PR.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR
13: ,amcv_yn OKS_BSD_PR.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,result NUMBER := OKC_API.G_MISS_NUM
15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 13: ,amcv_yn OKS_BSD_PR.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR

9: ,bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM
10: ,bsd_id NUMBER := OKC_API.G_MISS_NUM
11: ,bsd_id_applied NUMBER := OKC_API.G_MISS_NUM
12: ,unit_of_measure OKS_BSD_PR.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR
13: ,amcv_yn OKS_BSD_PR.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,result NUMBER := OKC_API.G_MISS_NUM
15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
17: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 14: ,result NUMBER := OKC_API.G_MISS_NUM

10: ,bsd_id NUMBER := OKC_API.G_MISS_NUM
11: ,bsd_id_applied NUMBER := OKC_API.G_MISS_NUM
12: ,unit_of_measure OKS_BSD_PR.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR
13: ,amcv_yn OKS_BSD_PR.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,result NUMBER := OKC_API.G_MISS_NUM
15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
17: ,created_by NUMBER := OKC_API.G_MISS_NUM
18: ,creation_date OKS_BSD_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 15: ,amount NUMBER := OKC_API.G_MISS_NUM

11: ,bsd_id_applied NUMBER := OKC_API.G_MISS_NUM
12: ,unit_of_measure OKS_BSD_PR.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR
13: ,amcv_yn OKS_BSD_PR.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,result NUMBER := OKC_API.G_MISS_NUM
15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
17: ,created_by NUMBER := OKC_API.G_MISS_NUM
18: ,creation_date OKS_BSD_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 16: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

12: ,unit_of_measure OKS_BSD_PR.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR
13: ,amcv_yn OKS_BSD_PR.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,result NUMBER := OKC_API.G_MISS_NUM
15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
17: ,created_by NUMBER := OKC_API.G_MISS_NUM
18: ,creation_date OKS_BSD_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
20: ,last_update_date OKS_BSD_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 17: ,created_by NUMBER := OKC_API.G_MISS_NUM

13: ,amcv_yn OKS_BSD_PR.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,result NUMBER := OKC_API.G_MISS_NUM
15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
17: ,created_by NUMBER := OKC_API.G_MISS_NUM
18: ,creation_date OKS_BSD_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
20: ,last_update_date OKS_BSD_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,fixed NUMBER := OKC_API.G_MISS_NUM

Line 18: ,creation_date OKS_BSD_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

14: ,result NUMBER := OKC_API.G_MISS_NUM
15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
17: ,created_by NUMBER := OKC_API.G_MISS_NUM
18: ,creation_date OKS_BSD_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
20: ,last_update_date OKS_BSD_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,fixed NUMBER := OKC_API.G_MISS_NUM
22: ,actual NUMBER := OKC_API.G_MISS_NUM

Line 19: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
17: ,created_by NUMBER := OKC_API.G_MISS_NUM
18: ,creation_date OKS_BSD_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
20: ,last_update_date OKS_BSD_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,fixed NUMBER := OKC_API.G_MISS_NUM
22: ,actual NUMBER := OKC_API.G_MISS_NUM
23: ,default_default NUMBER := OKC_API.G_MISS_NUM

Line 20: ,last_update_date OKS_BSD_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

16: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
17: ,created_by NUMBER := OKC_API.G_MISS_NUM
18: ,creation_date OKS_BSD_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
20: ,last_update_date OKS_BSD_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,fixed NUMBER := OKC_API.G_MISS_NUM
22: ,actual NUMBER := OKC_API.G_MISS_NUM
23: ,default_default NUMBER := OKC_API.G_MISS_NUM
24: ,adjustment_level NUMBER := OKC_API.G_MISS_NUM

Line 21: ,fixed NUMBER := OKC_API.G_MISS_NUM

17: ,created_by NUMBER := OKC_API.G_MISS_NUM
18: ,creation_date OKS_BSD_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
20: ,last_update_date OKS_BSD_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,fixed NUMBER := OKC_API.G_MISS_NUM
22: ,actual NUMBER := OKC_API.G_MISS_NUM
23: ,default_default NUMBER := OKC_API.G_MISS_NUM
24: ,adjustment_level NUMBER := OKC_API.G_MISS_NUM
25: ,adjustment_minimum NUMBER := OKC_API.G_MISS_NUM

Line 22: ,actual NUMBER := OKC_API.G_MISS_NUM

18: ,creation_date OKS_BSD_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
20: ,last_update_date OKS_BSD_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,fixed NUMBER := OKC_API.G_MISS_NUM
22: ,actual NUMBER := OKC_API.G_MISS_NUM
23: ,default_default NUMBER := OKC_API.G_MISS_NUM
24: ,adjustment_level NUMBER := OKC_API.G_MISS_NUM
25: ,adjustment_minimum NUMBER := OKC_API.G_MISS_NUM
26: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 23: ,default_default NUMBER := OKC_API.G_MISS_NUM

19: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
20: ,last_update_date OKS_BSD_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,fixed NUMBER := OKC_API.G_MISS_NUM
22: ,actual NUMBER := OKC_API.G_MISS_NUM
23: ,default_default NUMBER := OKC_API.G_MISS_NUM
24: ,adjustment_level NUMBER := OKC_API.G_MISS_NUM
25: ,adjustment_minimum NUMBER := OKC_API.G_MISS_NUM
26: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
27: ,attribute_category OKS_BSD_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR

Line 24: ,adjustment_level NUMBER := OKC_API.G_MISS_NUM

20: ,last_update_date OKS_BSD_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,fixed NUMBER := OKC_API.G_MISS_NUM
22: ,actual NUMBER := OKC_API.G_MISS_NUM
23: ,default_default NUMBER := OKC_API.G_MISS_NUM
24: ,adjustment_level NUMBER := OKC_API.G_MISS_NUM
25: ,adjustment_minimum NUMBER := OKC_API.G_MISS_NUM
26: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
27: ,attribute_category OKS_BSD_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute1 OKS_BSD_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR

Line 25: ,adjustment_minimum NUMBER := OKC_API.G_MISS_NUM

21: ,fixed NUMBER := OKC_API.G_MISS_NUM
22: ,actual NUMBER := OKC_API.G_MISS_NUM
23: ,default_default NUMBER := OKC_API.G_MISS_NUM
24: ,adjustment_level NUMBER := OKC_API.G_MISS_NUM
25: ,adjustment_minimum NUMBER := OKC_API.G_MISS_NUM
26: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
27: ,attribute_category OKS_BSD_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute1 OKS_BSD_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute2 OKS_BSD_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR

Line 26: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

22: ,actual NUMBER := OKC_API.G_MISS_NUM
23: ,default_default NUMBER := OKC_API.G_MISS_NUM
24: ,adjustment_level NUMBER := OKC_API.G_MISS_NUM
25: ,adjustment_minimum NUMBER := OKC_API.G_MISS_NUM
26: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
27: ,attribute_category OKS_BSD_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute1 OKS_BSD_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute2 OKS_BSD_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute3 OKS_BSD_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR

Line 27: ,attribute_category OKS_BSD_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR

23: ,default_default NUMBER := OKC_API.G_MISS_NUM
24: ,adjustment_level NUMBER := OKC_API.G_MISS_NUM
25: ,adjustment_minimum NUMBER := OKC_API.G_MISS_NUM
26: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
27: ,attribute_category OKS_BSD_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute1 OKS_BSD_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute2 OKS_BSD_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute3 OKS_BSD_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute4 OKS_BSD_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR

Line 28: ,attribute1 OKS_BSD_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR

24: ,adjustment_level NUMBER := OKC_API.G_MISS_NUM
25: ,adjustment_minimum NUMBER := OKC_API.G_MISS_NUM
26: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
27: ,attribute_category OKS_BSD_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute1 OKS_BSD_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute2 OKS_BSD_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute3 OKS_BSD_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute4 OKS_BSD_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute5 OKS_BSD_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR

Line 29: ,attribute2 OKS_BSD_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR

25: ,adjustment_minimum NUMBER := OKC_API.G_MISS_NUM
26: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
27: ,attribute_category OKS_BSD_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute1 OKS_BSD_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute2 OKS_BSD_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute3 OKS_BSD_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute4 OKS_BSD_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute5 OKS_BSD_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute6 OKS_BSD_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR

Line 30: ,attribute3 OKS_BSD_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR

26: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
27: ,attribute_category OKS_BSD_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute1 OKS_BSD_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute2 OKS_BSD_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute3 OKS_BSD_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute4 OKS_BSD_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute5 OKS_BSD_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute6 OKS_BSD_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute7 OKS_BSD_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR

Line 31: ,attribute4 OKS_BSD_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR

27: ,attribute_category OKS_BSD_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute1 OKS_BSD_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute2 OKS_BSD_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute3 OKS_BSD_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute4 OKS_BSD_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute5 OKS_BSD_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute6 OKS_BSD_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute7 OKS_BSD_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute8 OKS_BSD_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR

Line 32: ,attribute5 OKS_BSD_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR

28: ,attribute1 OKS_BSD_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute2 OKS_BSD_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute3 OKS_BSD_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute4 OKS_BSD_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute5 OKS_BSD_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute6 OKS_BSD_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute7 OKS_BSD_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute8 OKS_BSD_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute9 OKS_BSD_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR

Line 33: ,attribute6 OKS_BSD_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR

29: ,attribute2 OKS_BSD_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute3 OKS_BSD_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute4 OKS_BSD_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute5 OKS_BSD_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute6 OKS_BSD_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute7 OKS_BSD_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute8 OKS_BSD_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute9 OKS_BSD_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute10 OKS_BSD_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR

Line 34: ,attribute7 OKS_BSD_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR

30: ,attribute3 OKS_BSD_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute4 OKS_BSD_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute5 OKS_BSD_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute6 OKS_BSD_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute7 OKS_BSD_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute8 OKS_BSD_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute9 OKS_BSD_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute10 OKS_BSD_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute11 OKS_BSD_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR

Line 35: ,attribute8 OKS_BSD_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR

31: ,attribute4 OKS_BSD_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute5 OKS_BSD_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute6 OKS_BSD_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute7 OKS_BSD_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute8 OKS_BSD_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute9 OKS_BSD_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute10 OKS_BSD_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute11 OKS_BSD_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute12 OKS_BSD_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR

Line 36: ,attribute9 OKS_BSD_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR

32: ,attribute5 OKS_BSD_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute6 OKS_BSD_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute7 OKS_BSD_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute8 OKS_BSD_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute9 OKS_BSD_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute10 OKS_BSD_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute11 OKS_BSD_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute12 OKS_BSD_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute13 OKS_BSD_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR

Line 37: ,attribute10 OKS_BSD_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR

33: ,attribute6 OKS_BSD_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute7 OKS_BSD_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute8 OKS_BSD_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute9 OKS_BSD_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute10 OKS_BSD_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute11 OKS_BSD_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute12 OKS_BSD_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute13 OKS_BSD_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute14 OKS_BSD_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR

Line 38: ,attribute11 OKS_BSD_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR

34: ,attribute7 OKS_BSD_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute8 OKS_BSD_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute9 OKS_BSD_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute10 OKS_BSD_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute11 OKS_BSD_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute12 OKS_BSD_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute13 OKS_BSD_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute14 OKS_BSD_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute15 OKS_BSD_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR

Line 39: ,attribute12 OKS_BSD_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR

35: ,attribute8 OKS_BSD_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute9 OKS_BSD_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute10 OKS_BSD_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute11 OKS_BSD_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute12 OKS_BSD_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute13 OKS_BSD_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute14 OKS_BSD_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute15 OKS_BSD_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
43: ,security_group_id NUMBER := OKC_API.G_MISS_NUM

Line 40: ,attribute13 OKS_BSD_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR

36: ,attribute9 OKS_BSD_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute10 OKS_BSD_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute11 OKS_BSD_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute12 OKS_BSD_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute13 OKS_BSD_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute14 OKS_BSD_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute15 OKS_BSD_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
43: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
44: ,start_reading NUMBER := OKC_API.G_MISS_NUM

Line 41: ,attribute14 OKS_BSD_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR

37: ,attribute10 OKS_BSD_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute11 OKS_BSD_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute12 OKS_BSD_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute13 OKS_BSD_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute14 OKS_BSD_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute15 OKS_BSD_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
43: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
44: ,start_reading NUMBER := OKC_API.G_MISS_NUM
45: ,end_reading NUMBER := OKC_API.G_MISS_NUM

Line 42: ,attribute15 OKS_BSD_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR

38: ,attribute11 OKS_BSD_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute12 OKS_BSD_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute13 OKS_BSD_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute14 OKS_BSD_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute15 OKS_BSD_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
43: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
44: ,start_reading NUMBER := OKC_API.G_MISS_NUM
45: ,end_reading NUMBER := OKC_API.G_MISS_NUM
46: ,base_reading NUMBER := OKC_API.G_MISS_NUM

Line 43: ,security_group_id NUMBER := OKC_API.G_MISS_NUM

39: ,attribute12 OKS_BSD_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute13 OKS_BSD_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute14 OKS_BSD_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute15 OKS_BSD_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
43: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
44: ,start_reading NUMBER := OKC_API.G_MISS_NUM
45: ,end_reading NUMBER := OKC_API.G_MISS_NUM
46: ,base_reading NUMBER := OKC_API.G_MISS_NUM
47: ,estimated_quantity NUMBER := OKC_API.G_MISS_NUM

Line 44: ,start_reading NUMBER := OKC_API.G_MISS_NUM

40: ,attribute13 OKS_BSD_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute14 OKS_BSD_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute15 OKS_BSD_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
43: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
44: ,start_reading NUMBER := OKC_API.G_MISS_NUM
45: ,end_reading NUMBER := OKC_API.G_MISS_NUM
46: ,base_reading NUMBER := OKC_API.G_MISS_NUM
47: ,estimated_quantity NUMBER := OKC_API.G_MISS_NUM
48: ,ccr_id NUMBER := OKC_API.G_MISS_NUM

Line 45: ,end_reading NUMBER := OKC_API.G_MISS_NUM

41: ,attribute14 OKS_BSD_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute15 OKS_BSD_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
43: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
44: ,start_reading NUMBER := OKC_API.G_MISS_NUM
45: ,end_reading NUMBER := OKC_API.G_MISS_NUM
46: ,base_reading NUMBER := OKC_API.G_MISS_NUM
47: ,estimated_quantity NUMBER := OKC_API.G_MISS_NUM
48: ,ccr_id NUMBER := OKC_API.G_MISS_NUM
49: ,cgr_id NUMBER := OKC_API.G_MISS_NUM);

Line 46: ,base_reading NUMBER := OKC_API.G_MISS_NUM

42: ,attribute15 OKS_BSD_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
43: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
44: ,start_reading NUMBER := OKC_API.G_MISS_NUM
45: ,end_reading NUMBER := OKC_API.G_MISS_NUM
46: ,base_reading NUMBER := OKC_API.G_MISS_NUM
47: ,estimated_quantity NUMBER := OKC_API.G_MISS_NUM
48: ,ccr_id NUMBER := OKC_API.G_MISS_NUM
49: ,cgr_id NUMBER := OKC_API.G_MISS_NUM);
50: G_MISS_bsd_pr_rec bsd_pr_rec_type;

Line 47: ,estimated_quantity NUMBER := OKC_API.G_MISS_NUM

43: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
44: ,start_reading NUMBER := OKC_API.G_MISS_NUM
45: ,end_reading NUMBER := OKC_API.G_MISS_NUM
46: ,base_reading NUMBER := OKC_API.G_MISS_NUM
47: ,estimated_quantity NUMBER := OKC_API.G_MISS_NUM
48: ,ccr_id NUMBER := OKC_API.G_MISS_NUM
49: ,cgr_id NUMBER := OKC_API.G_MISS_NUM);
50: G_MISS_bsd_pr_rec bsd_pr_rec_type;
51: TYPE bsd_pr_tbl_type IS TABLE OF bsd_pr_rec_type

Line 48: ,ccr_id NUMBER := OKC_API.G_MISS_NUM

44: ,start_reading NUMBER := OKC_API.G_MISS_NUM
45: ,end_reading NUMBER := OKC_API.G_MISS_NUM
46: ,base_reading NUMBER := OKC_API.G_MISS_NUM
47: ,estimated_quantity NUMBER := OKC_API.G_MISS_NUM
48: ,ccr_id NUMBER := OKC_API.G_MISS_NUM
49: ,cgr_id NUMBER := OKC_API.G_MISS_NUM);
50: G_MISS_bsd_pr_rec bsd_pr_rec_type;
51: TYPE bsd_pr_tbl_type IS TABLE OF bsd_pr_rec_type
52: INDEX BY BINARY_INTEGER;

Line 49: ,cgr_id NUMBER := OKC_API.G_MISS_NUM);

45: ,end_reading NUMBER := OKC_API.G_MISS_NUM
46: ,base_reading NUMBER := OKC_API.G_MISS_NUM
47: ,estimated_quantity NUMBER := OKC_API.G_MISS_NUM
48: ,ccr_id NUMBER := OKC_API.G_MISS_NUM
49: ,cgr_id NUMBER := OKC_API.G_MISS_NUM);
50: G_MISS_bsd_pr_rec bsd_pr_rec_type;
51: TYPE bsd_pr_tbl_type IS TABLE OF bsd_pr_rec_type
52: INDEX BY BINARY_INTEGER;
53:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

71: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
72: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
73: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
74: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
75: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
76: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
77: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
78: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_CONTRACTS_UNEXPECTED_ERROR';
79: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

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

72: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
73: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
74: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
75: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
76: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
77: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
78: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_CONTRACTS_UNEXPECTED_ERROR';
79: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
80: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

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

73: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
74: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
75: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
76: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
77: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
78: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_CONTRACTS_UNEXPECTED_ERROR';
79: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
80: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
81:

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

87: ---------------------------------------------------------------------------
88: -- GLOBAL VARIABLES
89: ---------------------------------------------------------------------------
90: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_BSD_PRINT_PREVIEW_PVT';
91: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
92: ---------------------------------------------------------------------------
93: -- Procedures and Functions
94: ---------------------------------------------------------------------------
95:

Line 101: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

97: PROCEDURE change_version;
98: PROCEDURE api_copy;
99: PROCEDURE insert_row(
100: p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,
104: x_msg_data OUT NOCOPY VARCHAR2,
105: p_bsd_pr_rec IN bsd_pr_rec_type,

Line 110: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

106: x_bsd_pr_rec OUT NOCOPY bsd_pr_rec_type);
107:
108: PROCEDURE lock_row(
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2,
114: p_bsd_pr_rec IN bsd_pr_rec_type);

Line 117: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

113: x_msg_data OUT NOCOPY VARCHAR2,
114: p_bsd_pr_rec IN bsd_pr_rec_type);
115: PROCEDURE lock_row(
116: p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_bsd_pr_tbl IN bsd_pr_tbl_type,

Line 125: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

121: p_bsd_pr_tbl IN bsd_pr_tbl_type,
122: px_error_tbl IN OUT NOCOPY ERROR_TBL_TYPE);
123: PROCEDURE lock_row(
124: p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2,
129: p_bsd_pr_tbl IN bsd_pr_tbl_type);

Line 132: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

128: x_msg_data OUT NOCOPY VARCHAR2,
129: p_bsd_pr_tbl IN bsd_pr_tbl_type);
130: PROCEDURE update_row(
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_bsd_pr_rec IN bsd_pr_rec_type,

Line 140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

136: p_bsd_pr_rec IN bsd_pr_rec_type,
137: x_bsd_pr_rec OUT NOCOPY bsd_pr_rec_type);
138: PROCEDURE update_row(
139: p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_bsd_pr_tbl IN bsd_pr_tbl_type,

Line 149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

145: x_bsd_pr_tbl OUT NOCOPY bsd_pr_tbl_type,
146: px_error_tbl IN OUT NOCOPY ERROR_TBL_TYPE);
147: PROCEDURE update_row(
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_bsd_pr_tbl IN bsd_pr_tbl_type,

Line 157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

153: p_bsd_pr_tbl IN bsd_pr_tbl_type,
154: x_bsd_pr_tbl OUT NOCOPY bsd_pr_tbl_type);
155: PROCEDURE delete_row(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_bsd_pr_rec IN bsd_pr_rec_type);

Line 164: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_bsd_pr_rec IN bsd_pr_rec_type);
162: PROCEDURE delete_row(
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_bsd_pr_tbl IN bsd_pr_tbl_type,

Line 172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

168: p_bsd_pr_tbl IN bsd_pr_tbl_type,
169: px_error_tbl IN OUT NOCOPY ERROR_TBL_TYPE);
170: PROCEDURE delete_row(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_bsd_pr_tbl IN bsd_pr_tbl_type);

Line 179: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_bsd_pr_tbl IN bsd_pr_tbl_type);
177: PROCEDURE validate_row(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_bsd_pr_rec IN bsd_pr_rec_type);

Line 186: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_bsd_pr_rec IN bsd_pr_rec_type);
184: PROCEDURE validate_row(
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_bsd_pr_tbl IN bsd_pr_tbl_type,

Line 194: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

190: p_bsd_pr_tbl IN bsd_pr_tbl_type,
191: px_error_tbl IN OUT NOCOPY ERROR_TBL_TYPE);
192: PROCEDURE validate_row(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_bsd_pr_tbl IN bsd_pr_tbl_type);