10:
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_pricelist_PVT';
12:
13: TYPE OZF_Price_List_Rec_Type IS RECORD
14: ( currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
15: , end_date_active DATE := FND_API.G_MISS_DATE
16: , list_header_id NUMBER := FND_API.G_MISS_NUM
17: , start_date_active DATE := FND_API.G_MISS_DATE
18: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_pricelist_PVT';
12:
13: TYPE OZF_Price_List_Rec_Type IS RECORD
14: ( currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
15: , end_date_active DATE := FND_API.G_MISS_DATE
16: , list_header_id NUMBER := FND_API.G_MISS_NUM
17: , start_date_active DATE := FND_API.G_MISS_DATE
18: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
19: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
12:
13: TYPE OZF_Price_List_Rec_Type IS RECORD
14: ( currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
15: , end_date_active DATE := FND_API.G_MISS_DATE
16: , list_header_id NUMBER := FND_API.G_MISS_NUM
17: , start_date_active DATE := FND_API.G_MISS_DATE
18: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
19: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
13: TYPE OZF_Price_List_Rec_Type IS RECORD
14: ( currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
15: , end_date_active DATE := FND_API.G_MISS_DATE
16: , list_header_id NUMBER := FND_API.G_MISS_NUM
17: , start_date_active DATE := FND_API.G_MISS_DATE
18: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
19: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
21: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
14: ( currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
15: , end_date_active DATE := FND_API.G_MISS_DATE
16: , list_header_id NUMBER := FND_API.G_MISS_NUM
17: , start_date_active DATE := FND_API.G_MISS_DATE
18: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
19: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
21: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
22: , PRICE_LIST_ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM
15: , end_date_active DATE := FND_API.G_MISS_DATE
16: , list_header_id NUMBER := FND_API.G_MISS_NUM
17: , start_date_active DATE := FND_API.G_MISS_DATE
18: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
19: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
21: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
22: , PRICE_LIST_ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM
23: , USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM
16: , list_header_id NUMBER := FND_API.G_MISS_NUM
17: , start_date_active DATE := FND_API.G_MISS_DATE
18: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
19: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
21: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
22: , PRICE_LIST_ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM
23: , USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM
24: , CUSTOM_SETUP_ID NUMBER := FND_API.G_MISS_NUM
17: , start_date_active DATE := FND_API.G_MISS_DATE
18: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
19: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
21: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
22: , PRICE_LIST_ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM
23: , USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM
24: , CUSTOM_SETUP_ID NUMBER := FND_API.G_MISS_NUM
25: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
18: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
19: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
21: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
22: , PRICE_LIST_ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM
23: , USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM
24: , CUSTOM_SETUP_ID NUMBER := FND_API.G_MISS_NUM
25: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , OWNER_ID NUMBER := FND_API.G_MISS_NUM
19: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
21: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
22: , PRICE_LIST_ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM
23: , USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM
24: , CUSTOM_SETUP_ID NUMBER := FND_API.G_MISS_NUM
25: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , OWNER_ID NUMBER := FND_API.G_MISS_NUM
27: , QP_LIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM
20: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
21: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
22: , PRICE_LIST_ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM
23: , USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM
24: , CUSTOM_SETUP_ID NUMBER := FND_API.G_MISS_NUM
25: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , OWNER_ID NUMBER := FND_API.G_MISS_NUM
27: , QP_LIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM
28: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
21: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
22: , PRICE_LIST_ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM
23: , USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM
24: , CUSTOM_SETUP_ID NUMBER := FND_API.G_MISS_NUM
25: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , OWNER_ID NUMBER := FND_API.G_MISS_NUM
27: , QP_LIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM
28: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
29: , STATUS_DATE DATE := FND_API.G_MISS_DATE
22: , PRICE_LIST_ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM
23: , USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM
24: , CUSTOM_SETUP_ID NUMBER := FND_API.G_MISS_NUM
25: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , OWNER_ID NUMBER := FND_API.G_MISS_NUM
27: , QP_LIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM
28: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
29: , STATUS_DATE DATE := FND_API.G_MISS_DATE
30: , WF_ITEM_KEY VARCHAR2(100) := FND_API.G_MISS_CHAR
23: , USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM
24: , CUSTOM_SETUP_ID NUMBER := FND_API.G_MISS_NUM
25: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , OWNER_ID NUMBER := FND_API.G_MISS_NUM
27: , QP_LIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM
28: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
29: , STATUS_DATE DATE := FND_API.G_MISS_DATE
30: , WF_ITEM_KEY VARCHAR2(100) := FND_API.G_MISS_CHAR
31: , currency_header_id NUMBER := FND_API.G_MISS_NUM
24: , CUSTOM_SETUP_ID NUMBER := FND_API.G_MISS_NUM
25: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , OWNER_ID NUMBER := FND_API.G_MISS_NUM
27: , QP_LIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM
28: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
29: , STATUS_DATE DATE := FND_API.G_MISS_DATE
30: , WF_ITEM_KEY VARCHAR2(100) := FND_API.G_MISS_CHAR
31: , currency_header_id NUMBER := FND_API.G_MISS_NUM
32: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
25: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , OWNER_ID NUMBER := FND_API.G_MISS_NUM
27: , QP_LIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM
28: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
29: , STATUS_DATE DATE := FND_API.G_MISS_DATE
30: , WF_ITEM_KEY VARCHAR2(100) := FND_API.G_MISS_CHAR
31: , currency_header_id NUMBER := FND_API.G_MISS_NUM
32: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
33: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
26: , OWNER_ID NUMBER := FND_API.G_MISS_NUM
27: , QP_LIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM
28: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
29: , STATUS_DATE DATE := FND_API.G_MISS_DATE
30: , WF_ITEM_KEY VARCHAR2(100) := FND_API.G_MISS_CHAR
31: , currency_header_id NUMBER := FND_API.G_MISS_NUM
32: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
33: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
34: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
27: , QP_LIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM
28: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
29: , STATUS_DATE DATE := FND_API.G_MISS_DATE
30: , WF_ITEM_KEY VARCHAR2(100) := FND_API.G_MISS_CHAR
31: , currency_header_id NUMBER := FND_API.G_MISS_NUM
32: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
33: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
34: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
35: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
28: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
29: , STATUS_DATE DATE := FND_API.G_MISS_DATE
30: , WF_ITEM_KEY VARCHAR2(100) := FND_API.G_MISS_CHAR
31: , currency_header_id NUMBER := FND_API.G_MISS_NUM
32: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
33: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
34: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
35: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
36: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
29: , STATUS_DATE DATE := FND_API.G_MISS_DATE
30: , WF_ITEM_KEY VARCHAR2(100) := FND_API.G_MISS_CHAR
31: , currency_header_id NUMBER := FND_API.G_MISS_NUM
32: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
33: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
34: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
35: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
36: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
37: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
30: , WF_ITEM_KEY VARCHAR2(100) := FND_API.G_MISS_CHAR
31: , currency_header_id NUMBER := FND_API.G_MISS_NUM
32: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
33: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
34: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
35: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
36: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
37: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
38: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
31: , currency_header_id NUMBER := FND_API.G_MISS_NUM
32: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
33: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
34: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
35: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
36: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
37: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
38: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
39: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
32: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
33: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
34: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
35: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
36: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
37: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
38: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
39: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
40: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
33: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
34: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
35: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
36: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
37: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
38: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
39: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
40: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
41: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
34: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
35: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
36: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
37: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
38: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
39: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
40: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
41: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
42: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
35: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
36: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
37: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
38: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
39: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
40: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
41: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
42: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
43: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
36: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
37: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
38: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
39: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
40: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
41: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
42: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
43: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
44: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
37: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
38: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
39: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
40: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
41: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
42: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
43: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
44: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
45: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
38: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
39: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
40: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
41: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
42: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
43: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
44: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
45: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
46: , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
39: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
40: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
41: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
42: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
43: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
44: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
45: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
46: , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
47: , ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
40: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
41: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
42: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
43: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
44: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
45: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
46: , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
47: , ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
48: , global_flag VARCHAR2(1) := Fnd_Api.g_miss_char
41: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
42: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
43: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
44: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
45: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
46: , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
47: , ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
48: , global_flag VARCHAR2(1) := Fnd_Api.g_miss_char
49: , org_id NUMBER := FND_API.G_MISS_NUM
42: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
43: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
44: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
45: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
46: , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
47: , ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
48: , global_flag VARCHAR2(1) := Fnd_Api.g_miss_char
49: , org_id NUMBER := FND_API.G_MISS_NUM
50: );
43: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
44: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
45: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
46: , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
47: , ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
48: , global_flag VARCHAR2(1) := Fnd_Api.g_miss_char
49: , org_id NUMBER := FND_API.G_MISS_NUM
50: );
51:
44: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
45: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
46: , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
47: , ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
48: , global_flag VARCHAR2(1) := Fnd_Api.g_miss_char
49: , org_id NUMBER := FND_API.G_MISS_NUM
50: );
51:
52: TYPE Qualifiers_Rec_Type IS RECORD
45: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
46: , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
47: , ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
48: , global_flag VARCHAR2(1) := Fnd_Api.g_miss_char
49: , org_id NUMBER := FND_API.G_MISS_NUM
50: );
51:
52: TYPE Qualifiers_Rec_Type IS RECORD
53: ( comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
49: , org_id NUMBER := FND_API.G_MISS_NUM
50: );
51:
52: TYPE Qualifiers_Rec_Type IS RECORD
53: ( comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
54: , created_by NUMBER := FND_API.G_MISS_NUM
55: , end_date_active DATE := FND_API.G_MISS_DATE
56: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
57: , list_header_id NUMBER := FND_API.G_MISS_NUM
50: );
51:
52: TYPE Qualifiers_Rec_Type IS RECORD
53: ( comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
54: , created_by NUMBER := FND_API.G_MISS_NUM
55: , end_date_active DATE := FND_API.G_MISS_DATE
56: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
57: , list_header_id NUMBER := FND_API.G_MISS_NUM
58: , list_line_id NUMBER := FND_API.G_MISS_NUM
51:
52: TYPE Qualifiers_Rec_Type IS RECORD
53: ( comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
54: , created_by NUMBER := FND_API.G_MISS_NUM
55: , end_date_active DATE := FND_API.G_MISS_DATE
56: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
57: , list_header_id NUMBER := FND_API.G_MISS_NUM
58: , list_line_id NUMBER := FND_API.G_MISS_NUM
59: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
52: TYPE Qualifiers_Rec_Type IS RECORD
53: ( comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
54: , created_by NUMBER := FND_API.G_MISS_NUM
55: , end_date_active DATE := FND_API.G_MISS_DATE
56: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
57: , list_header_id NUMBER := FND_API.G_MISS_NUM
58: , list_line_id NUMBER := FND_API.G_MISS_NUM
59: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
53: ( comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
54: , created_by NUMBER := FND_API.G_MISS_NUM
55: , end_date_active DATE := FND_API.G_MISS_DATE
56: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
57: , list_header_id NUMBER := FND_API.G_MISS_NUM
58: , list_line_id NUMBER := FND_API.G_MISS_NUM
59: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
61: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
54: , created_by NUMBER := FND_API.G_MISS_NUM
55: , end_date_active DATE := FND_API.G_MISS_DATE
56: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
57: , list_header_id NUMBER := FND_API.G_MISS_NUM
58: , list_line_id NUMBER := FND_API.G_MISS_NUM
59: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
61: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
62: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
55: , end_date_active DATE := FND_API.G_MISS_DATE
56: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
57: , list_header_id NUMBER := FND_API.G_MISS_NUM
58: , list_line_id NUMBER := FND_API.G_MISS_NUM
59: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
61: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
62: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
63: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
56: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
57: , list_header_id NUMBER := FND_API.G_MISS_NUM
58: , list_line_id NUMBER := FND_API.G_MISS_NUM
59: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
61: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
62: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
63: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
64: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
57: , list_header_id NUMBER := FND_API.G_MISS_NUM
58: , list_line_id NUMBER := FND_API.G_MISS_NUM
59: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
61: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
62: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
63: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
64: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
65: , qualifier_id NUMBER := FND_API.G_MISS_NUM
58: , list_line_id NUMBER := FND_API.G_MISS_NUM
59: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
61: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
62: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
63: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
64: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
65: , qualifier_id NUMBER := FND_API.G_MISS_NUM
66: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
59: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
61: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
62: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
63: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
64: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
65: , qualifier_id NUMBER := FND_API.G_MISS_NUM
66: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
67: , start_date_active DATE := FND_API.G_MISS_DATE
60: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
61: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
62: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
63: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
64: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
65: , qualifier_id NUMBER := FND_API.G_MISS_NUM
66: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
67: , start_date_active DATE := FND_API.G_MISS_DATE
68: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
61: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
62: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
63: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
64: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
65: , qualifier_id NUMBER := FND_API.G_MISS_NUM
66: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
67: , start_date_active DATE := FND_API.G_MISS_DATE
68: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
69: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
62: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
63: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
64: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
65: , qualifier_id NUMBER := FND_API.G_MISS_NUM
66: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
67: , start_date_active DATE := FND_API.G_MISS_DATE
68: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
69: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
70: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
63: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
64: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
65: , qualifier_id NUMBER := FND_API.G_MISS_NUM
66: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
67: , start_date_active DATE := FND_API.G_MISS_DATE
68: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
69: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
70: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
71: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
64: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
65: , qualifier_id NUMBER := FND_API.G_MISS_NUM
66: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
67: , start_date_active DATE := FND_API.G_MISS_DATE
68: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
69: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
70: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
71: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
72: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
65: , qualifier_id NUMBER := FND_API.G_MISS_NUM
66: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
67: , start_date_active DATE := FND_API.G_MISS_DATE
68: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
69: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
70: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
71: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
72: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
73: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
66: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
67: , start_date_active DATE := FND_API.G_MISS_DATE
68: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
69: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
70: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
71: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
72: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
73: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
74: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
67: , start_date_active DATE := FND_API.G_MISS_DATE
68: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
69: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
70: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
71: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
72: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
73: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
74: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
75: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
68: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
69: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
70: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
71: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
72: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
73: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
74: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
75: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
76: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
69: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
70: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
71: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
72: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
73: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
74: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
75: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
76: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
77: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
70: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
71: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
72: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
73: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
74: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
75: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
76: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
77: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
78: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
71: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
72: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
73: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
74: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
75: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
76: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
77: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
78: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
79: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
72: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
73: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
74: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
75: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
76: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
77: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
78: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
79: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
80: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
73: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
74: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
75: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
76: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
77: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
78: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
79: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
80: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
81: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
74: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
75: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
76: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
77: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
78: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
79: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
80: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
81: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
82: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
75: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
76: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
77: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
78: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
79: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
80: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
81: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
82: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
83: , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
76: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
77: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
78: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
79: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
80: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
81: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
82: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
83: , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
84: , ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
77: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
78: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
79: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
80: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
81: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
82: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
83: , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
84: , ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
85: );
78: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
79: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
80: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
81: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
82: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
83: , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
84: , ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
85: );
86:
79: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
80: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
81: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
82: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
83: , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
84: , ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
85: );
86:
87: TYPE Qualifiers_Tbl_Type IS TABLE OF Qualifiers_Rec_Type
80: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
81: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
82: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
83: , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
84: , ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
85: );
86:
87: TYPE Qualifiers_Tbl_Type IS TABLE OF Qualifiers_Rec_Type
88: INDEX BY BINARY_INTEGER;
87: TYPE Qualifiers_Tbl_Type IS TABLE OF Qualifiers_Rec_Type
88: INDEX BY BINARY_INTEGER;
89:
90: TYPE Price_List_Line_Rec_Type IS RECORD
91: ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , end_date_active DATE := FND_API.G_MISS_DATE
93: , list_header_id NUMBER := FND_API.G_MISS_NUM
94: , list_line_id NUMBER := FND_API.G_MISS_NUM
95: , list_price NUMBER := FND_API.G_MISS_NUM
88: INDEX BY BINARY_INTEGER;
89:
90: TYPE Price_List_Line_Rec_Type IS RECORD
91: ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , end_date_active DATE := FND_API.G_MISS_DATE
93: , list_header_id NUMBER := FND_API.G_MISS_NUM
94: , list_line_id NUMBER := FND_API.G_MISS_NUM
95: , list_price NUMBER := FND_API.G_MISS_NUM
96: , operand NUMBER := FND_API.G_MISS_NUM
89:
90: TYPE Price_List_Line_Rec_Type IS RECORD
91: ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , end_date_active DATE := FND_API.G_MISS_DATE
93: , list_header_id NUMBER := FND_API.G_MISS_NUM
94: , list_line_id NUMBER := FND_API.G_MISS_NUM
95: , list_price NUMBER := FND_API.G_MISS_NUM
96: , operand NUMBER := FND_API.G_MISS_NUM
97: , start_date_active DATE := FND_API.G_MISS_DATE
90: TYPE Price_List_Line_Rec_Type IS RECORD
91: ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , end_date_active DATE := FND_API.G_MISS_DATE
93: , list_header_id NUMBER := FND_API.G_MISS_NUM
94: , list_line_id NUMBER := FND_API.G_MISS_NUM
95: , list_price NUMBER := FND_API.G_MISS_NUM
96: , operand NUMBER := FND_API.G_MISS_NUM
97: , start_date_active DATE := FND_API.G_MISS_DATE
98: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
91: ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , end_date_active DATE := FND_API.G_MISS_DATE
93: , list_header_id NUMBER := FND_API.G_MISS_NUM
94: , list_line_id NUMBER := FND_API.G_MISS_NUM
95: , list_price NUMBER := FND_API.G_MISS_NUM
96: , operand NUMBER := FND_API.G_MISS_NUM
97: , start_date_active DATE := FND_API.G_MISS_DATE
98: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
99: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: , end_date_active DATE := FND_API.G_MISS_DATE
93: , list_header_id NUMBER := FND_API.G_MISS_NUM
94: , list_line_id NUMBER := FND_API.G_MISS_NUM
95: , list_price NUMBER := FND_API.G_MISS_NUM
96: , operand NUMBER := FND_API.G_MISS_NUM
97: , start_date_active DATE := FND_API.G_MISS_DATE
98: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
99: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
100: , product_precedence NUMBER := FND_API.G_MISS_NUM
93: , list_header_id NUMBER := FND_API.G_MISS_NUM
94: , list_line_id NUMBER := FND_API.G_MISS_NUM
95: , list_price NUMBER := FND_API.G_MISS_NUM
96: , operand NUMBER := FND_API.G_MISS_NUM
97: , start_date_active DATE := FND_API.G_MISS_DATE
98: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
99: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
100: , product_precedence NUMBER := FND_API.G_MISS_NUM
101: , static_formula_id NUMBER := FND_API.G_MISS_NUM
94: , list_line_id NUMBER := FND_API.G_MISS_NUM
95: , list_price NUMBER := FND_API.G_MISS_NUM
96: , operand NUMBER := FND_API.G_MISS_NUM
97: , start_date_active DATE := FND_API.G_MISS_DATE
98: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
99: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
100: , product_precedence NUMBER := FND_API.G_MISS_NUM
101: , static_formula_id NUMBER := FND_API.G_MISS_NUM
102: , dynamic_formula_id NUMBER := FND_API.G_MISS_NUM
95: , list_price NUMBER := FND_API.G_MISS_NUM
96: , operand NUMBER := FND_API.G_MISS_NUM
97: , start_date_active DATE := FND_API.G_MISS_DATE
98: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
99: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
100: , product_precedence NUMBER := FND_API.G_MISS_NUM
101: , static_formula_id NUMBER := FND_API.G_MISS_NUM
102: , dynamic_formula_id NUMBER := FND_API.G_MISS_NUM
103: , jtf_note_id NUMBER := FND_API.G_MISS_NUM
96: , operand NUMBER := FND_API.G_MISS_NUM
97: , start_date_active DATE := FND_API.G_MISS_DATE
98: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
99: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
100: , product_precedence NUMBER := FND_API.G_MISS_NUM
101: , static_formula_id NUMBER := FND_API.G_MISS_NUM
102: , dynamic_formula_id NUMBER := FND_API.G_MISS_NUM
103: , jtf_note_id NUMBER := FND_API.G_MISS_NUM
104: , comments VARCHAR2(2000) := fnd_api.g_miss_char
97: , start_date_active DATE := FND_API.G_MISS_DATE
98: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
99: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
100: , product_precedence NUMBER := FND_API.G_MISS_NUM
101: , static_formula_id NUMBER := FND_API.G_MISS_NUM
102: , dynamic_formula_id NUMBER := FND_API.G_MISS_NUM
103: , jtf_note_id NUMBER := FND_API.G_MISS_NUM
104: , comments VARCHAR2(2000) := fnd_api.g_miss_char
105: , object_version_number NUMBER := FND_API.G_MISS_NUM
98: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
99: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
100: , product_precedence NUMBER := FND_API.G_MISS_NUM
101: , static_formula_id NUMBER := FND_API.G_MISS_NUM
102: , dynamic_formula_id NUMBER := FND_API.G_MISS_NUM
103: , jtf_note_id NUMBER := FND_API.G_MISS_NUM
104: , comments VARCHAR2(2000) := fnd_api.g_miss_char
105: , object_version_number NUMBER := FND_API.G_MISS_NUM
106: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
99: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
100: , product_precedence NUMBER := FND_API.G_MISS_NUM
101: , static_formula_id NUMBER := FND_API.G_MISS_NUM
102: , dynamic_formula_id NUMBER := FND_API.G_MISS_NUM
103: , jtf_note_id NUMBER := FND_API.G_MISS_NUM
104: , comments VARCHAR2(2000) := fnd_api.g_miss_char
105: , object_version_number NUMBER := FND_API.G_MISS_NUM
106: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
107: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
100: , product_precedence NUMBER := FND_API.G_MISS_NUM
101: , static_formula_id NUMBER := FND_API.G_MISS_NUM
102: , dynamic_formula_id NUMBER := FND_API.G_MISS_NUM
103: , jtf_note_id NUMBER := FND_API.G_MISS_NUM
104: , comments VARCHAR2(2000) := fnd_api.g_miss_char
105: , object_version_number NUMBER := FND_API.G_MISS_NUM
106: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
107: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
108: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
101: , static_formula_id NUMBER := FND_API.G_MISS_NUM
102: , dynamic_formula_id NUMBER := FND_API.G_MISS_NUM
103: , jtf_note_id NUMBER := FND_API.G_MISS_NUM
104: , comments VARCHAR2(2000) := fnd_api.g_miss_char
105: , object_version_number NUMBER := FND_API.G_MISS_NUM
106: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
107: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
108: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
109: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
102: , dynamic_formula_id NUMBER := FND_API.G_MISS_NUM
103: , jtf_note_id NUMBER := FND_API.G_MISS_NUM
104: , comments VARCHAR2(2000) := fnd_api.g_miss_char
105: , object_version_number NUMBER := FND_API.G_MISS_NUM
106: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
107: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
108: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
109: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
110: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
103: , jtf_note_id NUMBER := FND_API.G_MISS_NUM
104: , comments VARCHAR2(2000) := fnd_api.g_miss_char
105: , object_version_number NUMBER := FND_API.G_MISS_NUM
106: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
107: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
108: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
109: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
110: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
111: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
104: , comments VARCHAR2(2000) := fnd_api.g_miss_char
105: , object_version_number NUMBER := FND_API.G_MISS_NUM
106: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
107: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
108: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
109: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
110: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
111: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
112: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
105: , object_version_number NUMBER := FND_API.G_MISS_NUM
106: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
107: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
108: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
109: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
110: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
111: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
112: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
113: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
106: , CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
107: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
108: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
109: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
110: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
111: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
112: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
113: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
114: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
107: , ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
108: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
109: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
110: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
111: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
112: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
113: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
114: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
115: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
108: , ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
109: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
110: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
111: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
112: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
113: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
114: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
115: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
116: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
109: , ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
110: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
111: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
112: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
113: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
114: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
115: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
116: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
117: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
110: , ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
111: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
112: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
113: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
114: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
115: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
116: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
117: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
118: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
111: , ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
112: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
113: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
114: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
115: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
116: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
117: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
118: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
119: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
112: , ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
113: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
114: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
115: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
116: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
117: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
118: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
119: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
120: , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
113: , ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
114: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
115: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
116: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
117: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
118: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
119: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
120: , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
121: , ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
114: , ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
115: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
116: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
117: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
118: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
119: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
120: , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
121: , ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
122: );
115: , ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
116: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
117: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
118: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
119: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
120: , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
121: , ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
122: );
123:
116: , ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
117: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
118: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
119: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
120: , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
121: , ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
122: );
123:
124: TYPE Price_List_Line_Tbl_Type IS TABLE OF Price_List_Line_Rec_Type
117: , ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
118: , ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
119: , ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
120: , ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
121: , ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
122: );
123:
124: TYPE Price_List_Line_Tbl_Type IS TABLE OF Price_List_Line_Rec_Type
125: INDEX BY BINARY_INTEGER;
124: TYPE Price_List_Line_Tbl_Type IS TABLE OF Price_List_Line_Rec_Type
125: INDEX BY BINARY_INTEGER;
126:
127: TYPE Pricing_Attr_Rec_Type IS RECORD
128: ( list_line_id NUMBER := FND_API.G_MISS_NUM
129: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
130: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
131: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
132: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
125: INDEX BY BINARY_INTEGER;
126:
127: TYPE Pricing_Attr_Rec_Type IS RECORD
128: ( list_line_id NUMBER := FND_API.G_MISS_NUM
129: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
130: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
131: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
132: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
133: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
126:
127: TYPE Pricing_Attr_Rec_Type IS RECORD
128: ( list_line_id NUMBER := FND_API.G_MISS_NUM
129: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
130: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
131: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
132: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
133: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
134: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
127: TYPE Pricing_Attr_Rec_Type IS RECORD
128: ( list_line_id NUMBER := FND_API.G_MISS_NUM
129: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
130: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
131: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
132: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
133: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
134: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
135: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
128: ( list_line_id NUMBER := FND_API.G_MISS_NUM
129: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
130: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
131: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
132: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
133: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
134: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
135: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
136: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
129: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
130: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
131: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
132: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
133: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
134: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
135: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
136: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
137: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
130: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
131: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
132: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
133: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
134: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
135: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
136: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
137: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
138: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
131: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
132: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
133: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
134: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
135: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
136: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
137: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
138: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
139: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM
132: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
133: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
134: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
135: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
136: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
137: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
138: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
139: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM
140: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
133: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
134: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
135: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
136: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
137: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
138: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
139: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM
140: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141: , list_header_id NUMBER := FND_API.G_MISS_NUM
134: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
135: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
136: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
137: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
138: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
139: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM
140: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141: , list_header_id NUMBER := FND_API.G_MISS_NUM
142: );
135: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
136: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
137: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
138: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
139: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM
140: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141: , list_header_id NUMBER := FND_API.G_MISS_NUM
142: );
143:
136: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
137: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
138: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
139: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM
140: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141: , list_header_id NUMBER := FND_API.G_MISS_NUM
142: );
143:
144: TYPE Pricing_Attr_Tbl_Type IS TABLE OF Pricing_Attr_Rec_Type
137: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
138: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
139: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM
140: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141: , list_header_id NUMBER := FND_API.G_MISS_NUM
142: );
143:
144: TYPE Pricing_Attr_Tbl_Type IS TABLE OF Pricing_Attr_Rec_Type
145: INDEX BY BINARY_INTEGER;
145: INDEX BY BINARY_INTEGER;
146:
147: PROCEDURE process_price_list(
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
150: p_commit IN VARCHAR2 := FND_API.g_false,
151: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
146:
147: PROCEDURE process_price_list(
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
150: p_commit IN VARCHAR2 := FND_API.g_false,
151: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
147: PROCEDURE process_price_list(
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
150: p_commit IN VARCHAR2 := FND_API.g_false,
151: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
155: p_price_list_rec IN ozf_price_list_rec_type,
162: );
163:
164: PROCEDURE move_segments (
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
167: p_commit IN VARCHAR2 := FND_API.g_false,
168: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
163:
164: PROCEDURE move_segments (
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
167: p_commit IN VARCHAR2 := FND_API.g_false,
168: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
164: PROCEDURE move_segments (
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
167: p_commit IN VARCHAR2 := FND_API.g_false,
168: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_price_list_id IN NUMBER
183: TYPE num_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
184:
185: PROCEDURE add_inventory_item(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
188: p_commit IN VARCHAR2 := FND_API.g_false,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,
184:
185: PROCEDURE add_inventory_item(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
188: p_commit IN VARCHAR2 := FND_API.g_false,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,
192: p_org_inv_item_id IN NUMBER,