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

Line 8: id NUMBER := OKC_API.G_MISS_NUM

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_K_ORDER_DETAILS_V Record Spec
7: TYPE codv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cod_id NUMBER := OKC_API.G_MISS_NUM
10: ,apply_all_yn OKS_K_ORDER_DETAILS_V.APPLY_ALL_YN%TYPE := OKC_API.G_MISS_CHAR
11: ,line_renewal_type OKS_K_ORDER_DETAILS_V.LINE_RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,renewal_type OKS_K_ORDER_DETAILS_V.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 9: ,cod_id NUMBER := OKC_API.G_MISS_NUM

5: ---------------------------------------------------------------------------
6: -- OKS_K_ORDER_DETAILS_V Record Spec
7: TYPE codv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cod_id NUMBER := OKC_API.G_MISS_NUM
10: ,apply_all_yn OKS_K_ORDER_DETAILS_V.APPLY_ALL_YN%TYPE := OKC_API.G_MISS_CHAR
11: ,line_renewal_type OKS_K_ORDER_DETAILS_V.LINE_RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,renewal_type OKS_K_ORDER_DETAILS_V.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
13: ,po_required_yn OKS_K_ORDER_DETAILS_V.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR

Line 10: ,apply_all_yn OKS_K_ORDER_DETAILS_V.APPLY_ALL_YN%TYPE := OKC_API.G_MISS_CHAR

6: -- OKS_K_ORDER_DETAILS_V Record Spec
7: TYPE codv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cod_id NUMBER := OKC_API.G_MISS_NUM
10: ,apply_all_yn OKS_K_ORDER_DETAILS_V.APPLY_ALL_YN%TYPE := OKC_API.G_MISS_CHAR
11: ,line_renewal_type OKS_K_ORDER_DETAILS_V.LINE_RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,renewal_type OKS_K_ORDER_DETAILS_V.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
13: ,po_required_yn OKS_K_ORDER_DETAILS_V.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,renewal_pricing_type OKS_K_ORDER_DETAILS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 11: ,line_renewal_type OKS_K_ORDER_DETAILS_V.LINE_RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR

7: TYPE codv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cod_id NUMBER := OKC_API.G_MISS_NUM
10: ,apply_all_yn OKS_K_ORDER_DETAILS_V.APPLY_ALL_YN%TYPE := OKC_API.G_MISS_CHAR
11: ,line_renewal_type OKS_K_ORDER_DETAILS_V.LINE_RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,renewal_type OKS_K_ORDER_DETAILS_V.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
13: ,po_required_yn OKS_K_ORDER_DETAILS_V.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,renewal_pricing_type OKS_K_ORDER_DETAILS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
15: ,markup_percent NUMBER := OKC_API.G_MISS_NUM

Line 12: ,renewal_type OKS_K_ORDER_DETAILS_V.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR

8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cod_id NUMBER := OKC_API.G_MISS_NUM
10: ,apply_all_yn OKS_K_ORDER_DETAILS_V.APPLY_ALL_YN%TYPE := OKC_API.G_MISS_CHAR
11: ,line_renewal_type OKS_K_ORDER_DETAILS_V.LINE_RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,renewal_type OKS_K_ORDER_DETAILS_V.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
13: ,po_required_yn OKS_K_ORDER_DETAILS_V.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,renewal_pricing_type OKS_K_ORDER_DETAILS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
15: ,markup_percent NUMBER := OKC_API.G_MISS_NUM
16: ,link_order_header_id NUMBER := OKC_API.G_MISS_NUM

Line 13: ,po_required_yn OKS_K_ORDER_DETAILS_V.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR

9: ,cod_id NUMBER := OKC_API.G_MISS_NUM
10: ,apply_all_yn OKS_K_ORDER_DETAILS_V.APPLY_ALL_YN%TYPE := OKC_API.G_MISS_CHAR
11: ,line_renewal_type OKS_K_ORDER_DETAILS_V.LINE_RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,renewal_type OKS_K_ORDER_DETAILS_V.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
13: ,po_required_yn OKS_K_ORDER_DETAILS_V.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,renewal_pricing_type OKS_K_ORDER_DETAILS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
15: ,markup_percent NUMBER := OKC_API.G_MISS_NUM
16: ,link_order_header_id NUMBER := OKC_API.G_MISS_NUM
17: ,end_date OKS_K_ORDER_DETAILS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE

Line 14: ,renewal_pricing_type OKS_K_ORDER_DETAILS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR

10: ,apply_all_yn OKS_K_ORDER_DETAILS_V.APPLY_ALL_YN%TYPE := OKC_API.G_MISS_CHAR
11: ,line_renewal_type OKS_K_ORDER_DETAILS_V.LINE_RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,renewal_type OKS_K_ORDER_DETAILS_V.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
13: ,po_required_yn OKS_K_ORDER_DETAILS_V.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,renewal_pricing_type OKS_K_ORDER_DETAILS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
15: ,markup_percent NUMBER := OKC_API.G_MISS_NUM
16: ,link_order_header_id NUMBER := OKC_API.G_MISS_NUM
17: ,end_date OKS_K_ORDER_DETAILS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,cod_type OKS_K_ORDER_DETAILS_V.COD_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 15: ,markup_percent NUMBER := OKC_API.G_MISS_NUM

11: ,line_renewal_type OKS_K_ORDER_DETAILS_V.LINE_RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,renewal_type OKS_K_ORDER_DETAILS_V.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
13: ,po_required_yn OKS_K_ORDER_DETAILS_V.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,renewal_pricing_type OKS_K_ORDER_DETAILS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
15: ,markup_percent NUMBER := OKC_API.G_MISS_NUM
16: ,link_order_header_id NUMBER := OKC_API.G_MISS_NUM
17: ,end_date OKS_K_ORDER_DETAILS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,cod_type OKS_K_ORDER_DETAILS_V.COD_TYPE%TYPE := OKC_API.G_MISS_CHAR
19: ,order_line_id1 OKS_K_ORDER_DETAILS_V.ORDER_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR

Line 16: ,link_order_header_id NUMBER := OKC_API.G_MISS_NUM

12: ,renewal_type OKS_K_ORDER_DETAILS_V.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
13: ,po_required_yn OKS_K_ORDER_DETAILS_V.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,renewal_pricing_type OKS_K_ORDER_DETAILS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
15: ,markup_percent NUMBER := OKC_API.G_MISS_NUM
16: ,link_order_header_id NUMBER := OKC_API.G_MISS_NUM
17: ,end_date OKS_K_ORDER_DETAILS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,cod_type OKS_K_ORDER_DETAILS_V.COD_TYPE%TYPE := OKC_API.G_MISS_CHAR
19: ,order_line_id1 OKS_K_ORDER_DETAILS_V.ORDER_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
20: ,order_line_id2 OKS_K_ORDER_DETAILS_V.ORDER_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR

Line 17: ,end_date OKS_K_ORDER_DETAILS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE

