APPS.QP_PRICE_LIST_PUB dependencies on FND_API

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

11:
12: -- Price_List record type
13:
14: TYPE Price_List_Rec_Type IS RECORD
15: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

12: -- Price_List record type
13:
14: TYPE Price_List_Rec_Type IS RECORD
15: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

13:
14: TYPE Price_List_Rec_Type IS RECORD
15: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

14: TYPE Price_List_Rec_Type IS RECORD
15: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

15: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

16: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
31: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR

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

24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
31: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
32: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

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

25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
31: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
32: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
33: , created_by NUMBER := FND_API.G_MISS_NUM

Line 30: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
31: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
32: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
33: , created_by NUMBER := FND_API.G_MISS_NUM
34: , creation_date DATE := FND_API.G_MISS_DATE

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

27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
31: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
32: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
33: , created_by NUMBER := FND_API.G_MISS_NUM
34: , creation_date DATE := FND_API.G_MISS_DATE
35: , currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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

28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
31: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
32: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
33: , created_by NUMBER := FND_API.G_MISS_NUM
34: , creation_date DATE := FND_API.G_MISS_DATE
35: , currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
36: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 33: , created_by NUMBER := FND_API.G_MISS_NUM

29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
31: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
32: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
33: , created_by NUMBER := FND_API.G_MISS_NUM
34: , creation_date DATE := FND_API.G_MISS_DATE
35: , currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
36: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
37: , end_date_active DATE := FND_API.G_MISS_DATE

Line 34: , creation_date DATE := FND_API.G_MISS_DATE

30: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
31: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
32: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
33: , created_by NUMBER := FND_API.G_MISS_NUM
34: , creation_date DATE := FND_API.G_MISS_DATE
35: , currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
36: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
37: , end_date_active DATE := FND_API.G_MISS_DATE
38: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 35: , currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR

31: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
32: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
33: , created_by NUMBER := FND_API.G_MISS_NUM
34: , creation_date DATE := FND_API.G_MISS_DATE
35: , currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
36: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
37: , end_date_active DATE := FND_API.G_MISS_DATE
38: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
39: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 36: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

32: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
33: , created_by NUMBER := FND_API.G_MISS_NUM
34: , creation_date DATE := FND_API.G_MISS_DATE
35: , currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
36: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
37: , end_date_active DATE := FND_API.G_MISS_DATE
38: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
39: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
40: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 37: , end_date_active DATE := FND_API.G_MISS_DATE

33: , created_by NUMBER := FND_API.G_MISS_NUM
34: , creation_date DATE := FND_API.G_MISS_DATE
35: , currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
36: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
37: , end_date_active DATE := FND_API.G_MISS_DATE
38: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
39: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
40: , last_updated_by NUMBER := FND_API.G_MISS_NUM
41: , last_update_date DATE := FND_API.G_MISS_DATE

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

34: , creation_date DATE := FND_API.G_MISS_DATE
35: , currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
36: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
37: , end_date_active DATE := FND_API.G_MISS_DATE
38: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
39: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
40: , last_updated_by NUMBER := FND_API.G_MISS_NUM
41: , last_update_date DATE := FND_API.G_MISS_DATE
42: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 39: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR

35: , currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
36: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
37: , end_date_active DATE := FND_API.G_MISS_DATE
38: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
39: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
40: , last_updated_by NUMBER := FND_API.G_MISS_NUM
41: , last_update_date DATE := FND_API.G_MISS_DATE
42: , last_update_login NUMBER := FND_API.G_MISS_NUM
43: , list_header_id NUMBER := FND_API.G_MISS_NUM

Line 40: , last_updated_by NUMBER := FND_API.G_MISS_NUM

36: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
37: , end_date_active DATE := FND_API.G_MISS_DATE
38: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
39: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
40: , last_updated_by NUMBER := FND_API.G_MISS_NUM
41: , last_update_date DATE := FND_API.G_MISS_DATE
42: , last_update_login NUMBER := FND_API.G_MISS_NUM
43: , list_header_id NUMBER := FND_API.G_MISS_NUM
44: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 41: , last_update_date DATE := FND_API.G_MISS_DATE

37: , end_date_active DATE := FND_API.G_MISS_DATE
38: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
39: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
40: , last_updated_by NUMBER := FND_API.G_MISS_NUM
41: , last_update_date DATE := FND_API.G_MISS_DATE
42: , last_update_login NUMBER := FND_API.G_MISS_NUM
43: , list_header_id NUMBER := FND_API.G_MISS_NUM
44: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , program_application_id NUMBER := FND_API.G_MISS_NUM

Line 42: , last_update_login NUMBER := FND_API.G_MISS_NUM

38: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
39: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
40: , last_updated_by NUMBER := FND_API.G_MISS_NUM
41: , last_update_date DATE := FND_API.G_MISS_DATE
42: , last_update_login NUMBER := FND_API.G_MISS_NUM
43: , list_header_id NUMBER := FND_API.G_MISS_NUM
44: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , program_application_id NUMBER := FND_API.G_MISS_NUM
46: , program_id NUMBER := FND_API.G_MISS_NUM

Line 43: , list_header_id NUMBER := FND_API.G_MISS_NUM

39: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
40: , last_updated_by NUMBER := FND_API.G_MISS_NUM
41: , last_update_date DATE := FND_API.G_MISS_DATE
42: , last_update_login NUMBER := FND_API.G_MISS_NUM
43: , list_header_id NUMBER := FND_API.G_MISS_NUM
44: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , program_application_id NUMBER := FND_API.G_MISS_NUM
46: , program_id NUMBER := FND_API.G_MISS_NUM
47: , program_update_date DATE := FND_API.G_MISS_DATE

Line 44: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

40: , last_updated_by NUMBER := FND_API.G_MISS_NUM
41: , last_update_date DATE := FND_API.G_MISS_DATE
42: , last_update_login NUMBER := FND_API.G_MISS_NUM
43: , list_header_id NUMBER := FND_API.G_MISS_NUM
44: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , program_application_id NUMBER := FND_API.G_MISS_NUM
46: , program_id NUMBER := FND_API.G_MISS_NUM
47: , program_update_date DATE := FND_API.G_MISS_DATE
48: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 45: , program_application_id NUMBER := FND_API.G_MISS_NUM

41: , last_update_date DATE := FND_API.G_MISS_DATE
42: , last_update_login NUMBER := FND_API.G_MISS_NUM
43: , list_header_id NUMBER := FND_API.G_MISS_NUM
44: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , program_application_id NUMBER := FND_API.G_MISS_NUM
46: , program_id NUMBER := FND_API.G_MISS_NUM
47: , program_update_date DATE := FND_API.G_MISS_DATE
48: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
49: , request_id NUMBER := FND_API.G_MISS_NUM

Line 46: , program_id NUMBER := FND_API.G_MISS_NUM

42: , last_update_login NUMBER := FND_API.G_MISS_NUM
43: , list_header_id NUMBER := FND_API.G_MISS_NUM
44: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , program_application_id NUMBER := FND_API.G_MISS_NUM
46: , program_id NUMBER := FND_API.G_MISS_NUM
47: , program_update_date DATE := FND_API.G_MISS_DATE
48: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
49: , request_id NUMBER := FND_API.G_MISS_NUM
50: , rounding_factor NUMBER := FND_API.G_MISS_NUM

Line 47: , program_update_date DATE := FND_API.G_MISS_DATE

43: , list_header_id NUMBER := FND_API.G_MISS_NUM
44: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , program_application_id NUMBER := FND_API.G_MISS_NUM
46: , program_id NUMBER := FND_API.G_MISS_NUM
47: , program_update_date DATE := FND_API.G_MISS_DATE
48: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
49: , request_id NUMBER := FND_API.G_MISS_NUM
50: , rounding_factor NUMBER := FND_API.G_MISS_NUM
51: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 48: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR

44: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , program_application_id NUMBER := FND_API.G_MISS_NUM
46: , program_id NUMBER := FND_API.G_MISS_NUM
47: , program_update_date DATE := FND_API.G_MISS_DATE
48: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
49: , request_id NUMBER := FND_API.G_MISS_NUM
50: , rounding_factor NUMBER := FND_API.G_MISS_NUM
51: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
52: , start_date_active DATE := FND_API.G_MISS_DATE

