APPS.OE_PRICE_LIST_PUB dependencies on FND_API

Line 7: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR

3:
4: -- Price_List record type
5:
6: TYPE Price_List_Rec_Type IS RECORD
7: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
8: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
9: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
10: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 8: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

4: -- Price_List record type
5:
6: TYPE Price_List_Rec_Type IS RECORD
7: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
8: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
9: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
10: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 9: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR

5:
6: TYPE Price_List_Rec_Type IS RECORD
7: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
8: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
9: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
10: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 10: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

6: TYPE Price_List_Rec_Type IS RECORD
7: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
8: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
9: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
10: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 11: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

7: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
8: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
9: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
10: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 12: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

8: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
9: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
10: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 13: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

9: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
10: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 14: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

10: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 15: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

11: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 16: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

12: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 17: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

13: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 18: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

14: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , comments VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 19: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

15: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , comments VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 20: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

16: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , comments VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , created_by NUMBER := FND_API.G_MISS_NUM

Line 21: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

17: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , comments VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , created_by NUMBER := FND_API.G_MISS_NUM
25: , creation_date DATE := FND_API.G_MISS_DATE

Line 22: , comments VARCHAR2(240) := FND_API.G_MISS_CHAR

18: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , comments VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , created_by NUMBER := FND_API.G_MISS_NUM
25: , creation_date DATE := FND_API.G_MISS_DATE
26: , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR

Line 23: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

19: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , comments VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , created_by NUMBER := FND_API.G_MISS_NUM
25: , creation_date DATE := FND_API.G_MISS_DATE
26: , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
27: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR

Line 24: , created_by NUMBER := FND_API.G_MISS_NUM

20: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , comments VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , created_by NUMBER := FND_API.G_MISS_NUM
25: , creation_date DATE := FND_API.G_MISS_DATE
26: , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
27: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
28: , end_date_active DATE := FND_API.G_MISS_DATE

Line 25: , creation_date DATE := FND_API.G_MISS_DATE

21: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , comments VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , created_by NUMBER := FND_API.G_MISS_NUM
25: , creation_date DATE := FND_API.G_MISS_DATE
26: , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
27: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
28: , end_date_active DATE := FND_API.G_MISS_DATE
29: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 26: , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR

22: , comments VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , created_by NUMBER := FND_API.G_MISS_NUM
25: , creation_date DATE := FND_API.G_MISS_DATE
26: , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
27: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
28: , end_date_active DATE := FND_API.G_MISS_DATE
29: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 27: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR

23: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , created_by NUMBER := FND_API.G_MISS_NUM
25: , creation_date DATE := FND_API.G_MISS_DATE
26: , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
27: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
28: , end_date_active DATE := FND_API.G_MISS_DATE
29: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , last_updated_by NUMBER := FND_API.G_MISS_NUM
31: , last_update_date DATE := FND_API.G_MISS_DATE

Line 28: , end_date_active DATE := FND_API.G_MISS_DATE

24: , created_by NUMBER := FND_API.G_MISS_NUM
25: , creation_date DATE := FND_API.G_MISS_DATE
26: , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
27: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
28: , end_date_active DATE := FND_API.G_MISS_DATE
29: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , last_updated_by NUMBER := FND_API.G_MISS_NUM
31: , last_update_date DATE := FND_API.G_MISS_DATE
32: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 29: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR

25: , creation_date DATE := FND_API.G_MISS_DATE
26: , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
27: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
28: , end_date_active DATE := FND_API.G_MISS_DATE
29: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , last_updated_by NUMBER := FND_API.G_MISS_NUM
31: , last_update_date DATE := FND_API.G_MISS_DATE
32: , last_update_login NUMBER := FND_API.G_MISS_NUM
33: , name VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 30: , last_updated_by NUMBER := FND_API.G_MISS_NUM

26: , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
27: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
28: , end_date_active DATE := FND_API.G_MISS_DATE
29: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , last_updated_by NUMBER := FND_API.G_MISS_NUM
31: , last_update_date DATE := FND_API.G_MISS_DATE
32: , last_update_login NUMBER := FND_API.G_MISS_NUM
33: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
34: , price_list_id NUMBER := FND_API.G_MISS_NUM

Line 31: , last_update_date DATE := FND_API.G_MISS_DATE

27: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
28: , end_date_active DATE := FND_API.G_MISS_DATE
29: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , last_updated_by NUMBER := FND_API.G_MISS_NUM
31: , last_update_date DATE := FND_API.G_MISS_DATE
32: , last_update_login NUMBER := FND_API.G_MISS_NUM
33: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
34: , price_list_id NUMBER := FND_API.G_MISS_NUM
35: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM

Line 32: , last_update_login NUMBER := FND_API.G_MISS_NUM

28: , end_date_active DATE := FND_API.G_MISS_DATE
29: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , last_updated_by NUMBER := FND_API.G_MISS_NUM
31: , last_update_date DATE := FND_API.G_MISS_DATE
32: , last_update_login NUMBER := FND_API.G_MISS_NUM
33: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
34: , price_list_id NUMBER := FND_API.G_MISS_NUM
35: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
36: , program_application_id NUMBER := FND_API.G_MISS_NUM

Line 33: , name VARCHAR2(240) := FND_API.G_MISS_CHAR

29: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , last_updated_by NUMBER := FND_API.G_MISS_NUM
31: , last_update_date DATE := FND_API.G_MISS_DATE
32: , last_update_login NUMBER := FND_API.G_MISS_NUM
33: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
34: , price_list_id NUMBER := FND_API.G_MISS_NUM
35: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
36: , program_application_id NUMBER := FND_API.G_MISS_NUM
37: , program_id NUMBER := FND_API.G_MISS_NUM

Line 34: , price_list_id NUMBER := FND_API.G_MISS_NUM

30: , last_updated_by NUMBER := FND_API.G_MISS_NUM
31: , last_update_date DATE := FND_API.G_MISS_DATE
32: , last_update_login NUMBER := FND_API.G_MISS_NUM
33: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
34: , price_list_id NUMBER := FND_API.G_MISS_NUM
35: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
36: , program_application_id NUMBER := FND_API.G_MISS_NUM
37: , program_id NUMBER := FND_API.G_MISS_NUM
38: , program_update_date DATE := FND_API.G_MISS_DATE

Line 35: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM

31: , last_update_date DATE := FND_API.G_MISS_DATE
32: , last_update_login NUMBER := FND_API.G_MISS_NUM
33: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
34: , price_list_id NUMBER := FND_API.G_MISS_NUM
35: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
36: , program_application_id NUMBER := FND_API.G_MISS_NUM
37: , program_id NUMBER := FND_API.G_MISS_NUM
38: , program_update_date DATE := FND_API.G_MISS_DATE
39: , request_id NUMBER := FND_API.G_MISS_NUM

Line 36: , program_application_id NUMBER := FND_API.G_MISS_NUM