13: ,po_required_yn OKS_K_ORDER_DETAILS_V.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,renewal_pricing_type OKS_K_ORDER_DETAILS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
15: ,markup_percent NUMBER := OKC_API.G_MISS_NUM
16: ,link_order_header_id NUMBER := OKC_API.G_MISS_NUM
17: ,end_date OKS_K_ORDER_DETAILS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,cod_type OKS_K_ORDER_DETAILS_V.COD_TYPE%TYPE := OKC_API.G_MISS_CHAR
19: ,order_line_id1 OKS_K_ORDER_DETAILS_V.ORDER_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
20: ,order_line_id2 OKS_K_ORDER_DETAILS_V.ORDER_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
21: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 18: ,cod_type OKS_K_ORDER_DETAILS_V.COD_TYPE%TYPE := OKC_API.G_MISS_CHAR

14: ,renewal_pricing_type OKS_K_ORDER_DETAILS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
15: ,markup_percent NUMBER := OKC_API.G_MISS_NUM
16: ,link_order_header_id NUMBER := OKC_API.G_MISS_NUM
17: ,end_date OKS_K_ORDER_DETAILS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,cod_type OKS_K_ORDER_DETAILS_V.COD_TYPE%TYPE := OKC_API.G_MISS_CHAR
19: ,order_line_id1 OKS_K_ORDER_DETAILS_V.ORDER_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
20: ,order_line_id2 OKS_K_ORDER_DETAILS_V.ORDER_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
21: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
22: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 19: ,order_line_id1 OKS_K_ORDER_DETAILS_V.ORDER_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR

15: ,markup_percent NUMBER := OKC_API.G_MISS_NUM
16: ,link_order_header_id NUMBER := OKC_API.G_MISS_NUM
17: ,end_date OKS_K_ORDER_DETAILS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,cod_type OKS_K_ORDER_DETAILS_V.COD_TYPE%TYPE := OKC_API.G_MISS_CHAR
19: ,order_line_id1 OKS_K_ORDER_DETAILS_V.ORDER_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
20: ,order_line_id2 OKS_K_ORDER_DETAILS_V.ORDER_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
21: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
22: ,created_by NUMBER := OKC_API.G_MISS_NUM
23: ,creation_date OKS_K_ORDER_DETAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 20: ,order_line_id2 OKS_K_ORDER_DETAILS_V.ORDER_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR

16: ,link_order_header_id NUMBER := OKC_API.G_MISS_NUM
17: ,end_date OKS_K_ORDER_DETAILS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,cod_type OKS_K_ORDER_DETAILS_V.COD_TYPE%TYPE := OKC_API.G_MISS_CHAR
19: ,order_line_id1 OKS_K_ORDER_DETAILS_V.ORDER_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
20: ,order_line_id2 OKS_K_ORDER_DETAILS_V.ORDER_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
21: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
22: ,created_by NUMBER := OKC_API.G_MISS_NUM
23: ,creation_date OKS_K_ORDER_DETAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 21: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

17: ,end_date OKS_K_ORDER_DETAILS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,cod_type OKS_K_ORDER_DETAILS_V.COD_TYPE%TYPE := OKC_API.G_MISS_CHAR
19: ,order_line_id1 OKS_K_ORDER_DETAILS_V.ORDER_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
20: ,order_line_id2 OKS_K_ORDER_DETAILS_V.ORDER_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
21: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
22: ,created_by NUMBER := OKC_API.G_MISS_NUM
23: ,creation_date OKS_K_ORDER_DETAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
25: ,last_update_date OKS_K_ORDER_DETAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 22: ,created_by NUMBER := OKC_API.G_MISS_NUM

18: ,cod_type OKS_K_ORDER_DETAILS_V.COD_TYPE%TYPE := OKC_API.G_MISS_CHAR
19: ,order_line_id1 OKS_K_ORDER_DETAILS_V.ORDER_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
20: ,order_line_id2 OKS_K_ORDER_DETAILS_V.ORDER_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
21: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
22: ,created_by NUMBER := OKC_API.G_MISS_NUM
23: ,creation_date OKS_K_ORDER_DETAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
25: ,last_update_date OKS_K_ORDER_DETAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,link_ord_line_id1 OKS_K_ORDER_DETAILS_V.LINK_ORD_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR

Line 23: ,creation_date OKS_K_ORDER_DETAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

19: ,order_line_id1 OKS_K_ORDER_DETAILS_V.ORDER_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
20: ,order_line_id2 OKS_K_ORDER_DETAILS_V.ORDER_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
21: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
22: ,created_by NUMBER := OKC_API.G_MISS_NUM
23: ,creation_date OKS_K_ORDER_DETAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
25: ,last_update_date OKS_K_ORDER_DETAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,link_ord_line_id1 OKS_K_ORDER_DETAILS_V.LINK_ORD_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
27: ,link_ord_line_id2 OKS_K_ORDER_DETAILS_V.LINK_ORD_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR

Line 24: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

20: ,order_line_id2 OKS_K_ORDER_DETAILS_V.ORDER_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
21: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
22: ,created_by NUMBER := OKC_API.G_MISS_NUM
23: ,creation_date OKS_K_ORDER_DETAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
25: ,last_update_date OKS_K_ORDER_DETAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,link_ord_line_id1 OKS_K_ORDER_DETAILS_V.LINK_ORD_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
27: ,link_ord_line_id2 OKS_K_ORDER_DETAILS_V.LINK_ORD_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
28: ,link_chr_id NUMBER := OKC_API.G_MISS_NUM

Line 25: ,last_update_date OKS_K_ORDER_DETAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

21: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
22: ,created_by NUMBER := OKC_API.G_MISS_NUM
23: ,creation_date OKS_K_ORDER_DETAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
25: ,last_update_date OKS_K_ORDER_DETAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,link_ord_line_id1 OKS_K_ORDER_DETAILS_V.LINK_ORD_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
27: ,link_ord_line_id2 OKS_K_ORDER_DETAILS_V.LINK_ORD_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
28: ,link_chr_id NUMBER := OKC_API.G_MISS_NUM
29: ,link_cle_id NUMBER := OKC_API.G_MISS_NUM

Line 26: ,link_ord_line_id1 OKS_K_ORDER_DETAILS_V.LINK_ORD_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR

22: ,created_by NUMBER := OKC_API.G_MISS_NUM
23: ,creation_date OKS_K_ORDER_DETAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
25: ,last_update_date OKS_K_ORDER_DETAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,link_ord_line_id1 OKS_K_ORDER_DETAILS_V.LINK_ORD_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
27: ,link_ord_line_id2 OKS_K_ORDER_DETAILS_V.LINK_ORD_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
28: ,link_chr_id NUMBER := OKC_API.G_MISS_NUM
29: ,link_cle_id NUMBER := OKC_API.G_MISS_NUM
30: ,price_list_id1 OKS_K_ORDER_DETAILS_V.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR

Line 27: ,link_ord_line_id2 OKS_K_ORDER_DETAILS_V.LINK_ORD_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR

23: ,creation_date OKS_K_ORDER_DETAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
25: ,last_update_date OKS_K_ORDER_DETAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,link_ord_line_id1 OKS_K_ORDER_DETAILS_V.LINK_ORD_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
27: ,link_ord_line_id2 OKS_K_ORDER_DETAILS_V.LINK_ORD_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
28: ,link_chr_id NUMBER := OKC_API.G_MISS_NUM
29: ,link_cle_id NUMBER := OKC_API.G_MISS_NUM
30: ,price_list_id1 OKS_K_ORDER_DETAILS_V.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR
31: ,price_list_id2 OKS_K_ORDER_DETAILS_V.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR

Line 28: ,link_chr_id NUMBER := OKC_API.G_MISS_NUM

24: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
25: ,last_update_date OKS_K_ORDER_DETAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,link_ord_line_id1 OKS_K_ORDER_DETAILS_V.LINK_ORD_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
27: ,link_ord_line_id2 OKS_K_ORDER_DETAILS_V.LINK_ORD_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
28: ,link_chr_id NUMBER := OKC_API.G_MISS_NUM
29: ,link_cle_id NUMBER := OKC_API.G_MISS_NUM
30: ,price_list_id1 OKS_K_ORDER_DETAILS_V.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR
31: ,price_list_id2 OKS_K_ORDER_DETAILS_V.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR
32: ,chr_id NUMBER := OKC_API.G_MISS_NUM

Line 29: ,link_cle_id NUMBER := OKC_API.G_MISS_NUM

25: ,last_update_date OKS_K_ORDER_DETAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,link_ord_line_id1 OKS_K_ORDER_DETAILS_V.LINK_ORD_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
27: ,link_ord_line_id2 OKS_K_ORDER_DETAILS_V.LINK_ORD_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
28: ,link_chr_id NUMBER := OKC_API.G_MISS_NUM
29: ,link_cle_id NUMBER := OKC_API.G_MISS_NUM
30: ,price_list_id1 OKS_K_ORDER_DETAILS_V.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR
31: ,price_list_id2 OKS_K_ORDER_DETAILS_V.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR
32: ,chr_id NUMBER := OKC_API.G_MISS_NUM
33: ,cle_id NUMBER := OKC_API.G_MISS_NUM

Line 30: ,price_list_id1 OKS_K_ORDER_DETAILS_V.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR

26: ,link_ord_line_id1 OKS_K_ORDER_DETAILS_V.LINK_ORD_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
27: ,link_ord_line_id2 OKS_K_ORDER_DETAILS_V.LINK_ORD_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
28: ,link_chr_id NUMBER := OKC_API.G_MISS_NUM
29: ,link_cle_id NUMBER := OKC_API.G_MISS_NUM
30: ,price_list_id1 OKS_K_ORDER_DETAILS_V.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR
31: ,price_list_id2 OKS_K_ORDER_DETAILS_V.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR
32: ,chr_id NUMBER := OKC_API.G_MISS_NUM
33: ,cle_id NUMBER := OKC_API.G_MISS_NUM
34: ,contact_id NUMBER := OKC_API.G_MISS_NUM

Line 31: ,price_list_id2 OKS_K_ORDER_DETAILS_V.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR

27: ,link_ord_line_id2 OKS_K_ORDER_DETAILS_V.LINK_ORD_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
28: ,link_chr_id NUMBER := OKC_API.G_MISS_NUM
29: ,link_cle_id NUMBER := OKC_API.G_MISS_NUM
30: ,price_list_id1 OKS_K_ORDER_DETAILS_V.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR
31: ,price_list_id2 OKS_K_ORDER_DETAILS_V.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR
32: ,chr_id NUMBER := OKC_API.G_MISS_NUM
33: ,cle_id NUMBER := OKC_API.G_MISS_NUM
34: ,contact_id NUMBER := OKC_API.G_MISS_NUM
35: ,site_id NUMBER := OKC_API.G_MISS_NUM

Line 32: ,chr_id NUMBER := OKC_API.G_MISS_NUM

28: ,link_chr_id NUMBER := OKC_API.G_MISS_NUM
29: ,link_cle_id NUMBER := OKC_API.G_MISS_NUM
30: ,price_list_id1 OKS_K_ORDER_DETAILS_V.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR
31: ,price_list_id2 OKS_K_ORDER_DETAILS_V.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR
32: ,chr_id NUMBER := OKC_API.G_MISS_NUM
33: ,cle_id NUMBER := OKC_API.G_MISS_NUM
34: ,contact_id NUMBER := OKC_API.G_MISS_NUM
35: ,site_id NUMBER := OKC_API.G_MISS_NUM
36: ,email_id NUMBER := OKC_API.G_MISS_NUM

Line 33: ,cle_id NUMBER := OKC_API.G_MISS_NUM

29: ,link_cle_id NUMBER := OKC_API.G_MISS_NUM
30: ,price_list_id1 OKS_K_ORDER_DETAILS_V.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR
31: ,price_list_id2 OKS_K_ORDER_DETAILS_V.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR
32: ,chr_id NUMBER := OKC_API.G_MISS_NUM
33: ,cle_id NUMBER := OKC_API.G_MISS_NUM
34: ,contact_id NUMBER := OKC_API.G_MISS_NUM
35: ,site_id NUMBER := OKC_API.G_MISS_NUM
36: ,email_id NUMBER := OKC_API.G_MISS_NUM
37: ,phone_id NUMBER := OKC_API.G_MISS_NUM

Line 34: ,contact_id NUMBER := OKC_API.G_MISS_NUM

30: ,price_list_id1 OKS_K_ORDER_DETAILS_V.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR
31: ,price_list_id2 OKS_K_ORDER_DETAILS_V.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR
32: ,chr_id NUMBER := OKC_API.G_MISS_NUM
33: ,cle_id NUMBER := OKC_API.G_MISS_NUM
34: ,contact_id NUMBER := OKC_API.G_MISS_NUM
35: ,site_id NUMBER := OKC_API.G_MISS_NUM
36: ,email_id NUMBER := OKC_API.G_MISS_NUM
37: ,phone_id NUMBER := OKC_API.G_MISS_NUM
38: ,fax_id NUMBER := OKC_API.G_MISS_NUM

Line 35: ,site_id NUMBER := OKC_API.G_MISS_NUM

31: ,price_list_id2 OKS_K_ORDER_DETAILS_V.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR
32: ,chr_id NUMBER := OKC_API.G_MISS_NUM
33: ,cle_id NUMBER := OKC_API.G_MISS_NUM
34: ,contact_id NUMBER := OKC_API.G_MISS_NUM
35: ,site_id NUMBER := OKC_API.G_MISS_NUM
36: ,email_id NUMBER := OKC_API.G_MISS_NUM
37: ,phone_id NUMBER := OKC_API.G_MISS_NUM
38: ,fax_id NUMBER := OKC_API.G_MISS_NUM
39: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM

Line 36: ,email_id NUMBER := OKC_API.G_MISS_NUM