Line 49: , request_id NUMBER := FND_API.G_MISS_NUM

45: , program_application_id NUMBER := FND_API.G_MISS_NUM
46: , program_id NUMBER := FND_API.G_MISS_NUM
47: , program_update_date DATE := FND_API.G_MISS_DATE
48: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
49: , request_id NUMBER := FND_API.G_MISS_NUM
50: , rounding_factor NUMBER := FND_API.G_MISS_NUM
51: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
52: , start_date_active DATE := FND_API.G_MISS_DATE
53: , terms_id NUMBER := FND_API.G_MISS_NUM

Line 50: , rounding_factor NUMBER := FND_API.G_MISS_NUM

46: , program_id NUMBER := FND_API.G_MISS_NUM
47: , program_update_date DATE := FND_API.G_MISS_DATE
48: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
49: , request_id NUMBER := FND_API.G_MISS_NUM
50: , rounding_factor NUMBER := FND_API.G_MISS_NUM
51: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
52: , start_date_active DATE := FND_API.G_MISS_DATE
53: , terms_id NUMBER := FND_API.G_MISS_NUM
54: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

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

47: , program_update_date DATE := FND_API.G_MISS_DATE
48: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
49: , request_id NUMBER := FND_API.G_MISS_NUM
50: , rounding_factor NUMBER := FND_API.G_MISS_NUM
51: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
52: , start_date_active DATE := FND_API.G_MISS_DATE
53: , terms_id NUMBER := FND_API.G_MISS_NUM
54: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
55: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 52: , start_date_active DATE := FND_API.G_MISS_DATE

48: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
49: , request_id NUMBER := FND_API.G_MISS_NUM
50: , rounding_factor NUMBER := FND_API.G_MISS_NUM
51: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
52: , start_date_active DATE := FND_API.G_MISS_DATE
53: , terms_id NUMBER := FND_API.G_MISS_NUM
54: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
55: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
56: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 53: , terms_id NUMBER := FND_API.G_MISS_NUM

49: , request_id NUMBER := FND_API.G_MISS_NUM
50: , rounding_factor NUMBER := FND_API.G_MISS_NUM
51: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
52: , start_date_active DATE := FND_API.G_MISS_DATE
53: , terms_id NUMBER := FND_API.G_MISS_NUM
54: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
55: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
56: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
57: , name VARCHAR2(240) := FND_API.G_MISS_CHAR

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

50: , rounding_factor NUMBER := FND_API.G_MISS_NUM
51: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
52: , start_date_active DATE := FND_API.G_MISS_DATE
53: , terms_id NUMBER := FND_API.G_MISS_NUM
54: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
55: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
56: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
57: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR

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

51: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
52: , start_date_active DATE := FND_API.G_MISS_DATE
53: , terms_id NUMBER := FND_API.G_MISS_NUM
54: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
55: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
56: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
57: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
59: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR

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

52: , start_date_active DATE := FND_API.G_MISS_DATE
53: , terms_id NUMBER := FND_API.G_MISS_NUM
54: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
55: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
56: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
57: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
59: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

53: , terms_id NUMBER := FND_API.G_MISS_NUM
54: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
55: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
56: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
57: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
59: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
61: , mobile_download VARCHAR2(1) := FND_API.G_MISS_CHAR -- mkarya for bug 1944882

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

54: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
55: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
56: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
57: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
59: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
61: , mobile_download VARCHAR2(1) := FND_API.G_MISS_CHAR -- mkarya for bug 1944882
62: , currency_header_id NUMBER := FND_API.G_MISS_NUM -- Multi-Currency SunilPandey

Line 59: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR

55: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
56: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
57: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
59: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
61: , mobile_download VARCHAR2(1) := FND_API.G_MISS_CHAR -- mkarya for bug 1944882
62: , currency_header_id NUMBER := FND_API.G_MISS_NUM -- Multi-Currency SunilPandey
63: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Attribute Manager Giri

Line 60: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

56: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
57: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
59: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
61: , mobile_download VARCHAR2(1) := FND_API.G_MISS_CHAR -- mkarya for bug 1944882
62: , currency_header_id NUMBER := FND_API.G_MISS_NUM -- Multi-Currency SunilPandey
63: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Attribute Manager Giri
64: , list_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Blanket Sales Order, arraghav

Line 61: , mobile_download VARCHAR2(1) := FND_API.G_MISS_CHAR -- mkarya for bug 1944882

57: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
59: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
61: , mobile_download VARCHAR2(1) := FND_API.G_MISS_CHAR -- mkarya for bug 1944882
62: , currency_header_id NUMBER := FND_API.G_MISS_NUM -- Multi-Currency SunilPandey
63: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Attribute Manager Giri
64: , list_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Blanket Sales Order, arraghav
65: , orig_system_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR -- Blanket Sales Order, arraghav

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

58: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
59: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
61: , mobile_download VARCHAR2(1) := FND_API.G_MISS_CHAR -- mkarya for bug 1944882
62: , currency_header_id NUMBER := FND_API.G_MISS_NUM -- Multi-Currency SunilPandey
63: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Attribute Manager Giri
64: , list_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Blanket Sales Order, arraghav
65: , orig_system_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR -- Blanket Sales Order, arraghav
66: , global_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Pricing Security , gtippire

Line 63: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Attribute Manager Giri

59: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
61: , mobile_download VARCHAR2(1) := FND_API.G_MISS_CHAR -- mkarya for bug 1944882
62: , currency_header_id NUMBER := FND_API.G_MISS_NUM -- Multi-Currency SunilPandey
63: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Attribute Manager Giri
64: , list_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Blanket Sales Order, arraghav
65: , orig_system_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR -- Blanket Sales Order, arraghav
66: , global_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Pricing Security , gtippire
67: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 64: , list_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Blanket Sales Order, arraghav

60: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
61: , mobile_download VARCHAR2(1) := FND_API.G_MISS_CHAR -- mkarya for bug 1944882
62: , currency_header_id NUMBER := FND_API.G_MISS_NUM -- Multi-Currency SunilPandey
63: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Attribute Manager Giri
64: , list_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Blanket Sales Order, arraghav
65: , orig_system_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR -- Blanket Sales Order, arraghav
66: , global_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Pricing Security , gtippire
67: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , shareable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 65: , orig_system_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR -- Blanket Sales Order, arraghav

61: , mobile_download VARCHAR2(1) := FND_API.G_MISS_CHAR -- mkarya for bug 1944882
62: , currency_header_id NUMBER := FND_API.G_MISS_NUM -- Multi-Currency SunilPandey
63: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Attribute Manager Giri
64: , list_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Blanket Sales Order, arraghav
65: , orig_system_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR -- Blanket Sales Order, arraghav
66: , global_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Pricing Security , gtippire
67: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , shareable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
69: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM

Line 66: , global_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Pricing Security , gtippire

62: , currency_header_id NUMBER := FND_API.G_MISS_NUM -- Multi-Currency SunilPandey
63: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Attribute Manager Giri
64: , list_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Blanket Sales Order, arraghav
65: , orig_system_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR -- Blanket Sales Order, arraghav
66: , global_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Pricing Security , gtippire
67: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , shareable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
69: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
70: , locked_from_list_header_id NUMBER := FND_API.G_MISS_NUM

Line 67: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR

63: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Attribute Manager Giri
64: , list_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Blanket Sales Order, arraghav
65: , orig_system_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR -- Blanket Sales Order, arraghav
66: , global_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Pricing Security , gtippire
67: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , shareable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
69: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
70: , locked_from_list_header_id NUMBER := FND_API.G_MISS_NUM
71: --added for MOAC support

Line 68: , shareable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

64: , list_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Blanket Sales Order, arraghav
65: , orig_system_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR -- Blanket Sales Order, arraghav
66: , global_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Pricing Security , gtippire
67: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , shareable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
69: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
70: , locked_from_list_header_id NUMBER := FND_API.G_MISS_NUM
71: --added for MOAC support
72: , org_id NUMBER := FND_API.G_MISS_NUM

Line 69: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM

65: , orig_system_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR -- Blanket Sales Order, arraghav
66: , global_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Pricing Security , gtippire
67: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , shareable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
69: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
70: , locked_from_list_header_id NUMBER := FND_API.G_MISS_NUM
71: --added for MOAC support
72: , org_id NUMBER := FND_API.G_MISS_NUM
73: );