32: , last_update_login NUMBER := FND_API.G_MISS_NUM
33: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
34: , price_list_id NUMBER := FND_API.G_MISS_NUM
35: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
36: , program_application_id NUMBER := FND_API.G_MISS_NUM
37: , program_id NUMBER := FND_API.G_MISS_NUM
38: , program_update_date DATE := FND_API.G_MISS_DATE
39: , request_id NUMBER := FND_API.G_MISS_NUM
40: , rounding_factor NUMBER := FND_API.G_MISS_NUM

Line 37: , program_id NUMBER := FND_API.G_MISS_NUM

33: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
34: , price_list_id NUMBER := FND_API.G_MISS_NUM
35: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
36: , program_application_id NUMBER := FND_API.G_MISS_NUM
37: , program_id NUMBER := FND_API.G_MISS_NUM
38: , program_update_date DATE := FND_API.G_MISS_DATE
39: , request_id NUMBER := FND_API.G_MISS_NUM
40: , rounding_factor NUMBER := FND_API.G_MISS_NUM
41: , secondary_price_list_id NUMBER := FND_API.G_MISS_NUM

Line 38: , program_update_date DATE := FND_API.G_MISS_DATE

34: , price_list_id NUMBER := FND_API.G_MISS_NUM
35: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
36: , program_application_id NUMBER := FND_API.G_MISS_NUM
37: , program_id NUMBER := FND_API.G_MISS_NUM
38: , program_update_date DATE := FND_API.G_MISS_DATE
39: , request_id NUMBER := FND_API.G_MISS_NUM
40: , rounding_factor NUMBER := FND_API.G_MISS_NUM
41: , secondary_price_list_id NUMBER := FND_API.G_MISS_NUM
42: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 39: , request_id NUMBER := FND_API.G_MISS_NUM

35: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
36: , program_application_id NUMBER := FND_API.G_MISS_NUM
37: , program_id NUMBER := FND_API.G_MISS_NUM
38: , program_update_date DATE := FND_API.G_MISS_DATE
39: , request_id NUMBER := FND_API.G_MISS_NUM
40: , rounding_factor NUMBER := FND_API.G_MISS_NUM
41: , secondary_price_list_id NUMBER := FND_API.G_MISS_NUM
42: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
43: , start_date_active DATE := FND_API.G_MISS_DATE

Line 40: , rounding_factor NUMBER := FND_API.G_MISS_NUM

36: , program_application_id NUMBER := FND_API.G_MISS_NUM
37: , program_id NUMBER := FND_API.G_MISS_NUM
38: , program_update_date DATE := FND_API.G_MISS_DATE
39: , request_id NUMBER := FND_API.G_MISS_NUM
40: , rounding_factor NUMBER := FND_API.G_MISS_NUM
41: , secondary_price_list_id NUMBER := FND_API.G_MISS_NUM
42: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
43: , start_date_active DATE := FND_API.G_MISS_DATE
44: , terms_id NUMBER := FND_API.G_MISS_NUM

Line 41: , secondary_price_list_id NUMBER := FND_API.G_MISS_NUM

37: , program_id NUMBER := FND_API.G_MISS_NUM
38: , program_update_date DATE := FND_API.G_MISS_DATE
39: , request_id NUMBER := FND_API.G_MISS_NUM
40: , rounding_factor NUMBER := FND_API.G_MISS_NUM
41: , secondary_price_list_id NUMBER := FND_API.G_MISS_NUM
42: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
43: , start_date_active DATE := FND_API.G_MISS_DATE
44: , terms_id NUMBER := FND_API.G_MISS_NUM
45: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 42: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR

38: , program_update_date DATE := FND_API.G_MISS_DATE
39: , request_id NUMBER := FND_API.G_MISS_NUM
40: , rounding_factor NUMBER := FND_API.G_MISS_NUM
41: , secondary_price_list_id NUMBER := FND_API.G_MISS_NUM
42: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
43: , start_date_active DATE := FND_API.G_MISS_DATE
44: , terms_id NUMBER := FND_API.G_MISS_NUM
45: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
46: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 43: , start_date_active DATE := FND_API.G_MISS_DATE

39: , request_id NUMBER := FND_API.G_MISS_NUM
40: , rounding_factor NUMBER := FND_API.G_MISS_NUM
41: , secondary_price_list_id NUMBER := FND_API.G_MISS_NUM
42: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
43: , start_date_active DATE := FND_API.G_MISS_DATE
44: , terms_id NUMBER := FND_API.G_MISS_NUM
45: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
46: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
47: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 44: , terms_id NUMBER := FND_API.G_MISS_NUM

40: , rounding_factor NUMBER := FND_API.G_MISS_NUM
41: , secondary_price_list_id NUMBER := FND_API.G_MISS_NUM
42: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
43: , start_date_active DATE := FND_API.G_MISS_DATE
44: , terms_id NUMBER := FND_API.G_MISS_NUM
45: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
46: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
47: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 45: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

41: , secondary_price_list_id NUMBER := FND_API.G_MISS_NUM
42: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
43: , start_date_active DATE := FND_API.G_MISS_DATE
44: , terms_id NUMBER := FND_API.G_MISS_NUM
45: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
46: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
47: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
49: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 46: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

42: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
43: , start_date_active DATE := FND_API.G_MISS_DATE
44: , terms_id NUMBER := FND_API.G_MISS_NUM
45: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
46: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
47: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
49: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
50: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 47: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

43: , start_date_active DATE := FND_API.G_MISS_DATE
44: , terms_id NUMBER := FND_API.G_MISS_NUM
45: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
46: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
47: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
49: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
50: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
51: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 48: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR

44: , terms_id NUMBER := FND_API.G_MISS_NUM
45: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
46: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
47: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
49: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
50: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
51: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
52: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 49: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

45: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
46: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
47: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
49: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
50: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
51: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
52: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
53: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 50: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

46: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
47: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
49: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
50: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
51: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
52: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
53: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
54: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 51: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

47: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
49: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
50: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
51: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
52: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
53: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
54: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
55: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 52: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

48: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
49: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
50: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
51: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
52: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
53: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
54: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
55: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
56: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 53: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

49: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
50: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
51: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
52: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
53: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
54: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
55: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
56: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
57: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 54: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

50: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
51: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
52: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
53: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
54: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
55: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
56: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
57: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 55: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

51: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
52: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
53: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
54: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
55: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
56: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
57: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
59: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 56: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

52: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
53: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
54: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
55: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
56: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
57: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
59: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
60: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 57: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

53: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
54: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
55: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
56: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
57: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
59: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
60: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
61: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 58: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR

54: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
55: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
56: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
57: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
59: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
60: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
61: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
62: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 59: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

55: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
56: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
57: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
59: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
60: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
61: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
62: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
63: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 60: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

56: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
57: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
59: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
60: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
61: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
62: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
63: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
64: , currency_header_id NUMBER := FND_API.G_MISS_NUM -- Multi-Currency SunilPandey