32: ,chr_id NUMBER := OKC_API.G_MISS_NUM
33: ,cle_id NUMBER := OKC_API.G_MISS_NUM
34: ,contact_id NUMBER := OKC_API.G_MISS_NUM
35: ,site_id NUMBER := OKC_API.G_MISS_NUM
36: ,email_id NUMBER := OKC_API.G_MISS_NUM
37: ,phone_id NUMBER := OKC_API.G_MISS_NUM
38: ,fax_id NUMBER := OKC_API.G_MISS_NUM
39: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
40: ,RENEWAL_APPROVAL_FLAG OKS_K_ORDER_DETAILS_V.RENEWAL_APPROVAL_FLAG%TYPE := OKC_API.G_MISS_CHAR);

Line 37: ,phone_id NUMBER := OKC_API.G_MISS_NUM

33: ,cle_id NUMBER := OKC_API.G_MISS_NUM
34: ,contact_id NUMBER := OKC_API.G_MISS_NUM
35: ,site_id NUMBER := OKC_API.G_MISS_NUM
36: ,email_id NUMBER := OKC_API.G_MISS_NUM
37: ,phone_id NUMBER := OKC_API.G_MISS_NUM
38: ,fax_id NUMBER := OKC_API.G_MISS_NUM
39: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
40: ,RENEWAL_APPROVAL_FLAG OKS_K_ORDER_DETAILS_V.RENEWAL_APPROVAL_FLAG%TYPE := OKC_API.G_MISS_CHAR);
41:

Line 38: ,fax_id NUMBER := OKC_API.G_MISS_NUM

34: ,contact_id NUMBER := OKC_API.G_MISS_NUM
35: ,site_id NUMBER := OKC_API.G_MISS_NUM
36: ,email_id NUMBER := OKC_API.G_MISS_NUM
37: ,phone_id NUMBER := OKC_API.G_MISS_NUM
38: ,fax_id NUMBER := OKC_API.G_MISS_NUM
39: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
40: ,RENEWAL_APPROVAL_FLAG OKS_K_ORDER_DETAILS_V.RENEWAL_APPROVAL_FLAG%TYPE := OKC_API.G_MISS_CHAR);
41:
42: G_MISS_codv_rec codv_rec_type;

Line 39: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM

35: ,site_id NUMBER := OKC_API.G_MISS_NUM
36: ,email_id NUMBER := OKC_API.G_MISS_NUM
37: ,phone_id NUMBER := OKC_API.G_MISS_NUM
38: ,fax_id NUMBER := OKC_API.G_MISS_NUM
39: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
40: ,RENEWAL_APPROVAL_FLAG OKS_K_ORDER_DETAILS_V.RENEWAL_APPROVAL_FLAG%TYPE := OKC_API.G_MISS_CHAR);
41:
42: G_MISS_codv_rec codv_rec_type;
43:

Line 40: ,RENEWAL_APPROVAL_FLAG OKS_K_ORDER_DETAILS_V.RENEWAL_APPROVAL_FLAG%TYPE := OKC_API.G_MISS_CHAR);

36: ,email_id NUMBER := OKC_API.G_MISS_NUM
37: ,phone_id NUMBER := OKC_API.G_MISS_NUM
38: ,fax_id NUMBER := OKC_API.G_MISS_NUM
39: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
40: ,RENEWAL_APPROVAL_FLAG OKS_K_ORDER_DETAILS_V.RENEWAL_APPROVAL_FLAG%TYPE := OKC_API.G_MISS_CHAR);
41:
42: G_MISS_codv_rec codv_rec_type;
43:
44: TYPE codv_tbl_type IS TABLE OF codv_rec_type

Line 48: id NUMBER := OKC_API.G_MISS_NUM

