4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_PRICE_BREAKS_V Record Spec
7: TYPE pbrv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,bsl_id NUMBER := OKC_API.G_MISS_NUM
10: ,bcl_id NUMBER := OKC_API.G_MISS_NUM
11: ,cle_id NUMBER := OKC_API.G_MISS_NUM
12: ,chr_id NUMBER := OKC_API.G_MISS_NUM
5: ---------------------------------------------------------------------------
6: -- OKS_PRICE_BREAKS_V Record Spec
7: TYPE pbrv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,bsl_id NUMBER := OKC_API.G_MISS_NUM
10: ,bcl_id NUMBER := OKC_API.G_MISS_NUM
11: ,cle_id NUMBER := OKC_API.G_MISS_NUM
12: ,chr_id NUMBER := OKC_API.G_MISS_NUM
13: ,line_detail_index NUMBER := OKC_API.G_MISS_NUM
6: -- OKS_PRICE_BREAKS_V Record Spec
7: TYPE pbrv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,bsl_id NUMBER := OKC_API.G_MISS_NUM
10: ,bcl_id NUMBER := OKC_API.G_MISS_NUM
11: ,cle_id NUMBER := OKC_API.G_MISS_NUM
12: ,chr_id NUMBER := OKC_API.G_MISS_NUM
13: ,line_detail_index NUMBER := OKC_API.G_MISS_NUM
14: ,line_index NUMBER := OKC_API.G_MISS_NUM
7: TYPE pbrv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,bsl_id NUMBER := OKC_API.G_MISS_NUM
10: ,bcl_id NUMBER := OKC_API.G_MISS_NUM
11: ,cle_id NUMBER := OKC_API.G_MISS_NUM
12: ,chr_id NUMBER := OKC_API.G_MISS_NUM
13: ,line_detail_index NUMBER := OKC_API.G_MISS_NUM
14: ,line_index NUMBER := OKC_API.G_MISS_NUM
15: ,pricing_context OKS_PRICE_BREAKS_V.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,bsl_id NUMBER := OKC_API.G_MISS_NUM
10: ,bcl_id NUMBER := OKC_API.G_MISS_NUM
11: ,cle_id NUMBER := OKC_API.G_MISS_NUM
12: ,chr_id NUMBER := OKC_API.G_MISS_NUM
13: ,line_detail_index NUMBER := OKC_API.G_MISS_NUM
14: ,line_index NUMBER := OKC_API.G_MISS_NUM
15: ,pricing_context OKS_PRICE_BREAKS_V.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR
16: ,pricing_method OKS_PRICE_BREAKS_V.PRICING_METHOD%TYPE := OKC_API.G_MISS_CHAR
9: ,bsl_id NUMBER := OKC_API.G_MISS_NUM
10: ,bcl_id NUMBER := OKC_API.G_MISS_NUM
11: ,cle_id NUMBER := OKC_API.G_MISS_NUM
12: ,chr_id NUMBER := OKC_API.G_MISS_NUM
13: ,line_detail_index NUMBER := OKC_API.G_MISS_NUM
14: ,line_index NUMBER := OKC_API.G_MISS_NUM
15: ,pricing_context OKS_PRICE_BREAKS_V.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR
16: ,pricing_method OKS_PRICE_BREAKS_V.PRICING_METHOD%TYPE := OKC_API.G_MISS_CHAR
17: ,quantity_from NUMBER := OKC_API.G_MISS_NUM
10: ,bcl_id NUMBER := OKC_API.G_MISS_NUM
11: ,cle_id NUMBER := OKC_API.G_MISS_NUM
12: ,chr_id NUMBER := OKC_API.G_MISS_NUM
13: ,line_detail_index NUMBER := OKC_API.G_MISS_NUM
14: ,line_index NUMBER := OKC_API.G_MISS_NUM
15: ,pricing_context OKS_PRICE_BREAKS_V.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR
16: ,pricing_method OKS_PRICE_BREAKS_V.PRICING_METHOD%TYPE := OKC_API.G_MISS_CHAR
17: ,quantity_from NUMBER := OKC_API.G_MISS_NUM
18: ,quantity_to NUMBER := OKC_API.G_MISS_NUM
11: ,cle_id NUMBER := OKC_API.G_MISS_NUM
12: ,chr_id NUMBER := OKC_API.G_MISS_NUM
13: ,line_detail_index NUMBER := OKC_API.G_MISS_NUM
14: ,line_index NUMBER := OKC_API.G_MISS_NUM
15: ,pricing_context OKS_PRICE_BREAKS_V.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR
16: ,pricing_method OKS_PRICE_BREAKS_V.PRICING_METHOD%TYPE := OKC_API.G_MISS_CHAR
17: ,quantity_from NUMBER := OKC_API.G_MISS_NUM
18: ,quantity_to NUMBER := OKC_API.G_MISS_NUM
19: ,quantity NUMBER := OKC_API.G_MISS_NUM
12: ,chr_id NUMBER := OKC_API.G_MISS_NUM
13: ,line_detail_index NUMBER := OKC_API.G_MISS_NUM
14: ,line_index NUMBER := OKC_API.G_MISS_NUM
15: ,pricing_context OKS_PRICE_BREAKS_V.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR
16: ,pricing_method OKS_PRICE_BREAKS_V.PRICING_METHOD%TYPE := OKC_API.G_MISS_CHAR
17: ,quantity_from NUMBER := OKC_API.G_MISS_NUM
18: ,quantity_to NUMBER := OKC_API.G_MISS_NUM
19: ,quantity NUMBER := OKC_API.G_MISS_NUM
20: ,break_uom OKS_PRICE_BREAKS_V.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
13: ,line_detail_index NUMBER := OKC_API.G_MISS_NUM
14: ,line_index NUMBER := OKC_API.G_MISS_NUM
15: ,pricing_context OKS_PRICE_BREAKS_V.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR
16: ,pricing_method OKS_PRICE_BREAKS_V.PRICING_METHOD%TYPE := OKC_API.G_MISS_CHAR
17: ,quantity_from NUMBER := OKC_API.G_MISS_NUM
18: ,quantity_to NUMBER := OKC_API.G_MISS_NUM
19: ,quantity NUMBER := OKC_API.G_MISS_NUM
20: ,break_uom OKS_PRICE_BREAKS_V.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
21: ,prorate OKS_PRICE_BREAKS_V.PRORATE%TYPE := OKC_API.G_MISS_CHAR
14: ,line_index NUMBER := OKC_API.G_MISS_NUM
15: ,pricing_context OKS_PRICE_BREAKS_V.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR
16: ,pricing_method OKS_PRICE_BREAKS_V.PRICING_METHOD%TYPE := OKC_API.G_MISS_CHAR
17: ,quantity_from NUMBER := OKC_API.G_MISS_NUM
18: ,quantity_to NUMBER := OKC_API.G_MISS_NUM
19: ,quantity NUMBER := OKC_API.G_MISS_NUM
20: ,break_uom OKS_PRICE_BREAKS_V.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
21: ,prorate OKS_PRICE_BREAKS_V.PRORATE%TYPE := OKC_API.G_MISS_CHAR
22: ,unit_price NUMBER := OKC_API.G_MISS_NUM
15: ,pricing_context OKS_PRICE_BREAKS_V.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR
16: ,pricing_method OKS_PRICE_BREAKS_V.PRICING_METHOD%TYPE := OKC_API.G_MISS_CHAR
17: ,quantity_from NUMBER := OKC_API.G_MISS_NUM
18: ,quantity_to NUMBER := OKC_API.G_MISS_NUM
19: ,quantity NUMBER := OKC_API.G_MISS_NUM
20: ,break_uom OKS_PRICE_BREAKS_V.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
21: ,prorate OKS_PRICE_BREAKS_V.PRORATE%TYPE := OKC_API.G_MISS_CHAR
22: ,unit_price NUMBER := OKC_API.G_MISS_NUM
23: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,pricing_method OKS_PRICE_BREAKS_V.PRICING_METHOD%TYPE := OKC_API.G_MISS_CHAR
17: ,quantity_from NUMBER := OKC_API.G_MISS_NUM
18: ,quantity_to NUMBER := OKC_API.G_MISS_NUM
19: ,quantity NUMBER := OKC_API.G_MISS_NUM
20: ,break_uom OKS_PRICE_BREAKS_V.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
21: ,prorate OKS_PRICE_BREAKS_V.PRORATE%TYPE := OKC_API.G_MISS_CHAR
22: ,unit_price NUMBER := OKC_API.G_MISS_NUM
23: ,amount NUMBER := OKC_API.G_MISS_NUM
24: ,price_list_id NUMBER := OKC_API.G_MISS_NUM
17: ,quantity_from NUMBER := OKC_API.G_MISS_NUM
18: ,quantity_to NUMBER := OKC_API.G_MISS_NUM
19: ,quantity NUMBER := OKC_API.G_MISS_NUM
20: ,break_uom OKS_PRICE_BREAKS_V.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
21: ,prorate OKS_PRICE_BREAKS_V.PRORATE%TYPE := OKC_API.G_MISS_CHAR
22: ,unit_price NUMBER := OKC_API.G_MISS_NUM
23: ,amount NUMBER := OKC_API.G_MISS_NUM
24: ,price_list_id NUMBER := OKC_API.G_MISS_NUM
25: ,validated_flag OKS_PRICE_BREAKS_V.VALIDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR
18: ,quantity_to NUMBER := OKC_API.G_MISS_NUM
19: ,quantity NUMBER := OKC_API.G_MISS_NUM
20: ,break_uom OKS_PRICE_BREAKS_V.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
21: ,prorate OKS_PRICE_BREAKS_V.PRORATE%TYPE := OKC_API.G_MISS_CHAR
22: ,unit_price NUMBER := OKC_API.G_MISS_NUM
23: ,amount NUMBER := OKC_API.G_MISS_NUM
24: ,price_list_id NUMBER := OKC_API.G_MISS_NUM
25: ,validated_flag OKS_PRICE_BREAKS_V.VALIDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR
26: ,status_code OKS_PRICE_BREAKS_V.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
19: ,quantity NUMBER := OKC_API.G_MISS_NUM
20: ,break_uom OKS_PRICE_BREAKS_V.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
21: ,prorate OKS_PRICE_BREAKS_V.PRORATE%TYPE := OKC_API.G_MISS_CHAR
22: ,unit_price NUMBER := OKC_API.G_MISS_NUM
23: ,amount NUMBER := OKC_API.G_MISS_NUM
24: ,price_list_id NUMBER := OKC_API.G_MISS_NUM
25: ,validated_flag OKS_PRICE_BREAKS_V.VALIDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR
26: ,status_code OKS_PRICE_BREAKS_V.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,status_text OKS_PRICE_BREAKS_V.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
20: ,break_uom OKS_PRICE_BREAKS_V.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
21: ,prorate OKS_PRICE_BREAKS_V.PRORATE%TYPE := OKC_API.G_MISS_CHAR
22: ,unit_price NUMBER := OKC_API.G_MISS_NUM
23: ,amount NUMBER := OKC_API.G_MISS_NUM
24: ,price_list_id NUMBER := OKC_API.G_MISS_NUM
25: ,validated_flag OKS_PRICE_BREAKS_V.VALIDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR
26: ,status_code OKS_PRICE_BREAKS_V.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,status_text OKS_PRICE_BREAKS_V.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
28: ,lock_flag OKS_PRICE_BREAKS_V.LOCK_FLAG%TYPE := OKC_API.G_MISS_CHAR
21: ,prorate OKS_PRICE_BREAKS_V.PRORATE%TYPE := OKC_API.G_MISS_CHAR
22: ,unit_price NUMBER := OKC_API.G_MISS_NUM
23: ,amount NUMBER := OKC_API.G_MISS_NUM
24: ,price_list_id NUMBER := OKC_API.G_MISS_NUM
25: ,validated_flag OKS_PRICE_BREAKS_V.VALIDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR
26: ,status_code OKS_PRICE_BREAKS_V.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,status_text OKS_PRICE_BREAKS_V.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
28: ,lock_flag OKS_PRICE_BREAKS_V.LOCK_FLAG%TYPE := OKC_API.G_MISS_CHAR
29: ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
22: ,unit_price NUMBER := OKC_API.G_MISS_NUM
23: ,amount NUMBER := OKC_API.G_MISS_NUM
24: ,price_list_id NUMBER := OKC_API.G_MISS_NUM
25: ,validated_flag OKS_PRICE_BREAKS_V.VALIDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR
26: ,status_code OKS_PRICE_BREAKS_V.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,status_text OKS_PRICE_BREAKS_V.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
28: ,lock_flag OKS_PRICE_BREAKS_V.LOCK_FLAG%TYPE := OKC_API.G_MISS_CHAR
29: ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
30: ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
23: ,amount NUMBER := OKC_API.G_MISS_NUM
24: ,price_list_id NUMBER := OKC_API.G_MISS_NUM
25: ,validated_flag OKS_PRICE_BREAKS_V.VALIDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR
26: ,status_code OKS_PRICE_BREAKS_V.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,status_text OKS_PRICE_BREAKS_V.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
28: ,lock_flag OKS_PRICE_BREAKS_V.LOCK_FLAG%TYPE := OKC_API.G_MISS_CHAR
29: ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
30: ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
31: ,price_list_line_id NUMBER := OKC_API.G_MISS_NUM
24: ,price_list_id NUMBER := OKC_API.G_MISS_NUM
25: ,validated_flag OKS_PRICE_BREAKS_V.VALIDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR
26: ,status_code OKS_PRICE_BREAKS_V.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,status_text OKS_PRICE_BREAKS_V.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
28: ,lock_flag OKS_PRICE_BREAKS_V.LOCK_FLAG%TYPE := OKC_API.G_MISS_CHAR
29: ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
30: ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
31: ,price_list_line_id NUMBER := OKC_API.G_MISS_NUM
32: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
25: ,validated_flag OKS_PRICE_BREAKS_V.VALIDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR
26: ,status_code OKS_PRICE_BREAKS_V.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,status_text OKS_PRICE_BREAKS_V.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
28: ,lock_flag OKS_PRICE_BREAKS_V.LOCK_FLAG%TYPE := OKC_API.G_MISS_CHAR
29: ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
30: ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
31: ,price_list_line_id NUMBER := OKC_API.G_MISS_NUM
32: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
33: ,created_by NUMBER := OKC_API.G_MISS_NUM
26: ,status_code OKS_PRICE_BREAKS_V.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,status_text OKS_PRICE_BREAKS_V.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
28: ,lock_flag OKS_PRICE_BREAKS_V.LOCK_FLAG%TYPE := OKC_API.G_MISS_CHAR
29: ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
30: ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
31: ,price_list_line_id NUMBER := OKC_API.G_MISS_NUM
32: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
33: ,created_by NUMBER := OKC_API.G_MISS_NUM
34: ,creation_date OKS_PRICE_BREAKS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,status_text OKS_PRICE_BREAKS_V.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
28: ,lock_flag OKS_PRICE_BREAKS_V.LOCK_FLAG%TYPE := OKC_API.G_MISS_CHAR
29: ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
30: ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
31: ,price_list_line_id NUMBER := OKC_API.G_MISS_NUM
32: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
33: ,created_by NUMBER := OKC_API.G_MISS_NUM
34: ,creation_date OKS_PRICE_BREAKS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
28: ,lock_flag OKS_PRICE_BREAKS_V.LOCK_FLAG%TYPE := OKC_API.G_MISS_CHAR
29: ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
30: ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
31: ,price_list_line_id NUMBER := OKC_API.G_MISS_NUM
32: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
33: ,created_by NUMBER := OKC_API.G_MISS_NUM
34: ,creation_date OKS_PRICE_BREAKS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
36: ,last_update_date OKS_PRICE_BREAKS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
30: ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
31: ,price_list_line_id NUMBER := OKC_API.G_MISS_NUM
32: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
33: ,created_by NUMBER := OKC_API.G_MISS_NUM
34: ,creation_date OKS_PRICE_BREAKS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
36: ,last_update_date OKS_PRICE_BREAKS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
30: ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
31: ,price_list_line_id NUMBER := OKC_API.G_MISS_NUM
32: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
33: ,created_by NUMBER := OKC_API.G_MISS_NUM
34: ,creation_date OKS_PRICE_BREAKS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
36: ,last_update_date OKS_PRICE_BREAKS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
38: G_MISS_pbrv_rec pbrv_rec_type;
31: ,price_list_line_id NUMBER := OKC_API.G_MISS_NUM
32: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
33: ,created_by NUMBER := OKC_API.G_MISS_NUM
34: ,creation_date OKS_PRICE_BREAKS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
36: ,last_update_date OKS_PRICE_BREAKS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
38: G_MISS_pbrv_rec pbrv_rec_type;
39: TYPE pbrv_tbl_type IS TABLE OF pbrv_rec_type
32: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
33: ,created_by NUMBER := OKC_API.G_MISS_NUM
34: ,creation_date OKS_PRICE_BREAKS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
36: ,last_update_date OKS_PRICE_BREAKS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
38: G_MISS_pbrv_rec pbrv_rec_type;
39: TYPE pbrv_tbl_type IS TABLE OF pbrv_rec_type
40: INDEX BY BINARY_INTEGER;
33: ,created_by NUMBER := OKC_API.G_MISS_NUM
34: ,creation_date OKS_PRICE_BREAKS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
36: ,last_update_date OKS_PRICE_BREAKS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
38: G_MISS_pbrv_rec pbrv_rec_type;
39: TYPE pbrv_tbl_type IS TABLE OF pbrv_rec_type
40: INDEX BY BINARY_INTEGER;
41: -- OKS_PRICE_BREAKS Record Spec
39: TYPE pbrv_tbl_type IS TABLE OF pbrv_rec_type
40: INDEX BY BINARY_INTEGER;
41: -- OKS_PRICE_BREAKS Record Spec
42: TYPE pbr_rec_type IS RECORD (
43: id NUMBER := OKC_API.G_MISS_NUM
44: ,bsl_id NUMBER := OKC_API.G_MISS_NUM
45: ,bcl_id NUMBER := OKC_API.G_MISS_NUM
46: ,cle_id NUMBER := OKC_API.G_MISS_NUM
47: ,chr_id NUMBER := OKC_API.G_MISS_NUM
40: INDEX BY BINARY_INTEGER;
41: -- OKS_PRICE_BREAKS Record Spec
42: TYPE pbr_rec_type IS RECORD (
43: id NUMBER := OKC_API.G_MISS_NUM
44: ,bsl_id NUMBER := OKC_API.G_MISS_NUM
45: ,bcl_id NUMBER := OKC_API.G_MISS_NUM
46: ,cle_id NUMBER := OKC_API.G_MISS_NUM
47: ,chr_id NUMBER := OKC_API.G_MISS_NUM
48: ,line_detail_index NUMBER := OKC_API.G_MISS_NUM
41: -- OKS_PRICE_BREAKS Record Spec
42: TYPE pbr_rec_type IS RECORD (
43: id NUMBER := OKC_API.G_MISS_NUM
44: ,bsl_id NUMBER := OKC_API.G_MISS_NUM
45: ,bcl_id NUMBER := OKC_API.G_MISS_NUM
46: ,cle_id NUMBER := OKC_API.G_MISS_NUM
47: ,chr_id NUMBER := OKC_API.G_MISS_NUM
48: ,line_detail_index NUMBER := OKC_API.G_MISS_NUM
49: ,line_index NUMBER := OKC_API.G_MISS_NUM
42: TYPE pbr_rec_type IS RECORD (
43: id NUMBER := OKC_API.G_MISS_NUM
44: ,bsl_id NUMBER := OKC_API.G_MISS_NUM
45: ,bcl_id NUMBER := OKC_API.G_MISS_NUM
46: ,cle_id NUMBER := OKC_API.G_MISS_NUM
47: ,chr_id NUMBER := OKC_API.G_MISS_NUM
48: ,line_detail_index NUMBER := OKC_API.G_MISS_NUM
49: ,line_index NUMBER := OKC_API.G_MISS_NUM
50: ,pricing_context OKS_PRICE_BREAKS.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR
43: id NUMBER := OKC_API.G_MISS_NUM
44: ,bsl_id NUMBER := OKC_API.G_MISS_NUM
45: ,bcl_id NUMBER := OKC_API.G_MISS_NUM
46: ,cle_id NUMBER := OKC_API.G_MISS_NUM
47: ,chr_id NUMBER := OKC_API.G_MISS_NUM
48: ,line_detail_index NUMBER := OKC_API.G_MISS_NUM
49: ,line_index NUMBER := OKC_API.G_MISS_NUM
50: ,pricing_context OKS_PRICE_BREAKS.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR
51: ,pricing_method OKS_PRICE_BREAKS.PRICING_METHOD%TYPE := OKC_API.G_MISS_CHAR
44: ,bsl_id NUMBER := OKC_API.G_MISS_NUM
45: ,bcl_id NUMBER := OKC_API.G_MISS_NUM
46: ,cle_id NUMBER := OKC_API.G_MISS_NUM
47: ,chr_id NUMBER := OKC_API.G_MISS_NUM
48: ,line_detail_index NUMBER := OKC_API.G_MISS_NUM
49: ,line_index NUMBER := OKC_API.G_MISS_NUM
50: ,pricing_context OKS_PRICE_BREAKS.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR
51: ,pricing_method OKS_PRICE_BREAKS.PRICING_METHOD%TYPE := OKC_API.G_MISS_CHAR
52: ,quantity_from NUMBER := OKC_API.G_MISS_NUM
45: ,bcl_id NUMBER := OKC_API.G_MISS_NUM
46: ,cle_id NUMBER := OKC_API.G_MISS_NUM
47: ,chr_id NUMBER := OKC_API.G_MISS_NUM
48: ,line_detail_index NUMBER := OKC_API.G_MISS_NUM
49: ,line_index NUMBER := OKC_API.G_MISS_NUM
50: ,pricing_context OKS_PRICE_BREAKS.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR
51: ,pricing_method OKS_PRICE_BREAKS.PRICING_METHOD%TYPE := OKC_API.G_MISS_CHAR
52: ,quantity_from NUMBER := OKC_API.G_MISS_NUM
53: ,quantity_to NUMBER := OKC_API.G_MISS_NUM
46: ,cle_id NUMBER := OKC_API.G_MISS_NUM
47: ,chr_id NUMBER := OKC_API.G_MISS_NUM
48: ,line_detail_index NUMBER := OKC_API.G_MISS_NUM
49: ,line_index NUMBER := OKC_API.G_MISS_NUM
50: ,pricing_context OKS_PRICE_BREAKS.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR
51: ,pricing_method OKS_PRICE_BREAKS.PRICING_METHOD%TYPE := OKC_API.G_MISS_CHAR
52: ,quantity_from NUMBER := OKC_API.G_MISS_NUM
53: ,quantity_to NUMBER := OKC_API.G_MISS_NUM
54: ,quantity NUMBER := OKC_API.G_MISS_NUM
47: ,chr_id NUMBER := OKC_API.G_MISS_NUM
48: ,line_detail_index NUMBER := OKC_API.G_MISS_NUM
49: ,line_index NUMBER := OKC_API.G_MISS_NUM
50: ,pricing_context OKS_PRICE_BREAKS.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR
51: ,pricing_method OKS_PRICE_BREAKS.PRICING_METHOD%TYPE := OKC_API.G_MISS_CHAR
52: ,quantity_from NUMBER := OKC_API.G_MISS_NUM
53: ,quantity_to NUMBER := OKC_API.G_MISS_NUM
54: ,quantity NUMBER := OKC_API.G_MISS_NUM
55: ,break_uom OKS_PRICE_BREAKS.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
48: ,line_detail_index NUMBER := OKC_API.G_MISS_NUM
49: ,line_index NUMBER := OKC_API.G_MISS_NUM
50: ,pricing_context OKS_PRICE_BREAKS.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR
51: ,pricing_method OKS_PRICE_BREAKS.PRICING_METHOD%TYPE := OKC_API.G_MISS_CHAR
52: ,quantity_from NUMBER := OKC_API.G_MISS_NUM
53: ,quantity_to NUMBER := OKC_API.G_MISS_NUM
54: ,quantity NUMBER := OKC_API.G_MISS_NUM
55: ,break_uom OKS_PRICE_BREAKS.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
56: ,prorate OKS_PRICE_BREAKS.PRORATE%TYPE := OKC_API.G_MISS_CHAR
49: ,line_index NUMBER := OKC_API.G_MISS_NUM
50: ,pricing_context OKS_PRICE_BREAKS.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR
51: ,pricing_method OKS_PRICE_BREAKS.PRICING_METHOD%TYPE := OKC_API.G_MISS_CHAR
52: ,quantity_from NUMBER := OKC_API.G_MISS_NUM
53: ,quantity_to NUMBER := OKC_API.G_MISS_NUM
54: ,quantity NUMBER := OKC_API.G_MISS_NUM
55: ,break_uom OKS_PRICE_BREAKS.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
56: ,prorate OKS_PRICE_BREAKS.PRORATE%TYPE := OKC_API.G_MISS_CHAR
57: ,unit_price NUMBER := OKC_API.G_MISS_NUM
50: ,pricing_context OKS_PRICE_BREAKS.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR
51: ,pricing_method OKS_PRICE_BREAKS.PRICING_METHOD%TYPE := OKC_API.G_MISS_CHAR
52: ,quantity_from NUMBER := OKC_API.G_MISS_NUM
53: ,quantity_to NUMBER := OKC_API.G_MISS_NUM
54: ,quantity NUMBER := OKC_API.G_MISS_NUM
55: ,break_uom OKS_PRICE_BREAKS.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
56: ,prorate OKS_PRICE_BREAKS.PRORATE%TYPE := OKC_API.G_MISS_CHAR
57: ,unit_price NUMBER := OKC_API.G_MISS_NUM
58: ,amount NUMBER := OKC_API.G_MISS_NUM
51: ,pricing_method OKS_PRICE_BREAKS.PRICING_METHOD%TYPE := OKC_API.G_MISS_CHAR
52: ,quantity_from NUMBER := OKC_API.G_MISS_NUM
53: ,quantity_to NUMBER := OKC_API.G_MISS_NUM
54: ,quantity NUMBER := OKC_API.G_MISS_NUM
55: ,break_uom OKS_PRICE_BREAKS.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
56: ,prorate OKS_PRICE_BREAKS.PRORATE%TYPE := OKC_API.G_MISS_CHAR
57: ,unit_price NUMBER := OKC_API.G_MISS_NUM
58: ,amount NUMBER := OKC_API.G_MISS_NUM
59: ,price_list_id NUMBER := OKC_API.G_MISS_NUM
52: ,quantity_from NUMBER := OKC_API.G_MISS_NUM
53: ,quantity_to NUMBER := OKC_API.G_MISS_NUM
54: ,quantity NUMBER := OKC_API.G_MISS_NUM
55: ,break_uom OKS_PRICE_BREAKS.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
56: ,prorate OKS_PRICE_BREAKS.PRORATE%TYPE := OKC_API.G_MISS_CHAR
57: ,unit_price NUMBER := OKC_API.G_MISS_NUM
58: ,amount NUMBER := OKC_API.G_MISS_NUM
59: ,price_list_id NUMBER := OKC_API.G_MISS_NUM
60: ,validated_flag OKS_PRICE_BREAKS.VALIDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR
53: ,quantity_to NUMBER := OKC_API.G_MISS_NUM
54: ,quantity NUMBER := OKC_API.G_MISS_NUM
55: ,break_uom OKS_PRICE_BREAKS.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
56: ,prorate OKS_PRICE_BREAKS.PRORATE%TYPE := OKC_API.G_MISS_CHAR
57: ,unit_price NUMBER := OKC_API.G_MISS_NUM
58: ,amount NUMBER := OKC_API.G_MISS_NUM
59: ,price_list_id NUMBER := OKC_API.G_MISS_NUM
60: ,validated_flag OKS_PRICE_BREAKS.VALIDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR
61: ,status_code OKS_PRICE_BREAKS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
54: ,quantity NUMBER := OKC_API.G_MISS_NUM
55: ,break_uom OKS_PRICE_BREAKS.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
56: ,prorate OKS_PRICE_BREAKS.PRORATE%TYPE := OKC_API.G_MISS_CHAR
57: ,unit_price NUMBER := OKC_API.G_MISS_NUM
58: ,amount NUMBER := OKC_API.G_MISS_NUM
59: ,price_list_id NUMBER := OKC_API.G_MISS_NUM
60: ,validated_flag OKS_PRICE_BREAKS.VALIDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR
61: ,status_code OKS_PRICE_BREAKS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
62: ,status_text OKS_PRICE_BREAKS.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
55: ,break_uom OKS_PRICE_BREAKS.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
56: ,prorate OKS_PRICE_BREAKS.PRORATE%TYPE := OKC_API.G_MISS_CHAR
57: ,unit_price NUMBER := OKC_API.G_MISS_NUM
58: ,amount NUMBER := OKC_API.G_MISS_NUM
59: ,price_list_id NUMBER := OKC_API.G_MISS_NUM
60: ,validated_flag OKS_PRICE_BREAKS.VALIDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR
61: ,status_code OKS_PRICE_BREAKS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
62: ,status_text OKS_PRICE_BREAKS.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
63: ,lock_flag OKS_PRICE_BREAKS.LOCK_FLAG%TYPE := OKC_API.G_MISS_CHAR
56: ,prorate OKS_PRICE_BREAKS.PRORATE%TYPE := OKC_API.G_MISS_CHAR
57: ,unit_price NUMBER := OKC_API.G_MISS_NUM
58: ,amount NUMBER := OKC_API.G_MISS_NUM
59: ,price_list_id NUMBER := OKC_API.G_MISS_NUM
60: ,validated_flag OKS_PRICE_BREAKS.VALIDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR
61: ,status_code OKS_PRICE_BREAKS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
62: ,status_text OKS_PRICE_BREAKS.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
63: ,lock_flag OKS_PRICE_BREAKS.LOCK_FLAG%TYPE := OKC_API.G_MISS_CHAR
64: ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
57: ,unit_price NUMBER := OKC_API.G_MISS_NUM
58: ,amount NUMBER := OKC_API.G_MISS_NUM
59: ,price_list_id NUMBER := OKC_API.G_MISS_NUM
60: ,validated_flag OKS_PRICE_BREAKS.VALIDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR
61: ,status_code OKS_PRICE_BREAKS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
62: ,status_text OKS_PRICE_BREAKS.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
63: ,lock_flag OKS_PRICE_BREAKS.LOCK_FLAG%TYPE := OKC_API.G_MISS_CHAR
64: ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
65: ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
58: ,amount NUMBER := OKC_API.G_MISS_NUM
59: ,price_list_id NUMBER := OKC_API.G_MISS_NUM
60: ,validated_flag OKS_PRICE_BREAKS.VALIDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR
61: ,status_code OKS_PRICE_BREAKS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
62: ,status_text OKS_PRICE_BREAKS.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
63: ,lock_flag OKS_PRICE_BREAKS.LOCK_FLAG%TYPE := OKC_API.G_MISS_CHAR
64: ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
65: ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
66: ,price_list_line_id NUMBER := OKC_API.G_MISS_NUM
59: ,price_list_id NUMBER := OKC_API.G_MISS_NUM
60: ,validated_flag OKS_PRICE_BREAKS.VALIDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR
61: ,status_code OKS_PRICE_BREAKS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
62: ,status_text OKS_PRICE_BREAKS.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
63: ,lock_flag OKS_PRICE_BREAKS.LOCK_FLAG%TYPE := OKC_API.G_MISS_CHAR
64: ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
65: ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
66: ,price_list_line_id NUMBER := OKC_API.G_MISS_NUM
67: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
60: ,validated_flag OKS_PRICE_BREAKS.VALIDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR
61: ,status_code OKS_PRICE_BREAKS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
62: ,status_text OKS_PRICE_BREAKS.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
63: ,lock_flag OKS_PRICE_BREAKS.LOCK_FLAG%TYPE := OKC_API.G_MISS_CHAR
64: ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
65: ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
66: ,price_list_line_id NUMBER := OKC_API.G_MISS_NUM
67: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
68: ,created_by NUMBER := OKC_API.G_MISS_NUM
61: ,status_code OKS_PRICE_BREAKS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
62: ,status_text OKS_PRICE_BREAKS.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
63: ,lock_flag OKS_PRICE_BREAKS.LOCK_FLAG%TYPE := OKC_API.G_MISS_CHAR
64: ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
65: ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
66: ,price_list_line_id NUMBER := OKC_API.G_MISS_NUM
67: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
68: ,created_by NUMBER := OKC_API.G_MISS_NUM
69: ,creation_date OKS_PRICE_BREAKS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
62: ,status_text OKS_PRICE_BREAKS.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
63: ,lock_flag OKS_PRICE_BREAKS.LOCK_FLAG%TYPE := OKC_API.G_MISS_CHAR
64: ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
65: ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
66: ,price_list_line_id NUMBER := OKC_API.G_MISS_NUM
67: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
68: ,created_by NUMBER := OKC_API.G_MISS_NUM
69: ,creation_date OKS_PRICE_BREAKS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
70: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
63: ,lock_flag OKS_PRICE_BREAKS.LOCK_FLAG%TYPE := OKC_API.G_MISS_CHAR
64: ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
65: ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
66: ,price_list_line_id NUMBER := OKC_API.G_MISS_NUM
67: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
68: ,created_by NUMBER := OKC_API.G_MISS_NUM
69: ,creation_date OKS_PRICE_BREAKS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
70: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
71: ,last_update_date OKS_PRICE_BREAKS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
65: ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
66: ,price_list_line_id NUMBER := OKC_API.G_MISS_NUM
67: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
68: ,created_by NUMBER := OKC_API.G_MISS_NUM
69: ,creation_date OKS_PRICE_BREAKS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
70: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
71: ,last_update_date OKS_PRICE_BREAKS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
72: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
65: ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
66: ,price_list_line_id NUMBER := OKC_API.G_MISS_NUM
67: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
68: ,created_by NUMBER := OKC_API.G_MISS_NUM
69: ,creation_date OKS_PRICE_BREAKS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
70: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
71: ,last_update_date OKS_PRICE_BREAKS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
72: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
73: G_MISS_pbr_rec pbr_rec_type;
66: ,price_list_line_id NUMBER := OKC_API.G_MISS_NUM
67: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
68: ,created_by NUMBER := OKC_API.G_MISS_NUM
69: ,creation_date OKS_PRICE_BREAKS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
70: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
71: ,last_update_date OKS_PRICE_BREAKS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
72: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
73: G_MISS_pbr_rec pbr_rec_type;
74: TYPE pbr_tbl_type IS TABLE OF pbr_rec_type
67: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
68: ,created_by NUMBER := OKC_API.G_MISS_NUM
69: ,creation_date OKS_PRICE_BREAKS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
70: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
71: ,last_update_date OKS_PRICE_BREAKS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
72: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
73: G_MISS_pbr_rec pbr_rec_type;
74: TYPE pbr_tbl_type IS TABLE OF pbr_rec_type
75: INDEX BY BINARY_INTEGER;
68: ,created_by NUMBER := OKC_API.G_MISS_NUM
69: ,creation_date OKS_PRICE_BREAKS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
70: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
71: ,last_update_date OKS_PRICE_BREAKS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
72: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
73: G_MISS_pbr_rec pbr_rec_type;
74: TYPE pbr_tbl_type IS TABLE OF pbr_rec_type
75: INDEX BY BINARY_INTEGER;
76: ---------------------------------------------------------------------------
75: INDEX BY BINARY_INTEGER;
76: ---------------------------------------------------------------------------
77: -- GLOBAL MESSAGE CONSTANTS
78: ---------------------------------------------------------------------------
79: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
80: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
81: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
82: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
83: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
76: ---------------------------------------------------------------------------
77: -- GLOBAL MESSAGE CONSTANTS
78: ---------------------------------------------------------------------------
79: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
80: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
81: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
82: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
83: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
84: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
77: -- GLOBAL MESSAGE CONSTANTS
78: ---------------------------------------------------------------------------
79: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
80: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
81: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
82: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
83: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
84: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
85: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
78: ---------------------------------------------------------------------------
79: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
80: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
81: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
82: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
83: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
84: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
85: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
86: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
79: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
80: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
81: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
82: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
83: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
84: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
85: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
86: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
87: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
80: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
81: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
82: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
83: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
84: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
85: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
86: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
87: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
88: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
81: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
82: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
83: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
84: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
85: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
86: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
87: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
88: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
89: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
82: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
83: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
84: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
85: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
86: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
87: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
88: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
89: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
90: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
83: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
84: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
85: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
86: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
87: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
88: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
89: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
90: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
91: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
84: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
85: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
86: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
87: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
88: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
89: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
90: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
91: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
92:
98: ---------------------------------------------------------------------------
99: -- GLOBAL VARIABLES
100: ---------------------------------------------------------------------------
101: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_PBR_PVT';
102: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
103: ---------------------------------------------------------------------------
104: -- Procedures and Functions
105: ---------------------------------------------------------------------------
106:
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2,
124: p_pbrv_tbl IN pbrv_tbl_type,
125: x_pbrv_tbl OUT NOCOPY pbrv_tbl_type,
126: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
127: PROCEDURE insert_row(
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2,
130: x_return_status OUT NOCOPY VARCHAR2,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_pbrv_tbl IN pbrv_tbl_type,
149: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
150: PROCEDURE lock_row(
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2,
153: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_pbrv_tbl IN pbrv_tbl_type,
172: x_pbrv_tbl OUT NOCOPY pbrv_tbl_type,
173: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
174: PROCEDURE update_row(
175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2,
177: x_return_status OUT NOCOPY VARCHAR2,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_pbrv_tbl IN pbrv_tbl_type,
196: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
197: PROCEDURE delete_row(
198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2,
200: x_return_status OUT NOCOPY VARCHAR2,
214: x_return_status OUT NOCOPY VARCHAR2,
215: x_msg_count OUT NOCOPY NUMBER,
216: x_msg_data OUT NOCOPY VARCHAR2,
217: p_pbrv_tbl IN pbrv_tbl_type,
218: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
219: PROCEDURE validate_row(
220: p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2,
222: x_return_status OUT NOCOPY VARCHAR2,