Line 61: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

57: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
59: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
60: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
61: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
62: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
63: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
64: , currency_header_id NUMBER := FND_API.G_MISS_NUM -- Multi-Currency SunilPandey
65: );

Line 62: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

58: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
59: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
60: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
61: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
62: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
63: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
64: , currency_header_id NUMBER := FND_API.G_MISS_NUM -- Multi-Currency SunilPandey
65: );
66:

Line 63: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR

59: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
60: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
61: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
62: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
63: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
64: , currency_header_id NUMBER := FND_API.G_MISS_NUM -- Multi-Currency SunilPandey
65: );
66:
67: TYPE Price_List_Tbl_Type IS TABLE OF Price_List_Rec_Type

Line 64: , currency_header_id NUMBER := FND_API.G_MISS_NUM -- Multi-Currency SunilPandey

60: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
61: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
62: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
63: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
64: , currency_header_id NUMBER := FND_API.G_MISS_NUM -- Multi-Currency SunilPandey
65: );
66:
67: TYPE Price_List_Tbl_Type IS TABLE OF Price_List_Rec_Type
68: INDEX BY BINARY_INTEGER;

Line 73: ( currency VARCHAR2(240) := FND_API.G_MISS_CHAR

69:
70: -- Price_List value record type
71:
72: TYPE Price_List_Val_Rec_Type IS RECORD
73: ( currency VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , secondary_price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 74: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR

70: -- Price_List value record type
71:
72: TYPE Price_List_Val_Rec_Type IS RECORD
73: ( currency VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , secondary_price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 75: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR

71:
72: TYPE Price_List_Val_Rec_Type IS RECORD
73: ( currency VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , secondary_price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
79: );

Line 76: , secondary_price_list VARCHAR2(240) := FND_API.G_MISS_CHAR

72: TYPE Price_List_Val_Rec_Type IS RECORD
73: ( currency VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , secondary_price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
79: );
80:

Line 77: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR

73: ( currency VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , secondary_price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
79: );
80:
81: TYPE Price_List_Val_Tbl_Type IS TABLE OF Price_List_Val_Rec_Type

Line 78: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR

74: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , secondary_price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
79: );
80:
81: TYPE Price_List_Val_Tbl_Type IS TABLE OF Price_List_Val_Rec_Type
82: INDEX BY BINARY_INTEGER;

Line 87: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR

83:
84: -- Price_List_Line record type
85:
86: TYPE Price_List_Line_Rec_Type IS RECORD
87: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 88: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

84: -- Price_List_Line record type
85:
86: TYPE Price_List_Line_Rec_Type IS RECORD
87: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 89: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR

85:
86: TYPE Price_List_Line_Rec_Type IS RECORD
87: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 90: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

86: TYPE Price_List_Line_Rec_Type IS RECORD
87: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 91: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

87: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 92: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

88: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 93: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

89: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 94: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

90: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 95: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

91: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 96: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

92: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 97: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

93: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 98: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

94: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR

Line 99: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

95: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
103: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 100: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

96: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
103: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
104: , created_by NUMBER := FND_API.G_MISS_NUM

Line 101: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

97: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
103: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
104: , created_by NUMBER := FND_API.G_MISS_NUM
105: , creation_date DATE := FND_API.G_MISS_DATE

Line 102: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR

98: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
103: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
104: , created_by NUMBER := FND_API.G_MISS_NUM
105: , creation_date DATE := FND_API.G_MISS_DATE
106: , customer_item_id NUMBER := FND_API.G_MISS_NUM

Line 103: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

99: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
103: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
104: , created_by NUMBER := FND_API.G_MISS_NUM
105: , creation_date DATE := FND_API.G_MISS_DATE
106: , customer_item_id NUMBER := FND_API.G_MISS_NUM
107: , end_date_active DATE := FND_API.G_MISS_DATE

Line 104: , created_by NUMBER := FND_API.G_MISS_NUM

100: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
103: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
104: , created_by NUMBER := FND_API.G_MISS_NUM
105: , creation_date DATE := FND_API.G_MISS_DATE
106: , customer_item_id NUMBER := FND_API.G_MISS_NUM
107: , end_date_active DATE := FND_API.G_MISS_DATE
108: , inventory_item_id NUMBER := FND_API.G_MISS_NUM

Line 105: , creation_date DATE := FND_API.G_MISS_DATE

101: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
103: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
104: , created_by NUMBER := FND_API.G_MISS_NUM
105: , creation_date DATE := FND_API.G_MISS_DATE
106: , customer_item_id NUMBER := FND_API.G_MISS_NUM
107: , end_date_active DATE := FND_API.G_MISS_DATE
108: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
109: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 106: , customer_item_id NUMBER := FND_API.G_MISS_NUM

102: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
103: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
104: , created_by NUMBER := FND_API.G_MISS_NUM
105: , creation_date DATE := FND_API.G_MISS_DATE
106: , customer_item_id NUMBER := FND_API.G_MISS_NUM
107: , end_date_active DATE := FND_API.G_MISS_DATE
108: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
109: , last_updated_by NUMBER := FND_API.G_MISS_NUM
110: , last_update_date DATE := FND_API.G_MISS_DATE

Line 107: , end_date_active DATE := FND_API.G_MISS_DATE

103: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
104: , created_by NUMBER := FND_API.G_MISS_NUM
105: , creation_date DATE := FND_API.G_MISS_DATE
106: , customer_item_id NUMBER := FND_API.G_MISS_NUM
107: , end_date_active DATE := FND_API.G_MISS_DATE
108: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
109: , last_updated_by NUMBER := FND_API.G_MISS_NUM
110: , last_update_date DATE := FND_API.G_MISS_DATE
111: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 108: , inventory_item_id NUMBER := FND_API.G_MISS_NUM

104: , created_by NUMBER := FND_API.G_MISS_NUM
105: , creation_date DATE := FND_API.G_MISS_DATE
106: , customer_item_id NUMBER := FND_API.G_MISS_NUM
107: , end_date_active DATE := FND_API.G_MISS_DATE
108: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
109: , last_updated_by NUMBER := FND_API.G_MISS_NUM
110: , last_update_date DATE := FND_API.G_MISS_DATE
111: , last_update_login NUMBER := FND_API.G_MISS_NUM
112: , list_price NUMBER := FND_API.G_MISS_NUM

Line 109: , last_updated_by NUMBER := FND_API.G_MISS_NUM

105: , creation_date DATE := FND_API.G_MISS_DATE
106: , customer_item_id NUMBER := FND_API.G_MISS_NUM
107: , end_date_active DATE := FND_API.G_MISS_DATE
108: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
109: , last_updated_by NUMBER := FND_API.G_MISS_NUM
110: , last_update_date DATE := FND_API.G_MISS_DATE
111: , last_update_login NUMBER := FND_API.G_MISS_NUM
112: , list_price NUMBER := FND_API.G_MISS_NUM
113: , method_code VARCHAR2(4) := FND_API.G_MISS_CHAR

Line 110: , last_update_date DATE := FND_API.G_MISS_DATE

106: , customer_item_id NUMBER := FND_API.G_MISS_NUM
107: , end_date_active DATE := FND_API.G_MISS_DATE
108: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
109: , last_updated_by NUMBER := FND_API.G_MISS_NUM
110: , last_update_date DATE := FND_API.G_MISS_DATE
111: , last_update_login NUMBER := FND_API.G_MISS_NUM
112: , list_price NUMBER := FND_API.G_MISS_NUM
113: , method_code VARCHAR2(4) := FND_API.G_MISS_CHAR
114: , price_list_id NUMBER := FND_API.G_MISS_NUM

Line 111: , last_update_login NUMBER := FND_API.G_MISS_NUM

107: , end_date_active DATE := FND_API.G_MISS_DATE
108: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
109: , last_updated_by NUMBER := FND_API.G_MISS_NUM
110: , last_update_date DATE := FND_API.G_MISS_DATE
111: , last_update_login NUMBER := FND_API.G_MISS_NUM
112: , list_price NUMBER := FND_API.G_MISS_NUM
113: , method_code VARCHAR2(4) := FND_API.G_MISS_CHAR
114: , price_list_id NUMBER := FND_API.G_MISS_NUM
115: , price_list_line_id NUMBER := FND_API.G_MISS_NUM

Line 112: , list_price NUMBER := FND_API.G_MISS_NUM

108: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
109: , last_updated_by NUMBER := FND_API.G_MISS_NUM
110: , last_update_date DATE := FND_API.G_MISS_DATE
111: , last_update_login NUMBER := FND_API.G_MISS_NUM
112: , list_price NUMBER := FND_API.G_MISS_NUM
113: , method_code VARCHAR2(4) := FND_API.G_MISS_CHAR
114: , price_list_id NUMBER := FND_API.G_MISS_NUM
115: , price_list_line_id NUMBER := FND_API.G_MISS_NUM
116: , pricing_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 113: , method_code VARCHAR2(4) := FND_API.G_MISS_CHAR

109: , last_updated_by NUMBER := FND_API.G_MISS_NUM
110: , last_update_date DATE := FND_API.G_MISS_DATE
111: , last_update_login NUMBER := FND_API.G_MISS_NUM
112: , list_price NUMBER := FND_API.G_MISS_NUM
113: , method_code VARCHAR2(4) := FND_API.G_MISS_CHAR
114: , price_list_id NUMBER := FND_API.G_MISS_NUM
115: , price_list_line_id NUMBER := FND_API.G_MISS_NUM
116: , pricing_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , pricing_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 114: , price_list_id NUMBER := FND_API.G_MISS_NUM

110: , last_update_date DATE := FND_API.G_MISS_DATE
111: , last_update_login NUMBER := FND_API.G_MISS_NUM
112: , list_price NUMBER := FND_API.G_MISS_NUM
113: , method_code VARCHAR2(4) := FND_API.G_MISS_CHAR
114: , price_list_id NUMBER := FND_API.G_MISS_NUM
115: , price_list_line_id NUMBER := FND_API.G_MISS_NUM
116: , pricing_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , pricing_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , pricing_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 115: , price_list_line_id NUMBER := FND_API.G_MISS_NUM

111: , last_update_login NUMBER := FND_API.G_MISS_NUM
112: , list_price NUMBER := FND_API.G_MISS_NUM
113: , method_code VARCHAR2(4) := FND_API.G_MISS_CHAR
114: , price_list_id NUMBER := FND_API.G_MISS_NUM
115: , price_list_line_id NUMBER := FND_API.G_MISS_NUM
116: , pricing_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , pricing_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , pricing_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , pricing_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 116: , pricing_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR

112: , list_price NUMBER := FND_API.G_MISS_NUM
113: , method_code VARCHAR2(4) := FND_API.G_MISS_CHAR
114: , price_list_id NUMBER := FND_API.G_MISS_NUM
115: , price_list_line_id NUMBER := FND_API.G_MISS_NUM
116: , pricing_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , pricing_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , pricing_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , pricing_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , pricing_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 117: , pricing_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

113: , method_code VARCHAR2(4) := FND_API.G_MISS_CHAR
114: , price_list_id NUMBER := FND_API.G_MISS_NUM
115: , price_list_line_id NUMBER := FND_API.G_MISS_NUM
116: , pricing_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , pricing_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , pricing_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , pricing_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , pricing_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , pricing_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 118: , pricing_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR

114: , price_list_id NUMBER := FND_API.G_MISS_NUM
115: , price_list_line_id NUMBER := FND_API.G_MISS_NUM
116: , pricing_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , pricing_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , pricing_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , pricing_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , pricing_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , pricing_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , pricing_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 119: , pricing_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

115: , price_list_line_id NUMBER := FND_API.G_MISS_NUM
116: , pricing_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , pricing_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , pricing_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , pricing_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , pricing_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , pricing_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , pricing_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
123: , pricing_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 120: , pricing_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

116: , pricing_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , pricing_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , pricing_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , pricing_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , pricing_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , pricing_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , pricing_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
123: , pricing_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
124: , pricing_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 121: , pricing_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

117: , pricing_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , pricing_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , pricing_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , pricing_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , pricing_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , pricing_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
123: , pricing_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
124: , pricing_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
125: , pricing_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 122: , pricing_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

118: , pricing_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , pricing_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , pricing_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , pricing_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , pricing_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
123: , pricing_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
124: , pricing_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
125: , pricing_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
126: , pricing_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 123: , pricing_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

119: , pricing_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , pricing_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , pricing_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , pricing_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
123: , pricing_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
124: , pricing_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
125: , pricing_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
126: , pricing_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
127: , pricing_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 124: , pricing_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

120: , pricing_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , pricing_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , pricing_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
123: , pricing_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
124: , pricing_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
125: , pricing_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
126: , pricing_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
127: , pricing_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
128: , pricing_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 125: , pricing_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

121: , pricing_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , pricing_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
123: , pricing_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
124: , pricing_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
125: , pricing_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
126: , pricing_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
127: , pricing_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
128: , pricing_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
129: , pricing_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 126: , pricing_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

122: , pricing_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
123: , pricing_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
124: , pricing_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
125: , pricing_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
126: , pricing_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
127: , pricing_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
128: , pricing_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
129: , pricing_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
130: , pricing_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 127: , pricing_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

123: , pricing_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
124: , pricing_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
125: , pricing_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
126: , pricing_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
127: , pricing_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
128: , pricing_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
129: , pricing_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
130: , pricing_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
131: , pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 128: , pricing_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

124: , pricing_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
125: , pricing_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
126: , pricing_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
127: , pricing_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
128: , pricing_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
129: , pricing_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
130: , pricing_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
131: , pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR
132: , pricing_rule_id NUMBER := FND_API.G_MISS_NUM

Line 129: , pricing_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

125: , pricing_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
126: , pricing_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
127: , pricing_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
128: , pricing_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
129: , pricing_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
130: , pricing_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
131: , pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR
132: , pricing_rule_id NUMBER := FND_API.G_MISS_NUM
133: , primary VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 130: , pricing_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

126: , pricing_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
127: , pricing_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
128: , pricing_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
129: , pricing_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
130: , pricing_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
131: , pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR
132: , pricing_rule_id NUMBER := FND_API.G_MISS_NUM
133: , primary VARCHAR2(30) := FND_API.G_MISS_CHAR
134: , program_application_id NUMBER := FND_API.G_MISS_NUM

Line 131: , pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR

127: , pricing_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
128: , pricing_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
129: , pricing_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
130: , pricing_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
131: , pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR
132: , pricing_rule_id NUMBER := FND_API.G_MISS_NUM
133: , primary VARCHAR2(30) := FND_API.G_MISS_CHAR
134: , program_application_id NUMBER := FND_API.G_MISS_NUM
135: , program_id NUMBER := FND_API.G_MISS_NUM

Line 132: , pricing_rule_id NUMBER := FND_API.G_MISS_NUM

128: , pricing_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
129: , pricing_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
130: , pricing_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
131: , pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR
132: , pricing_rule_id NUMBER := FND_API.G_MISS_NUM
133: , primary VARCHAR2(30) := FND_API.G_MISS_CHAR
134: , program_application_id NUMBER := FND_API.G_MISS_NUM
135: , program_id NUMBER := FND_API.G_MISS_NUM
136: , program_update_date DATE := FND_API.G_MISS_DATE

Line 133: , primary VARCHAR2(30) := FND_API.G_MISS_CHAR

129: , pricing_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
130: , pricing_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
131: , pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR
132: , pricing_rule_id NUMBER := FND_API.G_MISS_NUM
133: , primary VARCHAR2(30) := FND_API.G_MISS_CHAR
134: , program_application_id NUMBER := FND_API.G_MISS_NUM
135: , program_id NUMBER := FND_API.G_MISS_NUM
136: , program_update_date DATE := FND_API.G_MISS_DATE
137: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 134: , program_application_id NUMBER := FND_API.G_MISS_NUM

130: , pricing_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
131: , pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR
132: , pricing_rule_id NUMBER := FND_API.G_MISS_NUM
133: , primary VARCHAR2(30) := FND_API.G_MISS_CHAR
134: , program_application_id NUMBER := FND_API.G_MISS_NUM
135: , program_id NUMBER := FND_API.G_MISS_NUM
136: , program_update_date DATE := FND_API.G_MISS_DATE
137: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
138: , request_id NUMBER := FND_API.G_MISS_NUM

Line 135: , program_id NUMBER := FND_API.G_MISS_NUM

131: , pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR
132: , pricing_rule_id NUMBER := FND_API.G_MISS_NUM
133: , primary VARCHAR2(30) := FND_API.G_MISS_CHAR
134: , program_application_id NUMBER := FND_API.G_MISS_NUM
135: , program_id NUMBER := FND_API.G_MISS_NUM
136: , program_update_date DATE := FND_API.G_MISS_DATE
137: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
138: , request_id NUMBER := FND_API.G_MISS_NUM
139: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR

Line 136: , program_update_date DATE := FND_API.G_MISS_DATE

132: , pricing_rule_id NUMBER := FND_API.G_MISS_NUM
133: , primary VARCHAR2(30) := FND_API.G_MISS_CHAR
134: , program_application_id NUMBER := FND_API.G_MISS_NUM
135: , program_id NUMBER := FND_API.G_MISS_NUM
136: , program_update_date DATE := FND_API.G_MISS_DATE
137: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
138: , request_id NUMBER := FND_API.G_MISS_NUM
139: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
140: , revision_date DATE := FND_API.G_MISS_DATE

Line 137: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

133: , primary VARCHAR2(30) := FND_API.G_MISS_CHAR
134: , program_application_id NUMBER := FND_API.G_MISS_NUM
135: , program_id NUMBER := FND_API.G_MISS_NUM
136: , program_update_date DATE := FND_API.G_MISS_DATE
137: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
138: , request_id NUMBER := FND_API.G_MISS_NUM
139: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
140: , revision_date DATE := FND_API.G_MISS_DATE
141: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 138: , request_id NUMBER := FND_API.G_MISS_NUM

134: , program_application_id NUMBER := FND_API.G_MISS_NUM
135: , program_id NUMBER := FND_API.G_MISS_NUM
136: , program_update_date DATE := FND_API.G_MISS_DATE
137: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
138: , request_id NUMBER := FND_API.G_MISS_NUM
139: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
140: , revision_date DATE := FND_API.G_MISS_DATE
141: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , start_date_active DATE := FND_API.G_MISS_DATE

Line 139: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR

135: , program_id NUMBER := FND_API.G_MISS_NUM
136: , program_update_date DATE := FND_API.G_MISS_DATE
137: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
138: , request_id NUMBER := FND_API.G_MISS_NUM
139: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
140: , revision_date DATE := FND_API.G_MISS_DATE
141: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , start_date_active DATE := FND_API.G_MISS_DATE
143: , unit_code VARCHAR2(3) := FND_API.G_MISS_CHAR

Line 140: , revision_date DATE := FND_API.G_MISS_DATE

136: , program_update_date DATE := FND_API.G_MISS_DATE
137: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
138: , request_id NUMBER := FND_API.G_MISS_NUM
139: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
140: , revision_date DATE := FND_API.G_MISS_DATE
141: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , start_date_active DATE := FND_API.G_MISS_DATE
143: , unit_code VARCHAR2(3) := FND_API.G_MISS_CHAR
144: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 141: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR

137: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
138: , request_id NUMBER := FND_API.G_MISS_NUM
139: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
140: , revision_date DATE := FND_API.G_MISS_DATE
141: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , start_date_active DATE := FND_API.G_MISS_DATE
143: , unit_code VARCHAR2(3) := FND_API.G_MISS_CHAR
144: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 142: , start_date_active DATE := FND_API.G_MISS_DATE

138: , request_id NUMBER := FND_API.G_MISS_NUM
139: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
140: , revision_date DATE := FND_API.G_MISS_DATE
141: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , start_date_active DATE := FND_API.G_MISS_DATE
143: , unit_code VARCHAR2(3) := FND_API.G_MISS_CHAR
144: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 143: , unit_code VARCHAR2(3) := FND_API.G_MISS_CHAR

139: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
140: , revision_date DATE := FND_API.G_MISS_DATE
141: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , start_date_active DATE := FND_API.G_MISS_DATE
143: , unit_code VARCHAR2(3) := FND_API.G_MISS_CHAR
144: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
147: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 144: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

140: , revision_date DATE := FND_API.G_MISS_DATE
141: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , start_date_active DATE := FND_API.G_MISS_DATE
143: , unit_code VARCHAR2(3) := FND_API.G_MISS_CHAR
144: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
147: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 145: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

141: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , start_date_active DATE := FND_API.G_MISS_DATE
143: , unit_code VARCHAR2(3) := FND_API.G_MISS_CHAR
144: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
147: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 146: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

142: , start_date_active DATE := FND_API.G_MISS_DATE
143: , unit_code VARCHAR2(3) := FND_API.G_MISS_CHAR
144: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
147: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 147: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR

143: , unit_code VARCHAR2(3) := FND_API.G_MISS_CHAR
144: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
147: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 148: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

144: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
147: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 149: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

145: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
147: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 150: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

146: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
147: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 151: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

147: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 152: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

148: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 153: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

149: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
157: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 154: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

150: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
157: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
158: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 155: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

151: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
157: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
158: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
159: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 156: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

152: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
157: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
158: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
159: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
160: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 157: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR

153: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
157: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
158: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
159: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
160: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
161: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 158: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

154: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
157: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
158: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
159: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
160: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
161: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
162: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 159: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

155: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
157: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
158: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
159: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
160: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
161: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
162: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , method_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 160: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

156: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
157: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
158: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
159: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
160: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
161: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
162: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , method_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
164: , price_break_high NUMBER := FND_API.G_MISS_NUM

Line 161: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

157: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
158: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
159: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
160: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
161: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
162: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , method_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
164: , price_break_high NUMBER := FND_API.G_MISS_NUM
165: , price_break_low NUMBER := FND_API.G_MISS_NUM

Line 162: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR

158: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
159: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
160: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
161: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
162: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , method_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
164: , price_break_high NUMBER := FND_API.G_MISS_NUM
165: , price_break_low NUMBER := FND_API.G_MISS_NUM
166: , price_break_parent_line NUMBER := FND_API.G_MISS_NUM

Line 163: , method_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

159: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
160: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
161: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
162: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , method_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
164: , price_break_high NUMBER := FND_API.G_MISS_NUM
165: , price_break_low NUMBER := FND_API.G_MISS_NUM
166: , price_break_parent_line NUMBER := FND_API.G_MISS_NUM
167: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 164: , price_break_high NUMBER := FND_API.G_MISS_NUM

160: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
161: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
162: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , method_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
164: , price_break_high NUMBER := FND_API.G_MISS_NUM
165: , price_break_low NUMBER := FND_API.G_MISS_NUM
166: , price_break_parent_line NUMBER := FND_API.G_MISS_NUM
167: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
168: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 165: , price_break_low NUMBER := FND_API.G_MISS_NUM

161: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
162: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , method_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
164: , price_break_high NUMBER := FND_API.G_MISS_NUM
165: , price_break_low NUMBER := FND_API.G_MISS_NUM
166: , price_break_parent_line NUMBER := FND_API.G_MISS_NUM
167: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
168: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
169: );

Line 166: , price_break_parent_line NUMBER := FND_API.G_MISS_NUM

162: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , method_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
164: , price_break_high NUMBER := FND_API.G_MISS_NUM
165: , price_break_low NUMBER := FND_API.G_MISS_NUM
166: , price_break_parent_line NUMBER := FND_API.G_MISS_NUM
167: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
168: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
169: );
170:

Line 167: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

163: , method_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
164: , price_break_high NUMBER := FND_API.G_MISS_NUM
165: , price_break_low NUMBER := FND_API.G_MISS_NUM
166: , price_break_parent_line NUMBER := FND_API.G_MISS_NUM
167: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
168: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
169: );
170:
171: TYPE Price_List_Line_Tbl_Type IS TABLE OF Price_List_Line_Rec_Type

Line 168: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

164: , price_break_high NUMBER := FND_API.G_MISS_NUM
165: , price_break_low NUMBER := FND_API.G_MISS_NUM
166: , price_break_parent_line NUMBER := FND_API.G_MISS_NUM
167: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
168: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
169: );
170:
171: TYPE Price_List_Line_Tbl_Type IS TABLE OF Price_List_Line_Rec_Type
172: INDEX BY BINARY_INTEGER;

Line 177: ( customer_item VARCHAR2(240) := FND_API.G_MISS_CHAR

173:
174: -- Price_List_Line value record type
175:
176: TYPE Price_List_Line_Val_Rec_Type IS RECORD
177: ( customer_item VARCHAR2(240) := FND_API.G_MISS_CHAR
178: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
179: , method VARCHAR2(240) := FND_API.G_MISS_CHAR
180: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
181: , price_list_line VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 178: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR

174: -- Price_List_Line value record type
175:
176: TYPE Price_List_Line_Val_Rec_Type IS RECORD
177: ( customer_item VARCHAR2(240) := FND_API.G_MISS_CHAR
178: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
179: , method VARCHAR2(240) := FND_API.G_MISS_CHAR
180: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
181: , price_list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
182: , pricing_rule VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 179: , method VARCHAR2(240) := FND_API.G_MISS_CHAR

175:
176: TYPE Price_List_Line_Val_Rec_Type IS RECORD
177: ( customer_item VARCHAR2(240) := FND_API.G_MISS_CHAR
178: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
179: , method VARCHAR2(240) := FND_API.G_MISS_CHAR
180: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
181: , price_list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
182: , pricing_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
183: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 180: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR

176: TYPE Price_List_Line_Val_Rec_Type IS RECORD
177: ( customer_item VARCHAR2(240) := FND_API.G_MISS_CHAR
178: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
179: , method VARCHAR2(240) := FND_API.G_MISS_CHAR
180: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
181: , price_list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
182: , pricing_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
183: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
184: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 181: , price_list_line VARCHAR2(240) := FND_API.G_MISS_CHAR

177: ( customer_item VARCHAR2(240) := FND_API.G_MISS_CHAR
178: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
179: , method VARCHAR2(240) := FND_API.G_MISS_CHAR
180: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
181: , price_list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
182: , pricing_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
183: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
184: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
185: , unit VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 182: , pricing_rule VARCHAR2(240) := FND_API.G_MISS_CHAR

178: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
179: , method VARCHAR2(240) := FND_API.G_MISS_CHAR
180: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
181: , price_list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
182: , pricing_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
183: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
184: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
185: , unit VARCHAR2(240) := FND_API.G_MISS_CHAR
186: );

Line 183: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR

179: , method VARCHAR2(240) := FND_API.G_MISS_CHAR
180: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
181: , price_list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
182: , pricing_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
183: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
184: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
185: , unit VARCHAR2(240) := FND_API.G_MISS_CHAR
186: );
187:

Line 184: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR

180: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
181: , price_list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
182: , pricing_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
183: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
184: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
185: , unit VARCHAR2(240) := FND_API.G_MISS_CHAR
186: );
187:
188: TYPE Price_List_Line_Val_Tbl_Type IS TABLE OF Price_List_Line_Val_Rec_Type

Line 185: , unit VARCHAR2(240) := FND_API.G_MISS_CHAR

181: , price_list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
182: , pricing_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
183: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
184: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
185: , unit VARCHAR2(240) := FND_API.G_MISS_CHAR
186: );
187:
188: TYPE Price_List_Line_Val_Tbl_Type IS TABLE OF Price_List_Line_Val_Rec_Type
189: INDEX BY BINARY_INTEGER;

Line 194: ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

190:
191: -- Pricing_Attr record type
192:
193: TYPE Pricing_Attr_Rec_Type IS RECORD
194: ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
195: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 195: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR

191: -- Pricing_Attr record type
192:
193: TYPE Pricing_Attr_Rec_Type IS RECORD
194: ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
195: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 196: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

192:
193: TYPE Pricing_Attr_Rec_Type IS RECORD
194: ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
195: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 197: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR

193: TYPE Pricing_Attr_Rec_Type IS RECORD
194: ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
195: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 198: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

194: ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
195: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 199: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

195: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 200: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

196: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 201: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

197: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 202: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

198: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 203: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

199: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 204: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

200: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 205: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

201: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 206: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

202: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM

Line 207: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

203: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
211: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 208: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

204: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
211: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
212: , created_by NUMBER := FND_API.G_MISS_NUM

Line 209: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

205: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
211: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
212: , created_by NUMBER := FND_API.G_MISS_NUM
213: , creation_date DATE := FND_API.G_MISS_DATE

Line 210: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM

206: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
211: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
212: , created_by NUMBER := FND_API.G_MISS_NUM
213: , creation_date DATE := FND_API.G_MISS_DATE
214: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 211: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

207: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
211: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
212: , created_by NUMBER := FND_API.G_MISS_NUM
213: , creation_date DATE := FND_API.G_MISS_DATE
214: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
215: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 212: , created_by NUMBER := FND_API.G_MISS_NUM

208: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
211: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
212: , created_by NUMBER := FND_API.G_MISS_NUM
213: , creation_date DATE := FND_API.G_MISS_DATE
214: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
215: , last_updated_by NUMBER := FND_API.G_MISS_NUM
216: , last_update_date DATE := FND_API.G_MISS_DATE

Line 213: , creation_date DATE := FND_API.G_MISS_DATE

209: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
211: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
212: , created_by NUMBER := FND_API.G_MISS_NUM
213: , creation_date DATE := FND_API.G_MISS_DATE
214: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
215: , last_updated_by NUMBER := FND_API.G_MISS_NUM
216: , last_update_date DATE := FND_API.G_MISS_DATE
217: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 214: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

210: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
211: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
212: , created_by NUMBER := FND_API.G_MISS_NUM
213: , creation_date DATE := FND_API.G_MISS_DATE
214: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
215: , last_updated_by NUMBER := FND_API.G_MISS_NUM
216: , last_update_date DATE := FND_API.G_MISS_DATE
217: , last_update_login NUMBER := FND_API.G_MISS_NUM
218: , list_line_id NUMBER := FND_API.G_MISS_NUM

Line 215: , last_updated_by NUMBER := FND_API.G_MISS_NUM

211: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
212: , created_by NUMBER := FND_API.G_MISS_NUM
213: , creation_date DATE := FND_API.G_MISS_DATE
214: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
215: , last_updated_by NUMBER := FND_API.G_MISS_NUM
216: , last_update_date DATE := FND_API.G_MISS_DATE
217: , last_update_login NUMBER := FND_API.G_MISS_NUM
218: , list_line_id NUMBER := FND_API.G_MISS_NUM
219: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 216: , last_update_date DATE := FND_API.G_MISS_DATE

212: , created_by NUMBER := FND_API.G_MISS_NUM
213: , creation_date DATE := FND_API.G_MISS_DATE
214: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
215: , last_updated_by NUMBER := FND_API.G_MISS_NUM
216: , last_update_date DATE := FND_API.G_MISS_DATE
217: , last_update_login NUMBER := FND_API.G_MISS_NUM
218: , list_line_id NUMBER := FND_API.G_MISS_NUM
219: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
220: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 217: , last_update_login NUMBER := FND_API.G_MISS_NUM

213: , creation_date DATE := FND_API.G_MISS_DATE
214: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
215: , last_updated_by NUMBER := FND_API.G_MISS_NUM
216: , last_update_date DATE := FND_API.G_MISS_DATE
217: , last_update_login NUMBER := FND_API.G_MISS_NUM
218: , list_line_id NUMBER := FND_API.G_MISS_NUM
219: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
220: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
221: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM

Line 218: , list_line_id NUMBER := FND_API.G_MISS_NUM

214: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
215: , last_updated_by NUMBER := FND_API.G_MISS_NUM
216: , last_update_date DATE := FND_API.G_MISS_DATE
217: , last_update_login NUMBER := FND_API.G_MISS_NUM
218: , list_line_id NUMBER := FND_API.G_MISS_NUM
219: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
220: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
221: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
222: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 219: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR

215: , last_updated_by NUMBER := FND_API.G_MISS_NUM
216: , last_update_date DATE := FND_API.G_MISS_DATE
217: , last_update_login NUMBER := FND_API.G_MISS_NUM
218: , list_line_id NUMBER := FND_API.G_MISS_NUM
219: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
220: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
221: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
222: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 220: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR

216: , last_update_date DATE := FND_API.G_MISS_DATE
217: , last_update_login NUMBER := FND_API.G_MISS_NUM
218: , list_line_id NUMBER := FND_API.G_MISS_NUM
219: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
220: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
221: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
222: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 221: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM

217: , last_update_login NUMBER := FND_API.G_MISS_NUM
218: , list_line_id NUMBER := FND_API.G_MISS_NUM
219: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
220: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
221: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
222: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
225: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 222: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR

218: , list_line_id NUMBER := FND_API.G_MISS_NUM
219: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
220: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
221: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
222: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
225: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
226: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 223: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR

219: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
220: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
221: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
222: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
225: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
226: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR

Line 224: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR

220: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
221: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
222: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
225: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
226: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
228: , program_application_id NUMBER := FND_API.G_MISS_NUM

Line 225: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR

221: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
222: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
225: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
226: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
228: , program_application_id NUMBER := FND_API.G_MISS_NUM
229: , program_id NUMBER := FND_API.G_MISS_NUM

Line 226: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR

222: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
225: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
226: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
228: , program_application_id NUMBER := FND_API.G_MISS_NUM
229: , program_id NUMBER := FND_API.G_MISS_NUM
230: , program_update_date DATE := FND_API.G_MISS_DATE

Line 227: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR

223: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
225: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
226: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
228: , program_application_id NUMBER := FND_API.G_MISS_NUM
229: , program_id NUMBER := FND_API.G_MISS_NUM
230: , program_update_date DATE := FND_API.G_MISS_DATE
231: , request_id NUMBER := FND_API.G_MISS_NUM

Line 228: , program_application_id NUMBER := FND_API.G_MISS_NUM

224: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
225: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
226: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
228: , program_application_id NUMBER := FND_API.G_MISS_NUM
229: , program_id NUMBER := FND_API.G_MISS_NUM
230: , program_update_date DATE := FND_API.G_MISS_DATE
231: , request_id NUMBER := FND_API.G_MISS_NUM
232: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 229: , program_id NUMBER := FND_API.G_MISS_NUM

225: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
226: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
228: , program_application_id NUMBER := FND_API.G_MISS_NUM
229: , program_id NUMBER := FND_API.G_MISS_NUM
230: , program_update_date DATE := FND_API.G_MISS_DATE
231: , request_id NUMBER := FND_API.G_MISS_NUM
232: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
233: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 230: , program_update_date DATE := FND_API.G_MISS_DATE

226: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
228: , program_application_id NUMBER := FND_API.G_MISS_NUM
229: , program_id NUMBER := FND_API.G_MISS_NUM
230: , program_update_date DATE := FND_API.G_MISS_DATE
231: , request_id NUMBER := FND_API.G_MISS_NUM
232: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
233: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
234: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 231: , request_id NUMBER := FND_API.G_MISS_NUM

227: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
228: , program_application_id NUMBER := FND_API.G_MISS_NUM
229: , program_id NUMBER := FND_API.G_MISS_NUM
230: , program_update_date DATE := FND_API.G_MISS_DATE
231: , request_id NUMBER := FND_API.G_MISS_NUM
232: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
233: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
234: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
235: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM

Line 232: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

228: , program_application_id NUMBER := FND_API.G_MISS_NUM
229: , program_id NUMBER := FND_API.G_MISS_NUM
230: , program_update_date DATE := FND_API.G_MISS_DATE
231: , request_id NUMBER := FND_API.G_MISS_NUM
232: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
233: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
234: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
235: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM
236: );

Line 233: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

229: , program_id NUMBER := FND_API.G_MISS_NUM
230: , program_update_date DATE := FND_API.G_MISS_DATE
231: , request_id NUMBER := FND_API.G_MISS_NUM
232: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
233: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
234: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
235: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM
236: );
237:

Line 234: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

230: , program_update_date DATE := FND_API.G_MISS_DATE
231: , request_id NUMBER := FND_API.G_MISS_NUM
232: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
233: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
234: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
235: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM
236: );
237:
238: TYPE Pricing_Attr_Tbl_Type IS TABLE OF Pricing_Attr_Rec_Type

Line 235: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM

231: , request_id NUMBER := FND_API.G_MISS_NUM
232: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
233: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
234: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
235: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM
236: );
237:
238: TYPE Pricing_Attr_Tbl_Type IS TABLE OF Pricing_Attr_Rec_Type
239: INDEX BY BINARY_INTEGER;

Line 271: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

267: -- End of Comments
268: /*
269: PROCEDURE Process_Price_List
270: ( p_api_version_number IN NUMBER
271: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
272: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
273: , p_commit IN VARCHAR2 := FND_API.G_FALSE
274: , x_return_status OUT VARCHAR2
275: , x_msg_count OUT NUMBER

Line 272: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

268: /*
269: PROCEDURE Process_Price_List
270: ( p_api_version_number IN NUMBER
271: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
272: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
273: , p_commit IN VARCHAR2 := FND_API.G_FALSE
274: , x_return_status OUT VARCHAR2
275: , x_msg_count OUT NUMBER
276: , x_msg_data OUT VARCHAR2

Line 273: , p_commit IN VARCHAR2 := FND_API.G_FALSE

269: PROCEDURE Process_Price_List
270: ( p_api_version_number IN NUMBER
271: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
272: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
273: , p_commit IN VARCHAR2 := FND_API.G_FALSE
274: , x_return_status OUT VARCHAR2
275: , x_msg_count OUT NUMBER
276: , x_msg_data OUT VARCHAR2
277: , p_PRICE_LIST_rec IN Price_List_Rec_Type :=

Line 309: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

305: -- End of Comments
306:
307: PROCEDURE Lock_Price_List
308: ( p_api_version_number IN NUMBER
309: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
310: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
311: , x_return_status OUT VARCHAR2
312: , x_msg_count OUT NUMBER
313: , x_msg_data OUT VARCHAR2

Line 310: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

306:
307: PROCEDURE Lock_Price_List
308: ( p_api_version_number IN NUMBER
309: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
310: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
311: , x_return_status OUT VARCHAR2
312: , x_msg_count OUT NUMBER
313: , x_msg_data OUT VARCHAR2
314: , p_PRICE_LIST_rec IN Price_List_Rec_Type :=

Line 346: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

342: -- End of Comments
343:
344: PROCEDURE Get_Price_List
345: ( p_api_version_number IN NUMBER
346: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
347: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
348: , x_return_status OUT VARCHAR2
349: , x_msg_count OUT NUMBER
350: , x_msg_data OUT VARCHAR2

Line 347: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

343:
344: PROCEDURE Get_Price_List
345: ( p_api_version_number IN NUMBER
346: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
347: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
348: , x_return_status OUT VARCHAR2
349: , x_msg_count OUT NUMBER
350: , x_msg_data OUT VARCHAR2
351: , p_name IN VARCHAR2 :=

Line 352: FND_API.G_MISS_CHAR

348: , x_return_status OUT VARCHAR2
349: , x_msg_count OUT NUMBER
350: , x_msg_data OUT VARCHAR2
351: , p_name IN VARCHAR2 :=
352: FND_API.G_MISS_CHAR
353: , p_price_list_id IN NUMBER :=
354: FND_API.G_MISS_NUM
355: , p_price_list IN VARCHAR2 :=
356: FND_API.G_MISS_CHAR

Line 354: FND_API.G_MISS_NUM

350: , x_msg_data OUT VARCHAR2
351: , p_name IN VARCHAR2 :=
352: FND_API.G_MISS_CHAR
353: , p_price_list_id IN NUMBER :=
354: FND_API.G_MISS_NUM
355: , p_price_list IN VARCHAR2 :=
356: FND_API.G_MISS_CHAR
357: , x_PRICE_LIST_rec OUT Price_List_Rec_Type
358: , x_PRICE_LIST_val_rec OUT Price_List_Val_Rec_Type

Line 356: FND_API.G_MISS_CHAR

352: FND_API.G_MISS_CHAR
353: , p_price_list_id IN NUMBER :=
354: FND_API.G_MISS_NUM
355: , p_price_list IN VARCHAR2 :=
356: FND_API.G_MISS_CHAR
357: , x_PRICE_LIST_rec OUT Price_List_Rec_Type
358: , x_PRICE_LIST_val_rec OUT Price_List_Val_Rec_Type
359: , x_PRICE_LIST_LINE_tbl OUT Price_List_Line_Tbl_Type
360: , x_PRICE_LIST_LINE_val_tbl OUT Price_List_Line_Val_Tbl_Type