44: TYPE codv_tbl_type IS TABLE OF codv_rec_type
45: INDEX BY BINARY_INTEGER;
46: -- OKS_K_ORDER_DETAILS Record Spec
47: TYPE cod_rec_type IS RECORD (
48: id NUMBER := OKC_API.G_MISS_NUM
49: ,cod_type OKS_K_ORDER_DETAILS.COD_TYPE%TYPE := OKC_API.G_MISS_CHAR
50: ,link_order_header_id NUMBER := OKC_API.G_MISS_NUM
51: ,order_line_id1 OKS_K_ORDER_DETAILS.ORDER_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
52: ,order_line_id2 OKS_K_ORDER_DETAILS.ORDER_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR

Line 49: ,cod_type OKS_K_ORDER_DETAILS.COD_TYPE%TYPE := OKC_API.G_MISS_CHAR

45: INDEX BY BINARY_INTEGER;
46: -- OKS_K_ORDER_DETAILS Record Spec
47: TYPE cod_rec_type IS RECORD (
48: id NUMBER := OKC_API.G_MISS_NUM
49: ,cod_type OKS_K_ORDER_DETAILS.COD_TYPE%TYPE := OKC_API.G_MISS_CHAR
50: ,link_order_header_id NUMBER := OKC_API.G_MISS_NUM
51: ,order_line_id1 OKS_K_ORDER_DETAILS.ORDER_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
52: ,order_line_id2 OKS_K_ORDER_DETAILS.ORDER_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
53: ,apply_all_yn OKS_K_ORDER_DETAILS.APPLY_ALL_YN%TYPE := OKC_API.G_MISS_CHAR

Line 50: ,link_order_header_id NUMBER := OKC_API.G_MISS_NUM

46: -- OKS_K_ORDER_DETAILS Record Spec
47: TYPE cod_rec_type IS RECORD (
48: id NUMBER := OKC_API.G_MISS_NUM
49: ,cod_type OKS_K_ORDER_DETAILS.COD_TYPE%TYPE := OKC_API.G_MISS_CHAR
50: ,link_order_header_id NUMBER := OKC_API.G_MISS_NUM
51: ,order_line_id1 OKS_K_ORDER_DETAILS.ORDER_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
52: ,order_line_id2 OKS_K_ORDER_DETAILS.ORDER_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
53: ,apply_all_yn OKS_K_ORDER_DETAILS.APPLY_ALL_YN%TYPE := OKC_API.G_MISS_CHAR
54: ,renewal_type OKS_K_ORDER_DETAILS.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 51: ,order_line_id1 OKS_K_ORDER_DETAILS.ORDER_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR

47: TYPE cod_rec_type IS RECORD (
48: id NUMBER := OKC_API.G_MISS_NUM
49: ,cod_type OKS_K_ORDER_DETAILS.COD_TYPE%TYPE := OKC_API.G_MISS_CHAR
50: ,link_order_header_id NUMBER := OKC_API.G_MISS_NUM
51: ,order_line_id1 OKS_K_ORDER_DETAILS.ORDER_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
52: ,order_line_id2 OKS_K_ORDER_DETAILS.ORDER_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
53: ,apply_all_yn OKS_K_ORDER_DETAILS.APPLY_ALL_YN%TYPE := OKC_API.G_MISS_CHAR
54: ,renewal_type OKS_K_ORDER_DETAILS.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
55: ,line_renewal_type OKS_K_ORDER_DETAILS.LINE_RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 52: ,order_line_id2 OKS_K_ORDER_DETAILS.ORDER_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR

48: id NUMBER := OKC_API.G_MISS_NUM
49: ,cod_type OKS_K_ORDER_DETAILS.COD_TYPE%TYPE := OKC_API.G_MISS_CHAR
50: ,link_order_header_id NUMBER := OKC_API.G_MISS_NUM
51: ,order_line_id1 OKS_K_ORDER_DETAILS.ORDER_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
52: ,order_line_id2 OKS_K_ORDER_DETAILS.ORDER_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
53: ,apply_all_yn OKS_K_ORDER_DETAILS.APPLY_ALL_YN%TYPE := OKC_API.G_MISS_CHAR
54: ,renewal_type OKS_K_ORDER_DETAILS.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
55: ,line_renewal_type OKS_K_ORDER_DETAILS.LINE_RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
56: ,end_date OKS_K_ORDER_DETAILS.END_DATE%TYPE := OKC_API.G_MISS_DATE

Line 53: ,apply_all_yn OKS_K_ORDER_DETAILS.APPLY_ALL_YN%TYPE := OKC_API.G_MISS_CHAR

49: ,cod_type OKS_K_ORDER_DETAILS.COD_TYPE%TYPE := OKC_API.G_MISS_CHAR
50: ,link_order_header_id NUMBER := OKC_API.G_MISS_NUM
51: ,order_line_id1 OKS_K_ORDER_DETAILS.ORDER_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
52: ,order_line_id2 OKS_K_ORDER_DETAILS.ORDER_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
53: ,apply_all_yn OKS_K_ORDER_DETAILS.APPLY_ALL_YN%TYPE := OKC_API.G_MISS_CHAR
54: ,renewal_type OKS_K_ORDER_DETAILS.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
55: ,line_renewal_type OKS_K_ORDER_DETAILS.LINE_RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
56: ,end_date OKS_K_ORDER_DETAILS.END_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 54: ,renewal_type OKS_K_ORDER_DETAILS.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR

50: ,link_order_header_id NUMBER := OKC_API.G_MISS_NUM
51: ,order_line_id1 OKS_K_ORDER_DETAILS.ORDER_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
52: ,order_line_id2 OKS_K_ORDER_DETAILS.ORDER_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
53: ,apply_all_yn OKS_K_ORDER_DETAILS.APPLY_ALL_YN%TYPE := OKC_API.G_MISS_CHAR
54: ,renewal_type OKS_K_ORDER_DETAILS.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
55: ,line_renewal_type OKS_K_ORDER_DETAILS.LINE_RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
56: ,end_date OKS_K_ORDER_DETAILS.END_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
58: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 55: ,line_renewal_type OKS_K_ORDER_DETAILS.LINE_RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR

51: ,order_line_id1 OKS_K_ORDER_DETAILS.ORDER_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
52: ,order_line_id2 OKS_K_ORDER_DETAILS.ORDER_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
53: ,apply_all_yn OKS_K_ORDER_DETAILS.APPLY_ALL_YN%TYPE := OKC_API.G_MISS_CHAR
54: ,renewal_type OKS_K_ORDER_DETAILS.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
55: ,line_renewal_type OKS_K_ORDER_DETAILS.LINE_RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
56: ,end_date OKS_K_ORDER_DETAILS.END_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
58: ,created_by NUMBER := OKC_API.G_MISS_NUM
59: ,creation_date OKS_K_ORDER_DETAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 56: ,end_date OKS_K_ORDER_DETAILS.END_DATE%TYPE := OKC_API.G_MISS_DATE

52: ,order_line_id2 OKS_K_ORDER_DETAILS.ORDER_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
53: ,apply_all_yn OKS_K_ORDER_DETAILS.APPLY_ALL_YN%TYPE := OKC_API.G_MISS_CHAR
54: ,renewal_type OKS_K_ORDER_DETAILS.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
55: ,line_renewal_type OKS_K_ORDER_DETAILS.LINE_RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
56: ,end_date OKS_K_ORDER_DETAILS.END_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
58: ,created_by NUMBER := OKC_API.G_MISS_NUM
59: ,creation_date OKS_K_ORDER_DETAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

53: ,apply_all_yn OKS_K_ORDER_DETAILS.APPLY_ALL_YN%TYPE := OKC_API.G_MISS_CHAR
54: ,renewal_type OKS_K_ORDER_DETAILS.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
55: ,line_renewal_type OKS_K_ORDER_DETAILS.LINE_RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
56: ,end_date OKS_K_ORDER_DETAILS.END_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
58: ,created_by NUMBER := OKC_API.G_MISS_NUM
59: ,creation_date OKS_K_ORDER_DETAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
61: ,last_update_date OKS_K_ORDER_DETAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 58: ,created_by NUMBER := OKC_API.G_MISS_NUM

54: ,renewal_type OKS_K_ORDER_DETAILS.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
55: ,line_renewal_type OKS_K_ORDER_DETAILS.LINE_RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
56: ,end_date OKS_K_ORDER_DETAILS.END_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
58: ,created_by NUMBER := OKC_API.G_MISS_NUM
59: ,creation_date OKS_K_ORDER_DETAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
61: ,last_update_date OKS_K_ORDER_DETAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
62: ,po_required_yn OKS_K_ORDER_DETAILS.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR

Line 59: ,creation_date OKS_K_ORDER_DETAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

55: ,line_renewal_type OKS_K_ORDER_DETAILS.LINE_RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
56: ,end_date OKS_K_ORDER_DETAILS.END_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
58: ,created_by NUMBER := OKC_API.G_MISS_NUM
59: ,creation_date OKS_K_ORDER_DETAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
61: ,last_update_date OKS_K_ORDER_DETAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
62: ,po_required_yn OKS_K_ORDER_DETAILS.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR
63: ,renewal_pricing_type OKS_K_ORDER_DETAILS.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 60: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

56: ,end_date OKS_K_ORDER_DETAILS.END_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
58: ,created_by NUMBER := OKC_API.G_MISS_NUM
59: ,creation_date OKS_K_ORDER_DETAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
61: ,last_update_date OKS_K_ORDER_DETAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
62: ,po_required_yn OKS_K_ORDER_DETAILS.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR
63: ,renewal_pricing_type OKS_K_ORDER_DETAILS.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
64: ,markup_percent NUMBER := OKC_API.G_MISS_NUM

Line 61: ,last_update_date OKS_K_ORDER_DETAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
58: ,created_by NUMBER := OKC_API.G_MISS_NUM
59: ,creation_date OKS_K_ORDER_DETAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
61: ,last_update_date OKS_K_ORDER_DETAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
62: ,po_required_yn OKS_K_ORDER_DETAILS.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR
63: ,renewal_pricing_type OKS_K_ORDER_DETAILS.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
64: ,markup_percent NUMBER := OKC_API.G_MISS_NUM
65: ,price_list_id1 OKS_K_ORDER_DETAILS.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR

Line 62: ,po_required_yn OKS_K_ORDER_DETAILS.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR

58: ,created_by NUMBER := OKC_API.G_MISS_NUM
59: ,creation_date OKS_K_ORDER_DETAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
61: ,last_update_date OKS_K_ORDER_DETAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
62: ,po_required_yn OKS_K_ORDER_DETAILS.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR
63: ,renewal_pricing_type OKS_K_ORDER_DETAILS.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
64: ,markup_percent NUMBER := OKC_API.G_MISS_NUM
65: ,price_list_id1 OKS_K_ORDER_DETAILS.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR
66: ,price_list_id2 OKS_K_ORDER_DETAILS.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR

Line 63: ,renewal_pricing_type OKS_K_ORDER_DETAILS.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR

59: ,creation_date OKS_K_ORDER_DETAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
61: ,last_update_date OKS_K_ORDER_DETAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
62: ,po_required_yn OKS_K_ORDER_DETAILS.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR
63: ,renewal_pricing_type OKS_K_ORDER_DETAILS.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
64: ,markup_percent NUMBER := OKC_API.G_MISS_NUM
65: ,price_list_id1 OKS_K_ORDER_DETAILS.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR
66: ,price_list_id2 OKS_K_ORDER_DETAILS.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR
67: ,link_ord_line_id1 OKS_K_ORDER_DETAILS.LINK_ORD_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR

Line 64: ,markup_percent NUMBER := OKC_API.G_MISS_NUM

60: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
61: ,last_update_date OKS_K_ORDER_DETAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
62: ,po_required_yn OKS_K_ORDER_DETAILS.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR
63: ,renewal_pricing_type OKS_K_ORDER_DETAILS.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
64: ,markup_percent NUMBER := OKC_API.G_MISS_NUM
65: ,price_list_id1 OKS_K_ORDER_DETAILS.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR
66: ,price_list_id2 OKS_K_ORDER_DETAILS.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR
67: ,link_ord_line_id1 OKS_K_ORDER_DETAILS.LINK_ORD_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
68: ,link_ord_line_id2 OKS_K_ORDER_DETAILS.LINK_ORD_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR

Line 65: ,price_list_id1 OKS_K_ORDER_DETAILS.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR

61: ,last_update_date OKS_K_ORDER_DETAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
62: ,po_required_yn OKS_K_ORDER_DETAILS.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR
63: ,renewal_pricing_type OKS_K_ORDER_DETAILS.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
64: ,markup_percent NUMBER := OKC_API.G_MISS_NUM
65: ,price_list_id1 OKS_K_ORDER_DETAILS.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR
66: ,price_list_id2 OKS_K_ORDER_DETAILS.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR
67: ,link_ord_line_id1 OKS_K_ORDER_DETAILS.LINK_ORD_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
68: ,link_ord_line_id2 OKS_K_ORDER_DETAILS.LINK_ORD_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
69: ,link_chr_id NUMBER := OKC_API.G_MISS_NUM

Line 66: ,price_list_id2 OKS_K_ORDER_DETAILS.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR

62: ,po_required_yn OKS_K_ORDER_DETAILS.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR
63: ,renewal_pricing_type OKS_K_ORDER_DETAILS.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
64: ,markup_percent NUMBER := OKC_API.G_MISS_NUM
65: ,price_list_id1 OKS_K_ORDER_DETAILS.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR
66: ,price_list_id2 OKS_K_ORDER_DETAILS.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR
67: ,link_ord_line_id1 OKS_K_ORDER_DETAILS.LINK_ORD_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
68: ,link_ord_line_id2 OKS_K_ORDER_DETAILS.LINK_ORD_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
69: ,link_chr_id NUMBER := OKC_API.G_MISS_NUM
70: ,link_cle_id NUMBER := OKC_API.G_MISS_NUM

Line 67: ,link_ord_line_id1 OKS_K_ORDER_DETAILS.LINK_ORD_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR

63: ,renewal_pricing_type OKS_K_ORDER_DETAILS.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
64: ,markup_percent NUMBER := OKC_API.G_MISS_NUM
65: ,price_list_id1 OKS_K_ORDER_DETAILS.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR
66: ,price_list_id2 OKS_K_ORDER_DETAILS.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR
67: ,link_ord_line_id1 OKS_K_ORDER_DETAILS.LINK_ORD_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
68: ,link_ord_line_id2 OKS_K_ORDER_DETAILS.LINK_ORD_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
69: ,link_chr_id NUMBER := OKC_API.G_MISS_NUM
70: ,link_cle_id NUMBER := OKC_API.G_MISS_NUM
71: ,chr_id NUMBER := OKC_API.G_MISS_NUM

Line 68: ,link_ord_line_id2 OKS_K_ORDER_DETAILS.LINK_ORD_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR

64: ,markup_percent NUMBER := OKC_API.G_MISS_NUM
65: ,price_list_id1 OKS_K_ORDER_DETAILS.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR
66: ,price_list_id2 OKS_K_ORDER_DETAILS.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR
67: ,link_ord_line_id1 OKS_K_ORDER_DETAILS.LINK_ORD_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
68: ,link_ord_line_id2 OKS_K_ORDER_DETAILS.LINK_ORD_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
69: ,link_chr_id NUMBER := OKC_API.G_MISS_NUM
70: ,link_cle_id NUMBER := OKC_API.G_MISS_NUM
71: ,chr_id NUMBER := OKC_API.G_MISS_NUM
72: ,cle_id NUMBER := OKC_API.G_MISS_NUM

Line 69: ,link_chr_id NUMBER := OKC_API.G_MISS_NUM

65: ,price_list_id1 OKS_K_ORDER_DETAILS.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR
66: ,price_list_id2 OKS_K_ORDER_DETAILS.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR
67: ,link_ord_line_id1 OKS_K_ORDER_DETAILS.LINK_ORD_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
68: ,link_ord_line_id2 OKS_K_ORDER_DETAILS.LINK_ORD_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
69: ,link_chr_id NUMBER := OKC_API.G_MISS_NUM
70: ,link_cle_id NUMBER := OKC_API.G_MISS_NUM
71: ,chr_id NUMBER := OKC_API.G_MISS_NUM
72: ,cle_id NUMBER := OKC_API.G_MISS_NUM
73: ,cod_id NUMBER := OKC_API.G_MISS_NUM

Line 70: ,link_cle_id NUMBER := OKC_API.G_MISS_NUM

66: ,price_list_id2 OKS_K_ORDER_DETAILS.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR
67: ,link_ord_line_id1 OKS_K_ORDER_DETAILS.LINK_ORD_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
68: ,link_ord_line_id2 OKS_K_ORDER_DETAILS.LINK_ORD_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
69: ,link_chr_id NUMBER := OKC_API.G_MISS_NUM
70: ,link_cle_id NUMBER := OKC_API.G_MISS_NUM
71: ,chr_id NUMBER := OKC_API.G_MISS_NUM
72: ,cle_id NUMBER := OKC_API.G_MISS_NUM
73: ,cod_id NUMBER := OKC_API.G_MISS_NUM
74: ,contact_id NUMBER := OKC_API.G_MISS_NUM

Line 71: ,chr_id NUMBER := OKC_API.G_MISS_NUM

67: ,link_ord_line_id1 OKS_K_ORDER_DETAILS.LINK_ORD_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
68: ,link_ord_line_id2 OKS_K_ORDER_DETAILS.LINK_ORD_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
69: ,link_chr_id NUMBER := OKC_API.G_MISS_NUM
70: ,link_cle_id NUMBER := OKC_API.G_MISS_NUM
71: ,chr_id NUMBER := OKC_API.G_MISS_NUM
72: ,cle_id NUMBER := OKC_API.G_MISS_NUM
73: ,cod_id NUMBER := OKC_API.G_MISS_NUM
74: ,contact_id NUMBER := OKC_API.G_MISS_NUM
75: ,site_id NUMBER := OKC_API.G_MISS_NUM

Line 72: ,cle_id NUMBER := OKC_API.G_MISS_NUM

68: ,link_ord_line_id2 OKS_K_ORDER_DETAILS.LINK_ORD_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
69: ,link_chr_id NUMBER := OKC_API.G_MISS_NUM
70: ,link_cle_id NUMBER := OKC_API.G_MISS_NUM
71: ,chr_id NUMBER := OKC_API.G_MISS_NUM
72: ,cle_id NUMBER := OKC_API.G_MISS_NUM
73: ,cod_id NUMBER := OKC_API.G_MISS_NUM
74: ,contact_id NUMBER := OKC_API.G_MISS_NUM
75: ,site_id NUMBER := OKC_API.G_MISS_NUM
76: ,email_id NUMBER := OKC_API.G_MISS_NUM

Line 73: ,cod_id NUMBER := OKC_API.G_MISS_NUM

69: ,link_chr_id NUMBER := OKC_API.G_MISS_NUM
70: ,link_cle_id NUMBER := OKC_API.G_MISS_NUM
71: ,chr_id NUMBER := OKC_API.G_MISS_NUM
72: ,cle_id NUMBER := OKC_API.G_MISS_NUM
73: ,cod_id NUMBER := OKC_API.G_MISS_NUM
74: ,contact_id NUMBER := OKC_API.G_MISS_NUM
75: ,site_id NUMBER := OKC_API.G_MISS_NUM
76: ,email_id NUMBER := OKC_API.G_MISS_NUM
77: ,phone_id NUMBER := OKC_API.G_MISS_NUM

Line 74: ,contact_id NUMBER := OKC_API.G_MISS_NUM

70: ,link_cle_id NUMBER := OKC_API.G_MISS_NUM
71: ,chr_id NUMBER := OKC_API.G_MISS_NUM
72: ,cle_id NUMBER := OKC_API.G_MISS_NUM
73: ,cod_id NUMBER := OKC_API.G_MISS_NUM
74: ,contact_id NUMBER := OKC_API.G_MISS_NUM
75: ,site_id NUMBER := OKC_API.G_MISS_NUM
76: ,email_id NUMBER := OKC_API.G_MISS_NUM
77: ,phone_id NUMBER := OKC_API.G_MISS_NUM
78: ,fax_id NUMBER := OKC_API.G_MISS_NUM

Line 75: ,site_id NUMBER := OKC_API.G_MISS_NUM

71: ,chr_id NUMBER := OKC_API.G_MISS_NUM
72: ,cle_id NUMBER := OKC_API.G_MISS_NUM
73: ,cod_id NUMBER := OKC_API.G_MISS_NUM
74: ,contact_id NUMBER := OKC_API.G_MISS_NUM
75: ,site_id NUMBER := OKC_API.G_MISS_NUM
76: ,email_id NUMBER := OKC_API.G_MISS_NUM
77: ,phone_id NUMBER := OKC_API.G_MISS_NUM
78: ,fax_id NUMBER := OKC_API.G_MISS_NUM
79: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM

Line 76: ,email_id NUMBER := OKC_API.G_MISS_NUM

72: ,cle_id NUMBER := OKC_API.G_MISS_NUM
73: ,cod_id NUMBER := OKC_API.G_MISS_NUM
74: ,contact_id NUMBER := OKC_API.G_MISS_NUM
75: ,site_id NUMBER := OKC_API.G_MISS_NUM
76: ,email_id NUMBER := OKC_API.G_MISS_NUM
77: ,phone_id NUMBER := OKC_API.G_MISS_NUM
78: ,fax_id NUMBER := OKC_API.G_MISS_NUM
79: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
80: ,RENEWAL_APPROVAL_FLAG OKS_K_ORDER_DETAILS_V.RENEWAL_APPROVAL_FLAG%TYPE := OKC_API.G_MISS_CHAR);

Line 77: ,phone_id NUMBER := OKC_API.G_MISS_NUM

73: ,cod_id NUMBER := OKC_API.G_MISS_NUM
74: ,contact_id NUMBER := OKC_API.G_MISS_NUM
75: ,site_id NUMBER := OKC_API.G_MISS_NUM
76: ,email_id NUMBER := OKC_API.G_MISS_NUM
77: ,phone_id NUMBER := OKC_API.G_MISS_NUM
78: ,fax_id NUMBER := OKC_API.G_MISS_NUM
79: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
80: ,RENEWAL_APPROVAL_FLAG OKS_K_ORDER_DETAILS_V.RENEWAL_APPROVAL_FLAG%TYPE := OKC_API.G_MISS_CHAR);
81:

Line 78: ,fax_id NUMBER := OKC_API.G_MISS_NUM

74: ,contact_id NUMBER := OKC_API.G_MISS_NUM
75: ,site_id NUMBER := OKC_API.G_MISS_NUM
76: ,email_id NUMBER := OKC_API.G_MISS_NUM
77: ,phone_id NUMBER := OKC_API.G_MISS_NUM
78: ,fax_id NUMBER := OKC_API.G_MISS_NUM
79: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
80: ,RENEWAL_APPROVAL_FLAG OKS_K_ORDER_DETAILS_V.RENEWAL_APPROVAL_FLAG%TYPE := OKC_API.G_MISS_CHAR);
81:
82: G_MISS_cod_rec cod_rec_type;

Line 79: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM

75: ,site_id NUMBER := OKC_API.G_MISS_NUM
76: ,email_id NUMBER := OKC_API.G_MISS_NUM
77: ,phone_id NUMBER := OKC_API.G_MISS_NUM
78: ,fax_id NUMBER := OKC_API.G_MISS_NUM
79: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
80: ,RENEWAL_APPROVAL_FLAG OKS_K_ORDER_DETAILS_V.RENEWAL_APPROVAL_FLAG%TYPE := OKC_API.G_MISS_CHAR);
81:
82: G_MISS_cod_rec cod_rec_type;
83: TYPE cod_tbl_type IS TABLE OF cod_rec_type

