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 OKS_K_ORDER_DETAILS

Line 6: -- OKS_K_ORDER_DETAILS_V Record Spec

2: /* $Header: OKSRCODS.pls 120.1 2006/05/26 22:29:23 jvarghes noship $ */
3: ---------------------------------------------------------------------------
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

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 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 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 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 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 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 46: -- OKS_K_ORDER_DETAILS Record Spec

42: G_MISS_codv_rec codv_rec_type;
43:
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

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 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 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 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 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 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;