Line 70: , locked_from_list_header_id NUMBER := FND_API.G_MISS_NUM

66: , global_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Pricing Security , gtippire
67: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , shareable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
69: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
70: , locked_from_list_header_id NUMBER := FND_API.G_MISS_NUM
71: --added for MOAC support
72: , org_id NUMBER := FND_API.G_MISS_NUM
73: );
74:

Line 72: , org_id NUMBER := FND_API.G_MISS_NUM

68: , shareable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
69: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
70: , locked_from_list_header_id NUMBER := FND_API.G_MISS_NUM
71: --added for MOAC support
72: , org_id NUMBER := FND_API.G_MISS_NUM
73: );
74:
75: TYPE Price_List_Tbl_Type IS TABLE OF Price_List_Rec_Type
76: INDEX BY BINARY_INTEGER;

Line 81: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR

77:
78: -- Price_List value record type
79:
80: TYPE Price_List_Val_Rec_Type IS RECORD
81: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , currency VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 82: , currency VARCHAR2(240) := FND_API.G_MISS_CHAR

78: -- Price_List value record type
79:
80: TYPE Price_List_Val_Rec_Type IS RECORD
81: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , currency VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 83: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR

79:
80: TYPE Price_List_Val_Rec_Type IS RECORD
81: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , currency VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR

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

80: TYPE Price_List_Val_Rec_Type IS RECORD
81: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , currency VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 85: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR

81: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , currency VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 86: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR

82: , currency VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , currency_header VARCHAR2(240) := FND_API.G_MISS_CHAR -- Multi-Currency SunilPandey

Line 87: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR

83: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , currency_header VARCHAR2(240) := FND_API.G_MISS_CHAR -- Multi-Currency SunilPandey
91: , pte VARCHAR2(240) := FND_API.G_MISS_CHAR -- Attribute Manager Giri

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

84: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , currency_header VARCHAR2(240) := FND_API.G_MISS_CHAR -- Multi-Currency SunilPandey
91: , pte VARCHAR2(240) := FND_API.G_MISS_CHAR -- Attribute Manager Giri
92: , list_source_code VARCHAR2(240) := FND_API.G_MISS_CHAR

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

85: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , currency_header VARCHAR2(240) := FND_API.G_MISS_CHAR -- Multi-Currency SunilPandey
91: , pte VARCHAR2(240) := FND_API.G_MISS_CHAR -- Attribute Manager Giri
92: , list_source_code VARCHAR2(240) := FND_API.G_MISS_CHAR
93: -- Blanket Sales Order, arraghav

Line 90: , currency_header VARCHAR2(240) := FND_API.G_MISS_CHAR -- Multi-Currency SunilPandey

86: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , currency_header VARCHAR2(240) := FND_API.G_MISS_CHAR -- Multi-Currency SunilPandey
91: , pte VARCHAR2(240) := FND_API.G_MISS_CHAR -- Attribute Manager Giri
92: , list_source_code VARCHAR2(240) := FND_API.G_MISS_CHAR
93: -- Blanket Sales Order, arraghav
94: , orig_system_header_ref VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 91: , pte VARCHAR2(240) := FND_API.G_MISS_CHAR -- Attribute Manager Giri

87: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , currency_header VARCHAR2(240) := FND_API.G_MISS_CHAR -- Multi-Currency SunilPandey
91: , pte VARCHAR2(240) := FND_API.G_MISS_CHAR -- Attribute Manager Giri
92: , list_source_code VARCHAR2(240) := FND_API.G_MISS_CHAR
93: -- Blanket Sales Order, arraghav
94: , orig_system_header_ref VARCHAR2(240) := FND_API.G_MISS_CHAR
95: -- Blanket Sales Order, arraghav

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

88: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , currency_header VARCHAR2(240) := FND_API.G_MISS_CHAR -- Multi-Currency SunilPandey
91: , pte VARCHAR2(240) := FND_API.G_MISS_CHAR -- Attribute Manager Giri
92: , list_source_code VARCHAR2(240) := FND_API.G_MISS_CHAR
93: -- Blanket Sales Order, arraghav
94: , orig_system_header_ref VARCHAR2(240) := FND_API.G_MISS_CHAR
95: -- Blanket Sales Order, arraghav
96: );

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

90: , currency_header VARCHAR2(240) := FND_API.G_MISS_CHAR -- Multi-Currency SunilPandey
91: , pte VARCHAR2(240) := FND_API.G_MISS_CHAR -- Attribute Manager Giri
92: , list_source_code VARCHAR2(240) := FND_API.G_MISS_CHAR
93: -- Blanket Sales Order, arraghav
94: , orig_system_header_ref VARCHAR2(240) := FND_API.G_MISS_CHAR
95: -- Blanket Sales Order, arraghav
96: );
97:
98: TYPE Price_List_Val_Tbl_Type IS TABLE OF Price_List_Val_Rec_Type