Line 80: ,RENEWAL_APPROVAL_FLAG OKS_K_ORDER_DETAILS_V.RENEWAL_APPROVAL_FLAG%TYPE := OKC_API.G_MISS_CHAR);

76: ,email_id NUMBER := OKC_API.G_MISS_NUM
77: ,phone_id NUMBER := OKC_API.G_MISS_NUM
78: ,fax_id NUMBER := OKC_API.G_MISS_NUM
79: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
80: ,RENEWAL_APPROVAL_FLAG OKS_K_ORDER_DETAILS_V.RENEWAL_APPROVAL_FLAG%TYPE := OKC_API.G_MISS_CHAR);
81:
82: G_MISS_cod_rec cod_rec_type;
83: TYPE cod_tbl_type IS TABLE OF cod_rec_type
84: INDEX BY BINARY_INTEGER;

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

84: INDEX BY BINARY_INTEGER;
85: ---------------------------------------------------------------------------
86: -- GLOBAL MESSAGE CONSTANTS
87: ---------------------------------------------------------------------------
88: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
89: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
90: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
91: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
92: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

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

85: ---------------------------------------------------------------------------
86: -- GLOBAL MESSAGE CONSTANTS
87: ---------------------------------------------------------------------------
88: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
89: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
90: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
91: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
92: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
93: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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

86: -- GLOBAL MESSAGE CONSTANTS
87: ---------------------------------------------------------------------------
88: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
89: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
90: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
91: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
92: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
93: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
94: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

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

87: ---------------------------------------------------------------------------
88: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
89: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
90: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
91: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
92: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
93: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
94: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
95: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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

88: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
89: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
90: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
91: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
92: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
93: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
94: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
95: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
96: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

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

89: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
90: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
91: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
92: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
93: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
94: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
95: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
96: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
97: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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

90: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
91: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
92: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
93: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
94: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
95: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
96: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
97: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
98: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

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

91: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
92: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
93: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
94: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
95: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
96: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
97: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
98: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
99: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

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

92: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
93: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
94: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
95: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
96: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
97: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
98: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
99: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
100: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

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

93: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
94: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
95: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
96: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
97: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
98: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
99: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
100: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
101:

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

107: ---------------------------------------------------------------------------
108: -- GLOBAL VARIABLES
109: ---------------------------------------------------------------------------
110: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_COD_PVT';
111: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
112: ---------------------------------------------------------------------------
113: -- Procedures and Functions
114: ---------------------------------------------------------------------------
115:

Line 121: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

117: PROCEDURE change_version;
118: PROCEDURE api_copy;
119: PROCEDURE insert_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_codv_rec IN codv_rec_type,