Line 104: ( accrual_qty NUMBER := FND_API.G_MISS_NUM

100:
101: -- Price_List_Line record type
102:
103: TYPE Price_List_Line_Rec_Type IS RECORD
104: ( accrual_qty NUMBER := FND_API.G_MISS_NUM
105: , accrual_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
106: , arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
107: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 105: , accrual_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR

101: -- Price_List_Line record type
102:
103: TYPE Price_List_Line_Rec_Type IS RECORD
104: ( accrual_qty NUMBER := FND_API.G_MISS_NUM
105: , accrual_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
106: , arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
107: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 106: , arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR

102:
103: TYPE Price_List_Line_Rec_Type IS RECORD
104: ( accrual_qty NUMBER := FND_API.G_MISS_NUM
105: , accrual_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
106: , arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
107: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

103: TYPE Price_List_Line_Rec_Type IS RECORD
104: ( accrual_qty NUMBER := FND_API.G_MISS_NUM
105: , accrual_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
106: , arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
107: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

104: ( accrual_qty NUMBER := FND_API.G_MISS_NUM
105: , accrual_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
106: , arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
107: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

105: , accrual_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
106: , arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
107: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

106: , arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
107: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

107: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

108: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

109: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

110: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

111: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

112: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

113: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

114: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

115: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
123: , base_qty NUMBER := FND_API.G_MISS_NUM

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

116: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
123: , base_qty NUMBER := FND_API.G_MISS_NUM
124: , base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR

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

117: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
123: , base_qty NUMBER := FND_API.G_MISS_NUM
124: , base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
125: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR

Line 122: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

118: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
123: , base_qty NUMBER := FND_API.G_MISS_NUM
124: , base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
125: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
126: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 123: , base_qty NUMBER := FND_API.G_MISS_NUM

119: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
123: , base_qty NUMBER := FND_API.G_MISS_NUM
124: , base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
125: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
126: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
127: , created_by NUMBER := FND_API.G_MISS_NUM

Line 124: , base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR

120: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
123: , base_qty NUMBER := FND_API.G_MISS_NUM
124: , base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
125: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
126: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
127: , created_by NUMBER := FND_API.G_MISS_NUM
128: , creation_date DATE := FND_API.G_MISS_DATE

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

121: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
123: , base_qty NUMBER := FND_API.G_MISS_NUM
124: , base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
125: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
126: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
127: , created_by NUMBER := FND_API.G_MISS_NUM
128: , creation_date DATE := FND_API.G_MISS_DATE
129: , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR

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

122: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
123: , base_qty NUMBER := FND_API.G_MISS_NUM
124: , base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
125: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
126: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
127: , created_by NUMBER := FND_API.G_MISS_NUM
128: , creation_date DATE := FND_API.G_MISS_DATE
129: , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
130: , end_date_active DATE := FND_API.G_MISS_DATE

Line 127: , created_by NUMBER := FND_API.G_MISS_NUM

123: , base_qty NUMBER := FND_API.G_MISS_NUM
124: , base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
125: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
126: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
127: , created_by NUMBER := FND_API.G_MISS_NUM
128: , creation_date DATE := FND_API.G_MISS_DATE
129: , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
130: , end_date_active DATE := FND_API.G_MISS_DATE
131: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM

Line 128: , creation_date DATE := FND_API.G_MISS_DATE

124: , base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
125: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
126: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
127: , created_by NUMBER := FND_API.G_MISS_NUM
128: , creation_date DATE := FND_API.G_MISS_DATE
129: , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
130: , end_date_active DATE := FND_API.G_MISS_DATE
131: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
132: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM

Line 129: , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR

125: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
126: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
127: , created_by NUMBER := FND_API.G_MISS_NUM
128: , creation_date DATE := FND_API.G_MISS_DATE
129: , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
130: , end_date_active DATE := FND_API.G_MISS_DATE
131: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
132: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
133: , inventory_item_id NUMBER := FND_API.G_MISS_NUM

Line 130: , end_date_active DATE := FND_API.G_MISS_DATE

126: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
127: , created_by NUMBER := FND_API.G_MISS_NUM
128: , creation_date DATE := FND_API.G_MISS_DATE
129: , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
130: , end_date_active DATE := FND_API.G_MISS_DATE
131: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
132: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
133: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
134: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 131: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM

127: , created_by NUMBER := FND_API.G_MISS_NUM
128: , creation_date DATE := FND_API.G_MISS_DATE
129: , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
130: , end_date_active DATE := FND_API.G_MISS_DATE
131: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
132: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
133: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
134: , last_updated_by NUMBER := FND_API.G_MISS_NUM
135: , last_update_date DATE := FND_API.G_MISS_DATE

Line 132: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM

128: , creation_date DATE := FND_API.G_MISS_DATE
129: , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
130: , end_date_active DATE := FND_API.G_MISS_DATE
131: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
132: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
133: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
134: , last_updated_by NUMBER := FND_API.G_MISS_NUM
135: , last_update_date DATE := FND_API.G_MISS_DATE
136: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 133: , inventory_item_id NUMBER := FND_API.G_MISS_NUM

129: , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
130: , end_date_active DATE := FND_API.G_MISS_DATE
131: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
132: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
133: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
134: , last_updated_by NUMBER := FND_API.G_MISS_NUM
135: , last_update_date DATE := FND_API.G_MISS_DATE
136: , last_update_login NUMBER := FND_API.G_MISS_NUM
137: , list_header_id NUMBER := FND_API.G_MISS_NUM

Line 134: , last_updated_by NUMBER := FND_API.G_MISS_NUM

130: , end_date_active DATE := FND_API.G_MISS_DATE
131: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
132: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
133: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
134: , last_updated_by NUMBER := FND_API.G_MISS_NUM
135: , last_update_date DATE := FND_API.G_MISS_DATE
136: , last_update_login NUMBER := FND_API.G_MISS_NUM
137: , list_header_id NUMBER := FND_API.G_MISS_NUM
138: , list_line_id NUMBER := FND_API.G_MISS_NUM

Line 135: , last_update_date DATE := FND_API.G_MISS_DATE

131: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
132: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
133: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
134: , last_updated_by NUMBER := FND_API.G_MISS_NUM
135: , last_update_date DATE := FND_API.G_MISS_DATE
136: , last_update_login NUMBER := FND_API.G_MISS_NUM
137: , list_header_id NUMBER := FND_API.G_MISS_NUM
138: , list_line_id NUMBER := FND_API.G_MISS_NUM
139: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 136: , last_update_login NUMBER := FND_API.G_MISS_NUM

132: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
133: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
134: , last_updated_by NUMBER := FND_API.G_MISS_NUM
135: , last_update_date DATE := FND_API.G_MISS_DATE
136: , last_update_login NUMBER := FND_API.G_MISS_NUM
137: , list_header_id NUMBER := FND_API.G_MISS_NUM
138: , list_line_id NUMBER := FND_API.G_MISS_NUM
139: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
140: , list_price NUMBER := FND_API.G_MISS_NUM

Line 137: , list_header_id NUMBER := FND_API.G_MISS_NUM

133: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
134: , last_updated_by NUMBER := FND_API.G_MISS_NUM
135: , last_update_date DATE := FND_API.G_MISS_DATE
136: , last_update_login NUMBER := FND_API.G_MISS_NUM
137: , list_header_id NUMBER := FND_API.G_MISS_NUM
138: , list_line_id NUMBER := FND_API.G_MISS_NUM
139: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
140: , list_price NUMBER := FND_API.G_MISS_NUM
141: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 138: , list_line_id NUMBER := FND_API.G_MISS_NUM

134: , last_updated_by NUMBER := FND_API.G_MISS_NUM
135: , last_update_date DATE := FND_API.G_MISS_DATE
136: , last_update_login NUMBER := FND_API.G_MISS_NUM
137: , list_header_id NUMBER := FND_API.G_MISS_NUM
138: , list_line_id NUMBER := FND_API.G_MISS_NUM
139: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
140: , list_price NUMBER := FND_API.G_MISS_NUM
141: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , number_effective_periods NUMBER := FND_API.G_MISS_NUM

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

135: , last_update_date DATE := FND_API.G_MISS_DATE
136: , last_update_login NUMBER := FND_API.G_MISS_NUM
137: , list_header_id NUMBER := FND_API.G_MISS_NUM
138: , list_line_id NUMBER := FND_API.G_MISS_NUM
139: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
140: , list_price NUMBER := FND_API.G_MISS_NUM
141: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , number_effective_periods NUMBER := FND_API.G_MISS_NUM
143: , operand NUMBER := FND_API.G_MISS_NUM

Line 140: , list_price NUMBER := FND_API.G_MISS_NUM

136: , last_update_login NUMBER := FND_API.G_MISS_NUM
137: , list_header_id NUMBER := FND_API.G_MISS_NUM
138: , list_line_id NUMBER := FND_API.G_MISS_NUM
139: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
140: , list_price NUMBER := FND_API.G_MISS_NUM
141: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , number_effective_periods NUMBER := FND_API.G_MISS_NUM
143: , operand NUMBER := FND_API.G_MISS_NUM
144: , organization_id NUMBER := FND_API.G_MISS_NUM

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

137: , list_header_id NUMBER := FND_API.G_MISS_NUM
138: , list_line_id NUMBER := FND_API.G_MISS_NUM
139: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
140: , list_price NUMBER := FND_API.G_MISS_NUM
141: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , number_effective_periods NUMBER := FND_API.G_MISS_NUM
143: , operand NUMBER := FND_API.G_MISS_NUM
144: , organization_id NUMBER := FND_API.G_MISS_NUM
145: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 142: , number_effective_periods NUMBER := FND_API.G_MISS_NUM

138: , list_line_id NUMBER := FND_API.G_MISS_NUM
139: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
140: , list_price NUMBER := FND_API.G_MISS_NUM
141: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , number_effective_periods NUMBER := FND_API.G_MISS_NUM
143: , operand NUMBER := FND_API.G_MISS_NUM
144: , organization_id NUMBER := FND_API.G_MISS_NUM
145: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , percent_price NUMBER := FND_API.G_MISS_NUM

Line 143: , operand NUMBER := FND_API.G_MISS_NUM

139: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
140: , list_price NUMBER := FND_API.G_MISS_NUM
141: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , number_effective_periods NUMBER := FND_API.G_MISS_NUM
143: , operand NUMBER := FND_API.G_MISS_NUM
144: , organization_id NUMBER := FND_API.G_MISS_NUM
145: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , percent_price NUMBER := FND_API.G_MISS_NUM
147: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 144: , organization_id NUMBER := FND_API.G_MISS_NUM

140: , list_price NUMBER := FND_API.G_MISS_NUM
141: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , number_effective_periods NUMBER := FND_API.G_MISS_NUM
143: , operand NUMBER := FND_API.G_MISS_NUM
144: , organization_id NUMBER := FND_API.G_MISS_NUM
145: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , percent_price NUMBER := FND_API.G_MISS_NUM
147: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
148: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM

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

141: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , number_effective_periods NUMBER := FND_API.G_MISS_NUM
143: , operand NUMBER := FND_API.G_MISS_NUM
144: , organization_id NUMBER := FND_API.G_MISS_NUM
145: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , percent_price NUMBER := FND_API.G_MISS_NUM
147: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
148: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
149: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 146: , percent_price NUMBER := FND_API.G_MISS_NUM

142: , number_effective_periods NUMBER := FND_API.G_MISS_NUM
143: , operand NUMBER := FND_API.G_MISS_NUM
144: , organization_id NUMBER := FND_API.G_MISS_NUM
145: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , percent_price NUMBER := FND_API.G_MISS_NUM
147: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
148: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
149: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
150: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

143: , operand NUMBER := FND_API.G_MISS_NUM
144: , organization_id NUMBER := FND_API.G_MISS_NUM
145: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , percent_price NUMBER := FND_API.G_MISS_NUM
147: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
148: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
149: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
150: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
151: , program_application_id NUMBER := FND_API.G_MISS_NUM

Line 148: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM

144: , organization_id NUMBER := FND_API.G_MISS_NUM
145: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , percent_price NUMBER := FND_API.G_MISS_NUM
147: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
148: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
149: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
150: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
151: , program_application_id NUMBER := FND_API.G_MISS_NUM
152: , program_id NUMBER := FND_API.G_MISS_NUM

Line 149: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

145: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , percent_price NUMBER := FND_API.G_MISS_NUM
147: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
148: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
149: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
150: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
151: , program_application_id NUMBER := FND_API.G_MISS_NUM
152: , program_id NUMBER := FND_API.G_MISS_NUM
153: , program_update_date DATE := FND_API.G_MISS_DATE

Line 150: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

146: , percent_price NUMBER := FND_API.G_MISS_NUM
147: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
148: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
149: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
150: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
151: , program_application_id NUMBER := FND_API.G_MISS_NUM
152: , program_id NUMBER := FND_API.G_MISS_NUM
153: , program_update_date DATE := FND_API.G_MISS_DATE
154: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 151: , program_application_id NUMBER := FND_API.G_MISS_NUM

147: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
148: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
149: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
150: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
151: , program_application_id NUMBER := FND_API.G_MISS_NUM
152: , program_id NUMBER := FND_API.G_MISS_NUM
153: , program_update_date DATE := FND_API.G_MISS_DATE
154: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
155: , related_item_id NUMBER := FND_API.G_MISS_NUM

Line 152: , program_id NUMBER := FND_API.G_MISS_NUM

148: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
149: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
150: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
151: , program_application_id NUMBER := FND_API.G_MISS_NUM
152: , program_id NUMBER := FND_API.G_MISS_NUM
153: , program_update_date DATE := FND_API.G_MISS_DATE
154: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
155: , related_item_id NUMBER := FND_API.G_MISS_NUM
156: , relationship_type_id NUMBER := FND_API.G_MISS_NUM

Line 153: , program_update_date DATE := FND_API.G_MISS_DATE

149: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
150: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
151: , program_application_id NUMBER := FND_API.G_MISS_NUM
152: , program_id NUMBER := FND_API.G_MISS_NUM
153: , program_update_date DATE := FND_API.G_MISS_DATE
154: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
155: , related_item_id NUMBER := FND_API.G_MISS_NUM
156: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
157: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 154: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

150: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
151: , program_application_id NUMBER := FND_API.G_MISS_NUM
152: , program_id NUMBER := FND_API.G_MISS_NUM
153: , program_update_date DATE := FND_API.G_MISS_DATE
154: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
155: , related_item_id NUMBER := FND_API.G_MISS_NUM
156: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
157: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
158: , request_id NUMBER := FND_API.G_MISS_NUM

Line 155: , related_item_id NUMBER := FND_API.G_MISS_NUM

151: , program_application_id NUMBER := FND_API.G_MISS_NUM
152: , program_id NUMBER := FND_API.G_MISS_NUM
153: , program_update_date DATE := FND_API.G_MISS_DATE
154: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
155: , related_item_id NUMBER := FND_API.G_MISS_NUM
156: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
157: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
158: , request_id NUMBER := FND_API.G_MISS_NUM
159: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR

Line 156: , relationship_type_id NUMBER := FND_API.G_MISS_NUM

152: , program_id NUMBER := FND_API.G_MISS_NUM
153: , program_update_date DATE := FND_API.G_MISS_DATE
154: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
155: , related_item_id NUMBER := FND_API.G_MISS_NUM
156: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
157: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
158: , request_id NUMBER := FND_API.G_MISS_NUM
159: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
160: , revision_date DATE := FND_API.G_MISS_DATE

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

153: , program_update_date DATE := FND_API.G_MISS_DATE
154: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
155: , related_item_id NUMBER := FND_API.G_MISS_NUM
156: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
157: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
158: , request_id NUMBER := FND_API.G_MISS_NUM
159: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
160: , revision_date DATE := FND_API.G_MISS_DATE
161: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 158: , request_id NUMBER := FND_API.G_MISS_NUM

154: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
155: , related_item_id NUMBER := FND_API.G_MISS_NUM
156: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
157: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
158: , request_id NUMBER := FND_API.G_MISS_NUM
159: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
160: , revision_date DATE := FND_API.G_MISS_DATE
161: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
162: , start_date_active DATE := FND_API.G_MISS_DATE

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

155: , related_item_id NUMBER := FND_API.G_MISS_NUM
156: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
157: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
158: , request_id NUMBER := FND_API.G_MISS_NUM
159: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
160: , revision_date DATE := FND_API.G_MISS_DATE
161: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
162: , start_date_active DATE := FND_API.G_MISS_DATE
163: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 160: , revision_date DATE := FND_API.G_MISS_DATE

156: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
157: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
158: , request_id NUMBER := FND_API.G_MISS_NUM
159: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
160: , revision_date DATE := FND_API.G_MISS_DATE
161: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
162: , start_date_active DATE := FND_API.G_MISS_DATE
163: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
164: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR

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

157: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
158: , request_id NUMBER := FND_API.G_MISS_NUM
159: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
160: , revision_date DATE := FND_API.G_MISS_DATE
161: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
162: , start_date_active DATE := FND_API.G_MISS_DATE
163: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
164: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
165: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 162: , start_date_active DATE := FND_API.G_MISS_DATE

158: , request_id NUMBER := FND_API.G_MISS_NUM
159: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
160: , revision_date DATE := FND_API.G_MISS_DATE
161: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
162: , start_date_active DATE := FND_API.G_MISS_DATE
163: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
164: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
165: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
166: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

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

159: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
160: , revision_date DATE := FND_API.G_MISS_DATE
161: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
162: , start_date_active DATE := FND_API.G_MISS_DATE
163: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
164: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
165: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
166: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
167: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 164: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR

160: , revision_date DATE := FND_API.G_MISS_DATE
161: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
162: , start_date_active DATE := FND_API.G_MISS_DATE
163: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
164: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
165: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
166: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
167: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
168: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 165: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR

161: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
162: , start_date_active DATE := FND_API.G_MISS_DATE
163: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
164: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
165: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
166: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
167: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
168: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
169: , rltd_modifier_id NUMBER := FND_API.G_MISS_NUM

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

162: , start_date_active DATE := FND_API.G_MISS_DATE
163: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
164: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
165: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
166: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
167: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
168: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
169: , rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
170: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM

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

163: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
164: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
165: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
166: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
167: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
168: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
169: , rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
170: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
171: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM

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

164: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
165: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
166: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
167: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
168: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
169: , rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
170: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
171: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
172: , rltd_modifier_group_no NUMBER := FND_API.G_MISS_NUM

Line 169: , rltd_modifier_id NUMBER := FND_API.G_MISS_NUM

165: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
166: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
167: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
168: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
169: , rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
170: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
171: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
172: , rltd_modifier_group_no NUMBER := FND_API.G_MISS_NUM
173: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 170: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM

166: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
167: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
168: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
169: , rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
170: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
171: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
172: , rltd_modifier_group_no NUMBER := FND_API.G_MISS_NUM
173: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
174: , product_precedence NUMBER := FND_API.G_MISS_NUM

Line 171: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM

167: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
168: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
169: , rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
170: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
171: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
172: , rltd_modifier_group_no NUMBER := FND_API.G_MISS_NUM
173: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
174: , product_precedence NUMBER := FND_API.G_MISS_NUM
175: , PRICE_BREAK_HEADER_index NUMBER := FND_API.G_MISS_NUM

Line 172: , rltd_modifier_group_no NUMBER := FND_API.G_MISS_NUM

168: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
169: , rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
170: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
171: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
172: , rltd_modifier_group_no NUMBER := FND_API.G_MISS_NUM
173: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
174: , product_precedence NUMBER := FND_API.G_MISS_NUM
175: , PRICE_BREAK_HEADER_index NUMBER := FND_API.G_MISS_NUM
176: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR -- bug 4199398

Line 173: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR

169: , rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
170: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
171: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
172: , rltd_modifier_group_no NUMBER := FND_API.G_MISS_NUM
173: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
174: , product_precedence NUMBER := FND_API.G_MISS_NUM
175: , PRICE_BREAK_HEADER_index NUMBER := FND_API.G_MISS_NUM
176: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR -- bug 4199398
177: , qualification_ind NUMBER := FND_API.G_MISS_NUM --Euro Bug 2138996.

Line 174: , product_precedence NUMBER := FND_API.G_MISS_NUM

170: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
171: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
172: , rltd_modifier_group_no NUMBER := FND_API.G_MISS_NUM
173: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
174: , product_precedence NUMBER := FND_API.G_MISS_NUM
175: , PRICE_BREAK_HEADER_index NUMBER := FND_API.G_MISS_NUM
176: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR -- bug 4199398
177: , qualification_ind NUMBER := FND_API.G_MISS_NUM --Euro Bug 2138996.
178: , recurring_value NUMBER := FND_API.G_MISS_NUM -- block pricing

Line 175: , PRICE_BREAK_HEADER_index NUMBER := FND_API.G_MISS_NUM

171: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
172: , rltd_modifier_group_no NUMBER := FND_API.G_MISS_NUM
173: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
174: , product_precedence NUMBER := FND_API.G_MISS_NUM
175: , PRICE_BREAK_HEADER_index NUMBER := FND_API.G_MISS_NUM
176: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR -- bug 4199398
177: , qualification_ind NUMBER := FND_API.G_MISS_NUM --Euro Bug 2138996.
178: , recurring_value NUMBER := FND_API.G_MISS_NUM -- block pricing
179: , customer_item_id NUMBER := FND_API.G_MISS_NUM

Line 176: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR -- bug 4199398

172: , rltd_modifier_group_no NUMBER := FND_API.G_MISS_NUM
173: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
174: , product_precedence NUMBER := FND_API.G_MISS_NUM
175: , PRICE_BREAK_HEADER_index NUMBER := FND_API.G_MISS_NUM
176: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR -- bug 4199398
177: , qualification_ind NUMBER := FND_API.G_MISS_NUM --Euro Bug 2138996.
178: , recurring_value NUMBER := FND_API.G_MISS_NUM -- block pricing
179: , customer_item_id NUMBER := FND_API.G_MISS_NUM
180: , break_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR -- OKS proration

Line 177: , qualification_ind NUMBER := FND_API.G_MISS_NUM --Euro Bug 2138996.

173: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
174: , product_precedence NUMBER := FND_API.G_MISS_NUM
175: , PRICE_BREAK_HEADER_index NUMBER := FND_API.G_MISS_NUM
176: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR -- bug 4199398
177: , qualification_ind NUMBER := FND_API.G_MISS_NUM --Euro Bug 2138996.
178: , recurring_value NUMBER := FND_API.G_MISS_NUM -- block pricing
179: , customer_item_id NUMBER := FND_API.G_MISS_NUM
180: , break_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR -- OKS proration
181: , break_uom_context VARCHAR2(30) := FND_API.G_MISS_CHAR -- OKS proration

Line 178: , recurring_value NUMBER := FND_API.G_MISS_NUM -- block pricing

174: , product_precedence NUMBER := FND_API.G_MISS_NUM
175: , PRICE_BREAK_HEADER_index NUMBER := FND_API.G_MISS_NUM
176: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR -- bug 4199398
177: , qualification_ind NUMBER := FND_API.G_MISS_NUM --Euro Bug 2138996.
178: , recurring_value NUMBER := FND_API.G_MISS_NUM -- block pricing
179: , customer_item_id NUMBER := FND_API.G_MISS_NUM
180: , break_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR -- OKS proration
181: , break_uom_context VARCHAR2(30) := FND_API.G_MISS_CHAR -- OKS proration
182: , break_uom_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR -- OKS proration

Line 179: , customer_item_id NUMBER := FND_API.G_MISS_NUM

175: , PRICE_BREAK_HEADER_index NUMBER := FND_API.G_MISS_NUM
176: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR -- bug 4199398
177: , qualification_ind NUMBER := FND_API.G_MISS_NUM --Euro Bug 2138996.
178: , recurring_value NUMBER := FND_API.G_MISS_NUM -- block pricing
179: , customer_item_id NUMBER := FND_API.G_MISS_NUM
180: , break_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR -- OKS proration
181: , break_uom_context VARCHAR2(30) := FND_API.G_MISS_CHAR -- OKS proration
182: , break_uom_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR -- OKS proration
183: , continuous_price_break_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Continuous Price Breaks

Line 180: , break_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR -- OKS proration

176: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR -- bug 4199398
177: , qualification_ind NUMBER := FND_API.G_MISS_NUM --Euro Bug 2138996.
178: , recurring_value NUMBER := FND_API.G_MISS_NUM -- block pricing
179: , customer_item_id NUMBER := FND_API.G_MISS_NUM
180: , break_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR -- OKS proration
181: , break_uom_context VARCHAR2(30) := FND_API.G_MISS_CHAR -- OKS proration
182: , break_uom_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR -- OKS proration
183: , continuous_price_break_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Continuous Price Breaks
184: );

Line 181: , break_uom_context VARCHAR2(30) := FND_API.G_MISS_CHAR -- OKS proration

177: , qualification_ind NUMBER := FND_API.G_MISS_NUM --Euro Bug 2138996.
178: , recurring_value NUMBER := FND_API.G_MISS_NUM -- block pricing
179: , customer_item_id NUMBER := FND_API.G_MISS_NUM
180: , break_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR -- OKS proration
181: , break_uom_context VARCHAR2(30) := FND_API.G_MISS_CHAR -- OKS proration
182: , break_uom_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR -- OKS proration
183: , continuous_price_break_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Continuous Price Breaks
184: );
185:

Line 182: , break_uom_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR -- OKS proration

178: , recurring_value NUMBER := FND_API.G_MISS_NUM -- block pricing
179: , customer_item_id NUMBER := FND_API.G_MISS_NUM
180: , break_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR -- OKS proration
181: , break_uom_context VARCHAR2(30) := FND_API.G_MISS_CHAR -- OKS proration
182: , break_uom_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR -- OKS proration
183: , continuous_price_break_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Continuous Price Breaks
184: );
185:
186: TYPE Price_List_Line_Tbl_Type IS TABLE OF Price_List_Line_Rec_Type

Line 183: , continuous_price_break_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Continuous Price Breaks

179: , customer_item_id NUMBER := FND_API.G_MISS_NUM
180: , break_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR -- OKS proration
181: , break_uom_context VARCHAR2(30) := FND_API.G_MISS_CHAR -- OKS proration
182: , break_uom_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR -- OKS proration
183: , continuous_price_break_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Continuous Price Breaks
184: );
185:
186: TYPE Price_List_Line_Tbl_Type IS TABLE OF Price_List_Line_Rec_Type
187: INDEX BY BINARY_INTEGER;

Line 192: ( accrual_uom VARCHAR2(240) := FND_API.G_MISS_CHAR

188:
189: -- Price_List_Line value record type
190:
191: TYPE Price_List_Line_Val_Rec_Type IS RECORD
192: ( accrual_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
193: , automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
194: , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
195: , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 193: , automatic VARCHAR2(240) := FND_API.G_MISS_CHAR

189: -- Price_List_Line value record type
190:
191: TYPE Price_List_Line_Val_Rec_Type IS RECORD
192: ( accrual_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
193: , automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
194: , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
195: , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 194: , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR

190:
191: TYPE Price_List_Line_Val_Rec_Type IS RECORD
192: ( accrual_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
193: , automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
194: , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
195: , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR

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

191: TYPE Price_List_Line_Val_Rec_Type IS RECORD
192: ( accrual_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
193: , automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
194: , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
195: , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR

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

192: ( accrual_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
193: , automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
194: , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
195: , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR

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

193: , automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
194: , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
195: , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR

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

194: , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
195: , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , override VARCHAR2(240) := FND_API.G_MISS_CHAR

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

195: , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR

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

196: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR

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

197: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR

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

198: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR

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

199: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR

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

200: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR

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

201: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR

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

202: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR

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

203: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
211: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR

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

204: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
211: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
212: );

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

205: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
211: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
212: );
213:

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

206: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
211: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
212: );
213:
214: TYPE Price_List_Line_Val_Tbl_Type IS TABLE OF Price_List_Line_Val_Rec_Type

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

207: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
211: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
212: );
213:
214: TYPE Price_List_Line_Val_Tbl_Type IS TABLE OF Price_List_Line_Val_Rec_Type
215: INDEX BY BINARY_INTEGER;

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

216:
217: -- Pricing_Attr record type
218:
219: TYPE Pricing_Attr_Rec_Type IS RECORD
220: ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
221: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

217: -- Pricing_Attr record type
218:
219: TYPE Pricing_Attr_Rec_Type IS RECORD
220: ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
221: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

218:
219: TYPE Pricing_Attr_Rec_Type IS RECORD
220: ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
221: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

219: TYPE Pricing_Attr_Rec_Type IS RECORD
220: ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
221: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

220: ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
221: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

221: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

222: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

223: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

224: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

225: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

226: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
234: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

227: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
234: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
235: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

228: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
234: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
235: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
236: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM

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

229: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
234: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
235: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
236: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
237: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

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

230: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
234: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
235: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
236: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
237: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
238: , created_by NUMBER := FND_API.G_MISS_NUM

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

231: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
234: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
235: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
236: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
237: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
238: , created_by NUMBER := FND_API.G_MISS_NUM
239: , creation_date DATE := FND_API.G_MISS_DATE

Line 236: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM

232: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
234: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
235: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
236: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
237: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
238: , created_by NUMBER := FND_API.G_MISS_NUM
239: , creation_date DATE := FND_API.G_MISS_DATE
240: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

233: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
234: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
235: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
236: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
237: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
238: , created_by NUMBER := FND_API.G_MISS_NUM
239: , creation_date DATE := FND_API.G_MISS_DATE
240: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
241: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 238: , created_by NUMBER := FND_API.G_MISS_NUM

234: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
235: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
236: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
237: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
238: , created_by NUMBER := FND_API.G_MISS_NUM
239: , creation_date DATE := FND_API.G_MISS_DATE
240: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
241: , last_updated_by NUMBER := FND_API.G_MISS_NUM
242: , last_update_date DATE := FND_API.G_MISS_DATE

Line 239: , creation_date DATE := FND_API.G_MISS_DATE

235: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
236: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
237: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
238: , created_by NUMBER := FND_API.G_MISS_NUM
239: , creation_date DATE := FND_API.G_MISS_DATE
240: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
241: , last_updated_by NUMBER := FND_API.G_MISS_NUM
242: , last_update_date DATE := FND_API.G_MISS_DATE
243: , last_update_login NUMBER := FND_API.G_MISS_NUM

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

236: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
237: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
238: , created_by NUMBER := FND_API.G_MISS_NUM
239: , creation_date DATE := FND_API.G_MISS_DATE
240: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
241: , last_updated_by NUMBER := FND_API.G_MISS_NUM
242: , last_update_date DATE := FND_API.G_MISS_DATE
243: , last_update_login NUMBER := FND_API.G_MISS_NUM
244: , list_line_id NUMBER := FND_API.G_MISS_NUM

Line 241: , last_updated_by NUMBER := FND_API.G_MISS_NUM

237: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
238: , created_by NUMBER := FND_API.G_MISS_NUM
239: , creation_date DATE := FND_API.G_MISS_DATE
240: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
241: , last_updated_by NUMBER := FND_API.G_MISS_NUM
242: , last_update_date DATE := FND_API.G_MISS_DATE
243: , last_update_login NUMBER := FND_API.G_MISS_NUM
244: , list_line_id NUMBER := FND_API.G_MISS_NUM
245: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 242: , last_update_date DATE := FND_API.G_MISS_DATE

238: , created_by NUMBER := FND_API.G_MISS_NUM
239: , creation_date DATE := FND_API.G_MISS_DATE
240: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
241: , last_updated_by NUMBER := FND_API.G_MISS_NUM
242: , last_update_date DATE := FND_API.G_MISS_DATE
243: , last_update_login NUMBER := FND_API.G_MISS_NUM
244: , list_line_id NUMBER := FND_API.G_MISS_NUM
245: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
246: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 243: , last_update_login NUMBER := FND_API.G_MISS_NUM

239: , creation_date DATE := FND_API.G_MISS_DATE
240: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
241: , last_updated_by NUMBER := FND_API.G_MISS_NUM
242: , last_update_date DATE := FND_API.G_MISS_DATE
243: , last_update_login NUMBER := FND_API.G_MISS_NUM
244: , list_line_id NUMBER := FND_API.G_MISS_NUM
245: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
246: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
247: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM

Line 244: , list_line_id NUMBER := FND_API.G_MISS_NUM

240: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
241: , last_updated_by NUMBER := FND_API.G_MISS_NUM
242: , last_update_date DATE := FND_API.G_MISS_DATE
243: , last_update_login NUMBER := FND_API.G_MISS_NUM
244: , list_line_id NUMBER := FND_API.G_MISS_NUM
245: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
246: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
247: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
248: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR

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

241: , last_updated_by NUMBER := FND_API.G_MISS_NUM
242: , last_update_date DATE := FND_API.G_MISS_DATE
243: , last_update_login NUMBER := FND_API.G_MISS_NUM
244: , list_line_id NUMBER := FND_API.G_MISS_NUM
245: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
246: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
247: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
248: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
249: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR

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

242: , last_update_date DATE := FND_API.G_MISS_DATE
243: , last_update_login NUMBER := FND_API.G_MISS_NUM
244: , list_line_id NUMBER := FND_API.G_MISS_NUM
245: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
246: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
247: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
248: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
249: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 247: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM

243: , last_update_login NUMBER := FND_API.G_MISS_NUM
244: , list_line_id NUMBER := FND_API.G_MISS_NUM
245: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
246: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
247: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
248: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
249: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
251: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR

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

244: , list_line_id NUMBER := FND_API.G_MISS_NUM
245: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
246: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
247: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
248: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
249: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
251: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
252: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR

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

245: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
246: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
247: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
248: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
249: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
251: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
252: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
253: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR

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

246: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
247: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
248: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
249: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
251: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
252: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
253: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
254: , program_application_id NUMBER := FND_API.G_MISS_NUM

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

247: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
248: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
249: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
251: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
252: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
253: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
254: , program_application_id NUMBER := FND_API.G_MISS_NUM
255: , program_id NUMBER := FND_API.G_MISS_NUM

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

248: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
249: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
251: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
252: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
253: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
254: , program_application_id NUMBER := FND_API.G_MISS_NUM
255: , program_id NUMBER := FND_API.G_MISS_NUM
256: , program_update_date DATE := FND_API.G_MISS_DATE

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

249: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
251: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
252: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
253: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
254: , program_application_id NUMBER := FND_API.G_MISS_NUM
255: , program_id NUMBER := FND_API.G_MISS_NUM
256: , program_update_date DATE := FND_API.G_MISS_DATE
257: , request_id NUMBER := FND_API.G_MISS_NUM

Line 254: , program_application_id NUMBER := FND_API.G_MISS_NUM

250: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
251: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
252: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
253: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
254: , program_application_id NUMBER := FND_API.G_MISS_NUM
255: , program_id NUMBER := FND_API.G_MISS_NUM
256: , program_update_date DATE := FND_API.G_MISS_DATE
257: , request_id NUMBER := FND_API.G_MISS_NUM
258: , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM

Line 255: , program_id NUMBER := FND_API.G_MISS_NUM

251: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
252: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
253: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
254: , program_application_id NUMBER := FND_API.G_MISS_NUM
255: , program_id NUMBER := FND_API.G_MISS_NUM
256: , program_update_date DATE := FND_API.G_MISS_DATE
257: , request_id NUMBER := FND_API.G_MISS_NUM
258: , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
259: , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM

Line 256: , program_update_date DATE := FND_API.G_MISS_DATE

252: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
253: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
254: , program_application_id NUMBER := FND_API.G_MISS_NUM
255: , program_id NUMBER := FND_API.G_MISS_NUM
256: , program_update_date DATE := FND_API.G_MISS_DATE
257: , request_id NUMBER := FND_API.G_MISS_NUM
258: , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
259: , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
260: , qualification_ind NUMBER := FND_API.G_MISS_NUM

Line 257: , request_id NUMBER := FND_API.G_MISS_NUM

253: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
254: , program_application_id NUMBER := FND_API.G_MISS_NUM
255: , program_id NUMBER := FND_API.G_MISS_NUM
256: , program_update_date DATE := FND_API.G_MISS_DATE
257: , request_id NUMBER := FND_API.G_MISS_NUM
258: , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
259: , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
260: , qualification_ind NUMBER := FND_API.G_MISS_NUM
261: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 258: , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM

254: , program_application_id NUMBER := FND_API.G_MISS_NUM
255: , program_id NUMBER := FND_API.G_MISS_NUM
256: , program_update_date DATE := FND_API.G_MISS_DATE
257: , request_id NUMBER := FND_API.G_MISS_NUM
258: , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
259: , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
260: , qualification_ind NUMBER := FND_API.G_MISS_NUM
261: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
262: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 259: , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM

255: , program_id NUMBER := FND_API.G_MISS_NUM
256: , program_update_date DATE := FND_API.G_MISS_DATE
257: , request_id NUMBER := FND_API.G_MISS_NUM
258: , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
259: , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
260: , qualification_ind NUMBER := FND_API.G_MISS_NUM
261: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
262: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
263: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 260: , qualification_ind NUMBER := FND_API.G_MISS_NUM

256: , program_update_date DATE := FND_API.G_MISS_DATE
257: , request_id NUMBER := FND_API.G_MISS_NUM
258: , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
259: , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
260: , qualification_ind NUMBER := FND_API.G_MISS_NUM
261: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
262: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
263: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
264: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM

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

257: , request_id NUMBER := FND_API.G_MISS_NUM
258: , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
259: , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
260: , qualification_ind NUMBER := FND_API.G_MISS_NUM
261: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
262: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
263: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
264: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM
265: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM

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

258: , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
259: , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
260: , qualification_ind NUMBER := FND_API.G_MISS_NUM
261: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
262: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
263: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
264: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM
265: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
266: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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

259: , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
260: , qualification_ind NUMBER := FND_API.G_MISS_NUM
261: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
262: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
263: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
264: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM
265: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
266: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
267: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 264: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM

260: , qualification_ind NUMBER := FND_API.G_MISS_NUM
261: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
262: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
263: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
264: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM
265: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
266: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
267: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
268: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 265: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM

261: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
262: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
263: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
264: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM
265: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
266: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
267: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
268: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
269: , list_header_id NUMBER := FND_API.G_MISS_NUM

Line 266: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR

262: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
263: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
264: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM
265: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
266: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
267: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
268: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
269: , list_header_id NUMBER := FND_API.G_MISS_NUM
270: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM

Line 267: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR

263: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
264: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM
265: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
266: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
267: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
268: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
269: , list_header_id NUMBER := FND_API.G_MISS_NUM
270: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
271: );

Line 268: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR

264: , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM
265: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
266: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
267: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
268: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
269: , list_header_id NUMBER := FND_API.G_MISS_NUM
270: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
271: );
272:

Line 269: , list_header_id NUMBER := FND_API.G_MISS_NUM

265: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
266: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
267: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
268: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
269: , list_header_id NUMBER := FND_API.G_MISS_NUM
270: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
271: );
272:
273: TYPE Pricing_Attr_Tbl_Type IS TABLE OF Pricing_Attr_Rec_Type

Line 270: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM

266: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
267: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
268: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
269: , list_header_id NUMBER := FND_API.G_MISS_NUM
270: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
271: );
272:
273: TYPE Pricing_Attr_Tbl_Type IS TABLE OF Pricing_Attr_Rec_Type
274: INDEX BY BINARY_INTEGER;