Line 129: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

125: p_codv_rec IN codv_rec_type,
126: x_codv_rec OUT NOCOPY codv_rec_type);
127: PROCEDURE insert_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_codv_tbl IN codv_tbl_type,

Line 135: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_codv_tbl IN codv_tbl_type,
134: x_codv_tbl OUT NOCOPY codv_tbl_type,
135: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
136: PROCEDURE insert_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,

Line 138: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

134: x_codv_tbl OUT NOCOPY codv_tbl_type,
135: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
136: PROCEDURE insert_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_codv_tbl IN codv_tbl_type,

Line 146: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

142: p_codv_tbl IN codv_tbl_type,
143: x_codv_tbl OUT NOCOPY codv_tbl_type);
144: PROCEDURE lock_row(
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,
150: p_codv_rec IN codv_rec_type);

Line 153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

149: x_msg_data OUT NOCOPY VARCHAR2,
150: p_codv_rec IN codv_rec_type);
151: PROCEDURE lock_row(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_codv_tbl IN codv_tbl_type,

Line 158: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_codv_tbl IN codv_tbl_type,
158: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
159: PROCEDURE lock_row(
160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
162: x_return_status OUT NOCOPY VARCHAR2,

Line 161: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

157: p_codv_tbl IN codv_tbl_type,
158: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
159: PROCEDURE lock_row(
160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_codv_tbl IN codv_tbl_type);

Line 168: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_codv_tbl IN codv_tbl_type);
166: PROCEDURE update_row(
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_codv_rec IN codv_rec_type,

Line 176: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

172: p_codv_rec IN codv_rec_type,
173: x_codv_rec OUT NOCOPY codv_rec_type);
174: PROCEDURE update_row(
175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: p_codv_tbl IN codv_tbl_type,

Line 182: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: p_codv_tbl IN codv_tbl_type,
181: x_codv_tbl OUT NOCOPY codv_tbl_type,
182: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
183: PROCEDURE update_row(
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
186: x_return_status OUT NOCOPY VARCHAR2,

Line 185: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

181: x_codv_tbl OUT NOCOPY codv_tbl_type,
182: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
183: PROCEDURE update_row(
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_codv_tbl IN codv_tbl_type,

Line 193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

189: p_codv_tbl IN codv_tbl_type,
190: x_codv_tbl OUT NOCOPY codv_tbl_type);
191: PROCEDURE delete_row(
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_codv_rec IN codv_rec_type);

Line 200: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_codv_rec IN codv_rec_type);
198: PROCEDURE delete_row(
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,
203: x_msg_data OUT NOCOPY VARCHAR2,
204: p_codv_tbl IN codv_tbl_type,

Line 205: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,
203: x_msg_data OUT NOCOPY VARCHAR2,
204: p_codv_tbl IN codv_tbl_type,
205: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
206: PROCEDURE delete_row(
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
209: x_return_status OUT NOCOPY VARCHAR2,

Line 208: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

204: p_codv_tbl IN codv_tbl_type,
205: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
206: PROCEDURE delete_row(
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
212: p_codv_tbl IN codv_tbl_type);

Line 215: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

211: x_msg_data OUT NOCOPY VARCHAR2,
212: p_codv_tbl IN codv_tbl_type);
213: PROCEDURE validate_row(
214: p_api_version IN NUMBER,
215: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,
218: x_msg_data OUT NOCOPY VARCHAR2,
219: p_codv_rec IN codv_rec_type);

Line 222: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

218: x_msg_data OUT NOCOPY VARCHAR2,
219: p_codv_rec IN codv_rec_type);
220: PROCEDURE validate_row(
221: p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
223: x_return_status OUT NOCOPY VARCHAR2,
224: x_msg_count OUT NOCOPY NUMBER,
225: x_msg_data OUT NOCOPY VARCHAR2,
226: p_codv_tbl IN codv_tbl_type,

Line 227: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

223: x_return_status OUT NOCOPY VARCHAR2,
224: x_msg_count OUT NOCOPY NUMBER,
225: x_msg_data OUT NOCOPY VARCHAR2,
226: p_codv_tbl IN codv_tbl_type,
227: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
228: PROCEDURE validate_row(
229: p_api_version IN NUMBER,
230: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
231: x_return_status OUT NOCOPY VARCHAR2,

Line 230: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

226: p_codv_tbl IN codv_tbl_type,
227: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
228: PROCEDURE validate_row(
229: p_api_version IN NUMBER,
230: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
231: x_return_status OUT NOCOPY VARCHAR2,
232: x_msg_count OUT NOCOPY NUMBER,
233: x_msg_data OUT NOCOPY VARCHAR2,
234: p_codv_tbl IN codv_tbl_type);