Line 279: ( accumulate VARCHAR2(240) := FND_API.G_MISS_CHAR

275:
276: -- Pricing_Attr value record type
277:
278: TYPE Pricing_Attr_Val_Rec_Type IS RECORD
279: ( accumulate VARCHAR2(240) := FND_API.G_MISS_CHAR
280: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
281: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
282: , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
283: , pricing_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 280: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR

276: -- Pricing_Attr value record type
277:
278: TYPE Pricing_Attr_Val_Rec_Type IS RECORD
279: ( accumulate VARCHAR2(240) := FND_API.G_MISS_CHAR
280: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
281: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
282: , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
283: , pricing_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
284: , pricing_attr_value_from_desc VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 281: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR

277:
278: TYPE Pricing_Attr_Val_Rec_Type IS RECORD
279: ( accumulate VARCHAR2(240) := FND_API.G_MISS_CHAR
280: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
281: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
282: , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
283: , pricing_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
284: , pricing_attr_value_from_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
285: , pricing_attr_value_to_desc VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 282: , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR

278: TYPE Pricing_Attr_Val_Rec_Type IS RECORD
279: ( accumulate VARCHAR2(240) := FND_API.G_MISS_CHAR
280: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
281: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
282: , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
283: , pricing_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
284: , pricing_attr_value_from_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
285: , pricing_attr_value_to_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
286: );

Line 283: , pricing_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR

279: ( accumulate VARCHAR2(240) := FND_API.G_MISS_CHAR
280: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
281: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
282: , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
283: , pricing_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
284: , pricing_attr_value_from_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
285: , pricing_attr_value_to_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
286: );
287:

Line 284: , pricing_attr_value_from_desc VARCHAR2(240) := FND_API.G_MISS_CHAR

280: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
281: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
282: , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
283: , pricing_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
284: , pricing_attr_value_from_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
285: , pricing_attr_value_to_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
286: );
287:
288: TYPE Pricing_Attr_Val_Tbl_Type IS TABLE OF Pricing_Attr_Val_Rec_Type

Line 285: , pricing_attr_value_to_desc VARCHAR2(240) := FND_API.G_MISS_CHAR

281: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
282: , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
283: , pricing_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
284: , pricing_attr_value_from_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
285: , pricing_attr_value_to_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
286: );
287:
288: TYPE Pricing_Attr_Val_Tbl_Type IS TABLE OF Pricing_Attr_Val_Rec_Type
289: INDEX BY BINARY_INTEGER;

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

373: * @rep:displayname Process Price List
374: */
375: PROCEDURE Process_Price_List
376: ( p_api_version_number IN NUMBER
377: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
378: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
379: , p_commit IN VARCHAR2 := FND_API.G_FALSE
380: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
381: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

374: */
375: PROCEDURE Process_Price_List
376: ( p_api_version_number IN NUMBER
377: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
378: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
379: , p_commit IN VARCHAR2 := FND_API.G_FALSE
380: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
381: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
382: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

375: PROCEDURE Process_Price_List
376: ( p_api_version_number IN NUMBER
377: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
378: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
379: , p_commit IN VARCHAR2 := FND_API.G_FALSE
380: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
381: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
382: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
383: , p_PRICE_LIST_rec IN Price_List_Rec_Type :=

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

425: -- End of Comments
426:
427: PROCEDURE Lock_Price_List
428: ( p_api_version_number IN NUMBER
429: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
430: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
431: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
432: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
433: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

426:
427: PROCEDURE Lock_Price_List
428: ( p_api_version_number IN NUMBER
429: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
430: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
431: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
432: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
433: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
434: , p_PRICE_LIST_rec IN Price_List_Rec_Type :=

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

474: -- End of Comments
475:
476: PROCEDURE Get_Price_List
477: ( p_api_version_number IN NUMBER
478: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
479: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
480: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
481: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
482: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

475:
476: PROCEDURE Get_Price_List
477: ( p_api_version_number IN NUMBER
478: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
479: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
480: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
481: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
482: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
483: , p_list_header_id IN NUMBER :=

Line 484: FND_API.G_MISS_NUM

480: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
481: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
482: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
483: , p_list_header_id IN NUMBER :=
484: FND_API.G_MISS_NUM
485: , p_list_header IN VARCHAR2 :=
486: FND_API.G_MISS_CHAR
487: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Rec_Type
488: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Val_Rec_Type

Line 486: FND_API.G_MISS_CHAR

482: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
483: , p_list_header_id IN NUMBER :=
484: FND_API.G_MISS_NUM
485: , p_list_header IN VARCHAR2 :=
486: FND_API.G_MISS_CHAR
487: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Rec_Type
488: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Val_Rec_Type
489: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Tbl_Type
490: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Val_Tbl_Type