eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_MODIFIERS_PUB dependencies on FND_API

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

10: */
11:
12: -- Modifier_List record type
13: TYPE Modifier_List_Rec_Type IS RECORD
14: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 32: , created_by NUMBER := FND_API.G_MISS_NUM

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

Line 33: , creation_date DATE := FND_API.G_MISS_DATE

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

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

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

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

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

Line 36: , end_date_active DATE := FND_API.G_MISS_DATE

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

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

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

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

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

Line 39: , last_updated_by NUMBER := FND_API.G_MISS_NUM

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

Line 40: , last_update_date DATE := FND_API.G_MISS_DATE

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

Line 41: , last_update_login NUMBER := FND_API.G_MISS_NUM

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

Line 42: , list_header_id NUMBER := FND_API.G_MISS_NUM

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

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

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

Line 44: , program_application_id NUMBER := FND_API.G_MISS_NUM

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

Line 45: , program_id NUMBER := FND_API.G_MISS_NUM

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

Line 46: , program_update_date DATE := FND_API.G_MISS_DATE

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

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

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

Line 48: , request_id NUMBER := FND_API.G_MISS_NUM

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

Line 49: , rounding_factor NUMBER := FND_API.G_MISS_NUM

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

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

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

Line 51: , start_date_active DATE := FND_API.G_MISS_DATE

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

Line 52: , terms_id NUMBER := FND_API.G_MISS_NUM

48: , request_id NUMBER := FND_API.G_MISS_NUM
49: , rounding_factor NUMBER := FND_API.G_MISS_NUM
50: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
51: , start_date_active DATE := FND_API.G_MISS_DATE
52: , terms_id NUMBER := FND_API.G_MISS_NUM
53: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
54: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
55: , parent_list_header_id NUMBER := FND_API.G_MISS_NUM
56: , start_date_active_first DATE := FND_API.G_MISS_DATE

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

49: , rounding_factor NUMBER := FND_API.G_MISS_NUM
50: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
51: , start_date_active DATE := FND_API.G_MISS_DATE
52: , terms_id NUMBER := FND_API.G_MISS_NUM
53: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
54: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
55: , parent_list_header_id NUMBER := FND_API.G_MISS_NUM
56: , start_date_active_first DATE := FND_API.G_MISS_DATE
57: , end_date_active_first DATE := FND_API.G_MISS_DATE

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

50: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
51: , start_date_active DATE := FND_API.G_MISS_DATE
52: , terms_id NUMBER := FND_API.G_MISS_NUM
53: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
54: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
55: , parent_list_header_id NUMBER := FND_API.G_MISS_NUM
56: , start_date_active_first DATE := FND_API.G_MISS_DATE
57: , end_date_active_first DATE := FND_API.G_MISS_DATE
58: , active_date_first_type VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 55: , parent_list_header_id NUMBER := FND_API.G_MISS_NUM

51: , start_date_active DATE := FND_API.G_MISS_DATE
52: , terms_id NUMBER := FND_API.G_MISS_NUM
53: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
54: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
55: , parent_list_header_id NUMBER := FND_API.G_MISS_NUM
56: , start_date_active_first DATE := FND_API.G_MISS_DATE
57: , end_date_active_first DATE := FND_API.G_MISS_DATE
58: , active_date_first_type VARCHAR2(30) := FND_API.G_MISS_CHAR
59: , start_date_active_second DATE := FND_API.G_MISS_DATE

Line 56: , start_date_active_first DATE := FND_API.G_MISS_DATE

52: , terms_id NUMBER := FND_API.G_MISS_NUM
53: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
54: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
55: , parent_list_header_id NUMBER := FND_API.G_MISS_NUM
56: , start_date_active_first DATE := FND_API.G_MISS_DATE
57: , end_date_active_first DATE := FND_API.G_MISS_DATE
58: , active_date_first_type VARCHAR2(30) := FND_API.G_MISS_CHAR
59: , start_date_active_second DATE := FND_API.G_MISS_DATE
60: , global_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 57: , end_date_active_first DATE := FND_API.G_MISS_DATE

53: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
54: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
55: , parent_list_header_id NUMBER := FND_API.G_MISS_NUM
56: , start_date_active_first DATE := FND_API.G_MISS_DATE
57: , end_date_active_first DATE := FND_API.G_MISS_DATE
58: , active_date_first_type VARCHAR2(30) := FND_API.G_MISS_CHAR
59: , start_date_active_second DATE := FND_API.G_MISS_DATE
60: , global_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
61: , end_date_active_second DATE := FND_API.G_MISS_DATE

Line 58: , active_date_first_type VARCHAR2(30) := FND_API.G_MISS_CHAR

54: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
55: , parent_list_header_id NUMBER := FND_API.G_MISS_NUM
56: , start_date_active_first DATE := FND_API.G_MISS_DATE
57: , end_date_active_first DATE := FND_API.G_MISS_DATE
58: , active_date_first_type VARCHAR2(30) := FND_API.G_MISS_CHAR
59: , start_date_active_second DATE := FND_API.G_MISS_DATE
60: , global_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
61: , end_date_active_second DATE := FND_API.G_MISS_DATE
62: , active_date_second_type VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 59: , start_date_active_second DATE := FND_API.G_MISS_DATE

55: , parent_list_header_id NUMBER := FND_API.G_MISS_NUM
56: , start_date_active_first DATE := FND_API.G_MISS_DATE
57: , end_date_active_first DATE := FND_API.G_MISS_DATE
58: , active_date_first_type VARCHAR2(30) := FND_API.G_MISS_CHAR
59: , start_date_active_second DATE := FND_API.G_MISS_DATE
60: , global_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
61: , end_date_active_second DATE := FND_API.G_MISS_DATE
62: , active_date_second_type VARCHAR2(30) := FND_API.G_MISS_CHAR
63: , ask_for_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

56: , start_date_active_first DATE := FND_API.G_MISS_DATE
57: , end_date_active_first DATE := FND_API.G_MISS_DATE
58: , active_date_first_type VARCHAR2(30) := FND_API.G_MISS_CHAR
59: , start_date_active_second DATE := FND_API.G_MISS_DATE
60: , global_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
61: , end_date_active_second DATE := FND_API.G_MISS_DATE
62: , active_date_second_type VARCHAR2(30) := FND_API.G_MISS_CHAR
63: , ask_for_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
64: , name VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 61: , end_date_active_second DATE := FND_API.G_MISS_DATE

57: , end_date_active_first DATE := FND_API.G_MISS_DATE
58: , active_date_first_type VARCHAR2(30) := FND_API.G_MISS_CHAR
59: , start_date_active_second DATE := FND_API.G_MISS_DATE
60: , global_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
61: , end_date_active_second DATE := FND_API.G_MISS_DATE
62: , active_date_second_type VARCHAR2(30) := FND_API.G_MISS_CHAR
63: , ask_for_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
64: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
65: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR

Line 62: , active_date_second_type VARCHAR2(30) := FND_API.G_MISS_CHAR

58: , active_date_first_type VARCHAR2(30) := FND_API.G_MISS_CHAR
59: , start_date_active_second DATE := FND_API.G_MISS_DATE
60: , global_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
61: , end_date_active_second DATE := FND_API.G_MISS_DATE
62: , active_date_second_type VARCHAR2(30) := FND_API.G_MISS_CHAR
63: , ask_for_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
64: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
65: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
66: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 63: , ask_for_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

59: , start_date_active_second DATE := FND_API.G_MISS_DATE
60: , global_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
61: , end_date_active_second DATE := FND_API.G_MISS_DATE
62: , active_date_second_type VARCHAR2(30) := FND_API.G_MISS_CHAR
63: , ask_for_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
64: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
65: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
66: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
67: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

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

60: , global_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
61: , end_date_active_second DATE := FND_API.G_MISS_DATE
62: , active_date_second_type VARCHAR2(30) := FND_API.G_MISS_CHAR
63: , ask_for_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
64: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
65: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
66: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
67: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
68: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

61: , end_date_active_second DATE := FND_API.G_MISS_DATE
62: , active_date_second_type VARCHAR2(30) := FND_API.G_MISS_CHAR
63: , ask_for_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
64: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
65: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
66: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
67: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
68: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
69: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

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

62: , active_date_second_type VARCHAR2(30) := FND_API.G_MISS_CHAR
63: , ask_for_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
64: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
65: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
66: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
67: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
68: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
69: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
70: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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

63: , ask_for_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
64: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
65: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
66: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
67: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
68: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
69: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
70: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
71: , list_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Blanket Pricing

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

64: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
65: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
66: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
67: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
68: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
69: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
70: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
71: , list_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Blanket Pricing
72: , orig_system_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR -- Blanket Pricing

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

65: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
66: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
67: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
68: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
69: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
70: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
71: , list_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Blanket Pricing
72: , orig_system_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR -- Blanket Pricing
73: , shareable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Blanket Pricing

Line 70: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR

66: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
67: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
68: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
69: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
70: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
71: , list_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Blanket Pricing
72: , orig_system_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR -- Blanket Pricing
73: , shareable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Blanket Pricing
74: --added for MOAC support

Line 71: , list_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Blanket Pricing

67: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
68: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
69: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
70: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
71: , list_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Blanket Pricing
72: , orig_system_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR -- Blanket Pricing
73: , shareable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Blanket Pricing
74: --added for MOAC support
75: , org_id NUMBER := FND_API.G_MISS_NUM

Line 72: , orig_system_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR -- Blanket Pricing

68: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
69: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
70: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
71: , list_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Blanket Pricing
72: , orig_system_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR -- Blanket Pricing
73: , shareable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Blanket Pricing
74: --added for MOAC support
75: , org_id NUMBER := FND_API.G_MISS_NUM
76: );

Line 73: , shareable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Blanket Pricing

69: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
70: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
71: , list_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Blanket Pricing
72: , orig_system_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR -- Blanket Pricing
73: , shareable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Blanket Pricing
74: --added for MOAC support
75: , org_id NUMBER := FND_API.G_MISS_NUM
76: );
77:

Line 75: , org_id NUMBER := FND_API.G_MISS_NUM

71: , list_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Blanket Pricing
72: , orig_system_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR -- Blanket Pricing
73: , shareable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Blanket Pricing
74: --added for MOAC support
75: , org_id NUMBER := FND_API.G_MISS_NUM
76: );
77:
78:
79: TYPE Modifier_List_Tbl_Type IS TABLE OF Modifier_List_Rec_Type

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

81:
82: -- Modifier_List value record type
83:
84: TYPE Modifier_List_Val_Rec_Type IS RECORD
85: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , currency VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR

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

82: -- Modifier_List value record type
83:
84: TYPE Modifier_List_Val_Rec_Type IS RECORD
85: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , currency VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR

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

83:
84: TYPE Modifier_List_Val_Rec_Type IS RECORD
85: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , currency VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR

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

84: TYPE Modifier_List_Val_Rec_Type IS RECORD
85: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , currency VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR

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

85: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , currency VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR

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

86: , currency VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , list_source_code VARCHAR2(240) := FND_API.G_MISS_CHAR -- Blanket Pricing

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

87: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , list_source_code VARCHAR2(240) := FND_API.G_MISS_CHAR -- Blanket Pricing
95: );

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

88: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , list_source_code VARCHAR2(240) := FND_API.G_MISS_CHAR -- Blanket Pricing
95: );
96:

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

89: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , list_source_code VARCHAR2(240) := FND_API.G_MISS_CHAR -- Blanket Pricing
95: );
96:
97: TYPE Modifier_List_Val_Tbl_Type IS TABLE OF Modifier_List_Val_Rec_Type

Line 94: , list_source_code VARCHAR2(240) := FND_API.G_MISS_CHAR -- Blanket Pricing

90: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , list_source_code VARCHAR2(240) := FND_API.G_MISS_CHAR -- Blanket Pricing
95: );
96:
97: TYPE Modifier_List_Val_Tbl_Type IS TABLE OF Modifier_List_Val_Rec_Type
98: INDEX BY BINARY_INTEGER;

Line 103: ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR

99:
100: -- Modifiers record type
101:
102: TYPE Modifiers_Rec_Type IS RECORD
103: ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
104: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
106: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

100: -- Modifiers record type
101:
102: TYPE Modifiers_Rec_Type IS RECORD
103: ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
104: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
106: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

101:
102: TYPE Modifiers_Rec_Type IS RECORD
103: ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
104: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
106: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

102: TYPE Modifiers_Rec_Type IS RECORD
103: ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
104: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
106: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 120: --, base_qty NUMBER := FND_API.G_MISS_NUM

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

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

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

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

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

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

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

Line 124: , created_by NUMBER := FND_API.G_MISS_NUM

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

Line 125: , creation_date DATE := FND_API.G_MISS_DATE

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

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

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

Line 127: , end_date_active DATE := FND_API.G_MISS_DATE

123: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
124: , created_by NUMBER := FND_API.G_MISS_NUM
125: , creation_date DATE := FND_API.G_MISS_DATE
126: , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
127: , end_date_active DATE := FND_API.G_MISS_DATE
128: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
129: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
130: --, gl_class_id NUMBER := FND_API.G_MISS_NUM
131: , inventory_item_id NUMBER := FND_API.G_MISS_NUM

Line 128: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM

124: , created_by NUMBER := FND_API.G_MISS_NUM
125: , creation_date DATE := FND_API.G_MISS_DATE
126: , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
127: , end_date_active DATE := FND_API.G_MISS_DATE
128: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
129: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
130: --, gl_class_id NUMBER := FND_API.G_MISS_NUM
131: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
132: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 129: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM

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

Line 130: --, gl_class_id NUMBER := FND_API.G_MISS_NUM

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

Line 131: , inventory_item_id NUMBER := FND_API.G_MISS_NUM

127: , end_date_active DATE := FND_API.G_MISS_DATE
128: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
129: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
130: --, gl_class_id NUMBER := FND_API.G_MISS_NUM
131: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
132: , last_updated_by NUMBER := FND_API.G_MISS_NUM
133: , last_update_date DATE := FND_API.G_MISS_DATE
134: , last_update_login NUMBER := FND_API.G_MISS_NUM
135: , list_header_id NUMBER := FND_API.G_MISS_NUM

Line 132: , last_updated_by NUMBER := FND_API.G_MISS_NUM

128: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
129: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
130: --, gl_class_id NUMBER := FND_API.G_MISS_NUM
131: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
132: , last_updated_by NUMBER := FND_API.G_MISS_NUM
133: , last_update_date DATE := FND_API.G_MISS_DATE
134: , last_update_login NUMBER := FND_API.G_MISS_NUM
135: , list_header_id NUMBER := FND_API.G_MISS_NUM
136: , list_line_id NUMBER := FND_API.G_MISS_NUM

Line 133: , last_update_date DATE := FND_API.G_MISS_DATE

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

Line 134: , last_update_login NUMBER := FND_API.G_MISS_NUM

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

Line 135: , list_header_id NUMBER := FND_API.G_MISS_NUM

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

Line 136: , list_line_id NUMBER := FND_API.G_MISS_NUM

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

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

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

Line 138: , list_price NUMBER := FND_API.G_MISS_NUM

134: , last_update_login NUMBER := FND_API.G_MISS_NUM
135: , list_header_id NUMBER := FND_API.G_MISS_NUM
136: , list_line_id NUMBER := FND_API.G_MISS_NUM
137: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
138: , list_price NUMBER := FND_API.G_MISS_NUM
139: --, list_price_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
140: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141: --, new_price NUMBER := FND_API.G_MISS_NUM
142: , number_effective_periods NUMBER := FND_API.G_MISS_NUM

Line 139: --, list_price_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR

135: , list_header_id NUMBER := FND_API.G_MISS_NUM
136: , list_line_id NUMBER := FND_API.G_MISS_NUM
137: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
138: , list_price NUMBER := FND_API.G_MISS_NUM
139: --, list_price_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
140: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141: --, new_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

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

136: , list_line_id NUMBER := FND_API.G_MISS_NUM
137: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
138: , list_price NUMBER := FND_API.G_MISS_NUM
139: --, list_price_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
140: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141: --, new_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

Line 141: --, new_price NUMBER := FND_API.G_MISS_NUM

137: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
138: , list_price NUMBER := FND_API.G_MISS_NUM
139: --, list_price_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
140: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141: --, new_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

Line 142: , number_effective_periods NUMBER := FND_API.G_MISS_NUM

138: , list_price NUMBER := FND_API.G_MISS_NUM
139: --, list_price_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
140: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141: --, new_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

Line 143: , operand NUMBER := FND_API.G_MISS_NUM

139: --, list_price_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
140: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141: --, new_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

Line 144: , organization_id NUMBER := FND_API.G_MISS_NUM

140: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141: --, new_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

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

141: --, new_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

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_subtype_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_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
155: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
155: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
156: , related_item_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_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
155: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
156: , related_item_id NUMBER := FND_API.G_MISS_NUM
157: , relationship_type_id NUMBER := FND_API.G_MISS_NUM

Line 154: --, rebate_subtype_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_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
155: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
156: , related_item_id NUMBER := FND_API.G_MISS_NUM
157: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
158: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 155: , rebate_trxn_type_code VARCHAR2(30) := 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_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
155: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
156: , related_item_id NUMBER := FND_API.G_MISS_NUM
157: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
158: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
159: , request_id NUMBER := FND_API.G_MISS_NUM

Line 156: , related_item_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_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
155: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
156: , related_item_id NUMBER := FND_API.G_MISS_NUM
157: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
158: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
159: , request_id NUMBER := FND_API.G_MISS_NUM
160: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR

Line 157: , relationship_type_id NUMBER := FND_API.G_MISS_NUM

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

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

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

Line 159: , request_id NUMBER := FND_API.G_MISS_NUM

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

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

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

Line 161: , revision_date DATE := FND_API.G_MISS_DATE

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

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

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

Line 163: , start_date_active DATE := FND_API.G_MISS_DATE

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

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

160: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
161: , revision_date DATE := FND_API.G_MISS_DATE
162: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , start_date_active DATE := FND_API.G_MISS_DATE
164: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
165: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
166: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
167: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
168: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM

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

161: , revision_date DATE := FND_API.G_MISS_DATE
162: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , start_date_active DATE := FND_API.G_MISS_DATE
164: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
165: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
166: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
167: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
168: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
169: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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

162: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , start_date_active DATE := FND_API.G_MISS_DATE
164: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
165: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
166: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
167: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
168: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
169: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
170: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR

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

163: , start_date_active DATE := FND_API.G_MISS_DATE
164: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
165: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
166: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
167: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
168: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
169: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
170: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
171: , rltd_modifier_id NUMBER := FND_API.G_MISS_NUM

Line 168: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM

164: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
165: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
166: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
167: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
168: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
169: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
170: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
171: , rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
172: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM

Line 169: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR

165: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
166: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
167: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
168: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
169: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
170: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
171: , rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
172: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
173: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM

Line 170: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR

166: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
167: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
168: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
169: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
170: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
171: , rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
172: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
173: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
174: , rltd_modifier_grp_no NUMBER := FND_API.G_MISS_NUM

Line 171: , rltd_modifier_id NUMBER := FND_API.G_MISS_NUM

167: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
168: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
169: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
170: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
171: , rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
172: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
173: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
174: , rltd_modifier_grp_no NUMBER := FND_API.G_MISS_NUM
175: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 172: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM

168: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
169: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
170: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
171: , rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
172: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
173: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
174: , rltd_modifier_grp_no NUMBER := FND_API.G_MISS_NUM
175: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
176: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM

Line 173: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM

169: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
170: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
171: , rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
172: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
173: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
174: , rltd_modifier_grp_no NUMBER := FND_API.G_MISS_NUM
175: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
176: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
177: , product_precedence NUMBER := FND_API.G_MISS_NUM

Line 174: , rltd_modifier_grp_no NUMBER := FND_API.G_MISS_NUM

170: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
171: , rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
172: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
173: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
174: , rltd_modifier_grp_no NUMBER := FND_API.G_MISS_NUM
175: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
176: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
177: , product_precedence NUMBER := FND_API.G_MISS_NUM
178: , expiration_period_start_date DATE := FND_API.G_MISS_DATE

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

171: , rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
172: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
173: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
174: , rltd_modifier_grp_no NUMBER := FND_API.G_MISS_NUM
175: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
176: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
177: , product_precedence NUMBER := FND_API.G_MISS_NUM
178: , expiration_period_start_date DATE := FND_API.G_MISS_DATE
179: , number_expiration_periods NUMBER := FND_API.G_MISS_NUM

Line 176: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM

172: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
173: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
174: , rltd_modifier_grp_no NUMBER := FND_API.G_MISS_NUM
175: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
176: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
177: , product_precedence NUMBER := FND_API.G_MISS_NUM
178: , expiration_period_start_date DATE := FND_API.G_MISS_DATE
179: , number_expiration_periods NUMBER := FND_API.G_MISS_NUM
180: , expiration_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR

Line 177: , product_precedence NUMBER := FND_API.G_MISS_NUM

173: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
174: , rltd_modifier_grp_no NUMBER := FND_API.G_MISS_NUM
175: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
176: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
177: , product_precedence NUMBER := FND_API.G_MISS_NUM
178: , expiration_period_start_date DATE := FND_API.G_MISS_DATE
179: , number_expiration_periods NUMBER := FND_API.G_MISS_NUM
180: , expiration_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
181: , expiration_date DATE := FND_API.G_MISS_DATE

Line 178: , expiration_period_start_date DATE := FND_API.G_MISS_DATE

174: , rltd_modifier_grp_no NUMBER := FND_API.G_MISS_NUM
175: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
176: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
177: , product_precedence NUMBER := FND_API.G_MISS_NUM
178: , expiration_period_start_date DATE := FND_API.G_MISS_DATE
179: , number_expiration_periods NUMBER := FND_API.G_MISS_NUM
180: , expiration_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
181: , expiration_date DATE := FND_API.G_MISS_DATE
182: , estim_gl_value NUMBER := FND_API.G_MISS_NUM

Line 179: , number_expiration_periods NUMBER := FND_API.G_MISS_NUM

175: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
176: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
177: , product_precedence NUMBER := FND_API.G_MISS_NUM
178: , expiration_period_start_date DATE := FND_API.G_MISS_DATE
179: , number_expiration_periods NUMBER := FND_API.G_MISS_NUM
180: , expiration_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
181: , expiration_date DATE := FND_API.G_MISS_DATE
182: , estim_gl_value NUMBER := FND_API.G_MISS_NUM
183: , benefit_price_list_line_id NUMBER := FND_API.G_MISS_NUM

Line 180: , expiration_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR

176: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
177: , product_precedence NUMBER := FND_API.G_MISS_NUM
178: , expiration_period_start_date DATE := FND_API.G_MISS_DATE
179: , number_expiration_periods NUMBER := FND_API.G_MISS_NUM
180: , expiration_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
181: , expiration_date DATE := FND_API.G_MISS_DATE
182: , estim_gl_value NUMBER := FND_API.G_MISS_NUM
183: , benefit_price_list_line_id NUMBER := FND_API.G_MISS_NUM
184: --, recurring_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 181: , expiration_date DATE := FND_API.G_MISS_DATE

177: , product_precedence NUMBER := FND_API.G_MISS_NUM
178: , expiration_period_start_date DATE := FND_API.G_MISS_DATE
179: , number_expiration_periods NUMBER := FND_API.G_MISS_NUM
180: , expiration_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
181: , expiration_date DATE := FND_API.G_MISS_DATE
182: , estim_gl_value NUMBER := FND_API.G_MISS_NUM
183: , benefit_price_list_line_id NUMBER := FND_API.G_MISS_NUM
184: --, recurring_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
185: , benefit_limit NUMBER := FND_API.G_MISS_NUM

Line 182: , estim_gl_value NUMBER := FND_API.G_MISS_NUM

178: , expiration_period_start_date DATE := FND_API.G_MISS_DATE
179: , number_expiration_periods NUMBER := FND_API.G_MISS_NUM
180: , expiration_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
181: , expiration_date DATE := FND_API.G_MISS_DATE
182: , estim_gl_value NUMBER := FND_API.G_MISS_NUM
183: , benefit_price_list_line_id NUMBER := FND_API.G_MISS_NUM
184: --, recurring_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
185: , benefit_limit NUMBER := FND_API.G_MISS_NUM
186: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 183: , benefit_price_list_line_id NUMBER := FND_API.G_MISS_NUM

179: , number_expiration_periods NUMBER := FND_API.G_MISS_NUM
180: , expiration_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
181: , expiration_date DATE := FND_API.G_MISS_DATE
182: , estim_gl_value NUMBER := FND_API.G_MISS_NUM
183: , benefit_price_list_line_id NUMBER := FND_API.G_MISS_NUM
184: --, recurring_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
185: , benefit_limit NUMBER := FND_API.G_MISS_NUM
186: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
187: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 184: --, recurring_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

180: , expiration_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
181: , expiration_date DATE := FND_API.G_MISS_DATE
182: , estim_gl_value NUMBER := FND_API.G_MISS_NUM
183: , benefit_price_list_line_id NUMBER := FND_API.G_MISS_NUM
184: --, recurring_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
185: , benefit_limit NUMBER := FND_API.G_MISS_NUM
186: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
187: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
188: , benefit_qty NUMBER := FND_API.G_MISS_NUM

Line 185: , benefit_limit NUMBER := FND_API.G_MISS_NUM

181: , expiration_date DATE := FND_API.G_MISS_DATE
182: , estim_gl_value NUMBER := FND_API.G_MISS_NUM
183: , benefit_price_list_line_id NUMBER := FND_API.G_MISS_NUM
184: --, recurring_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
185: , benefit_limit NUMBER := FND_API.G_MISS_NUM
186: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
187: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
188: , benefit_qty NUMBER := FND_API.G_MISS_NUM
189: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 186: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

182: , estim_gl_value NUMBER := FND_API.G_MISS_NUM
183: , benefit_price_list_line_id NUMBER := FND_API.G_MISS_NUM
184: --, recurring_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
185: , benefit_limit NUMBER := FND_API.G_MISS_NUM
186: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
187: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
188: , benefit_qty NUMBER := FND_API.G_MISS_NUM
189: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
190: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM

Line 187: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR

183: , benefit_price_list_line_id NUMBER := FND_API.G_MISS_NUM
184: --, recurring_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
185: , benefit_limit NUMBER := FND_API.G_MISS_NUM
186: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
187: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
188: , benefit_qty NUMBER := FND_API.G_MISS_NUM
189: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
190: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
191: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 188: , benefit_qty NUMBER := FND_API.G_MISS_NUM

184: --, recurring_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
185: , benefit_limit NUMBER := FND_API.G_MISS_NUM
186: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
187: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
188: , benefit_qty NUMBER := FND_API.G_MISS_NUM
189: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
190: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
191: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
192: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 189: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR

185: , benefit_limit NUMBER := FND_API.G_MISS_NUM
186: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
187: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
188: , benefit_qty NUMBER := FND_API.G_MISS_NUM
189: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
190: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
191: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
192: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
193: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 190: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM

186: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
187: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
188: , benefit_qty NUMBER := FND_API.G_MISS_NUM
189: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
190: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
191: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
192: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
193: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
194: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 191: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

187: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
188: , benefit_qty NUMBER := FND_API.G_MISS_NUM
189: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
190: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
191: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
192: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
193: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
194: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
195: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 192: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

188: , benefit_qty NUMBER := FND_API.G_MISS_NUM
189: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
190: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
191: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
192: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
193: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
194: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
195: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
196: , Modifier_parent_index NUMBER := FND_API.G_MISS_NUM

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

189: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
190: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
191: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
192: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
193: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
194: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
195: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
196: , Modifier_parent_index NUMBER := FND_API.G_MISS_NUM
197: , qualification_ind NUMBER := FND_API.G_MISS_NUM

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

190: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
191: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
192: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
193: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
194: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
195: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
196: , Modifier_parent_index NUMBER := FND_API.G_MISS_NUM
197: , qualification_ind NUMBER := FND_API.G_MISS_NUM
198: , net_amount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

191: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
192: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
193: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
194: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
195: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
196: , Modifier_parent_index NUMBER := FND_API.G_MISS_NUM
197: , qualification_ind NUMBER := FND_API.G_MISS_NUM
198: , net_amount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
199: , accum_attribute VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 196: , Modifier_parent_index NUMBER := FND_API.G_MISS_NUM

192: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
193: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
194: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
195: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
196: , Modifier_parent_index NUMBER := FND_API.G_MISS_NUM
197: , qualification_ind NUMBER := FND_API.G_MISS_NUM
198: , net_amount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
199: , accum_attribute VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , continuous_price_break_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 197: , qualification_ind NUMBER := FND_API.G_MISS_NUM

193: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
194: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
195: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
196: , Modifier_parent_index NUMBER := FND_API.G_MISS_NUM
197: , qualification_ind NUMBER := FND_API.G_MISS_NUM
198: , net_amount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
199: , accum_attribute VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , continuous_price_break_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
201: , service_duration NUMBER := FND_API.G_MISS_NUM -- service project

Line 198: , net_amount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

194: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
195: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
196: , Modifier_parent_index NUMBER := FND_API.G_MISS_NUM
197: , qualification_ind NUMBER := FND_API.G_MISS_NUM
198: , net_amount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
199: , accum_attribute VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , continuous_price_break_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
201: , service_duration NUMBER := FND_API.G_MISS_NUM -- service project
202: , service_period VARCHAR2(3) := FND_API.G_MISS_CHAR -- service project

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

195: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
196: , Modifier_parent_index NUMBER := FND_API.G_MISS_NUM
197: , qualification_ind NUMBER := FND_API.G_MISS_NUM
198: , net_amount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
199: , accum_attribute VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , continuous_price_break_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
201: , service_duration NUMBER := FND_API.G_MISS_NUM -- service project
202: , service_period VARCHAR2(3) := FND_API.G_MISS_CHAR -- service project
203:

Line 200: , continuous_price_break_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

196: , Modifier_parent_index NUMBER := FND_API.G_MISS_NUM
197: , qualification_ind NUMBER := FND_API.G_MISS_NUM
198: , net_amount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
199: , accum_attribute VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , continuous_price_break_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
201: , service_duration NUMBER := FND_API.G_MISS_NUM -- service project
202: , service_period VARCHAR2(3) := FND_API.G_MISS_CHAR -- service project
203:
204: );

Line 201: , service_duration NUMBER := FND_API.G_MISS_NUM -- service project

197: , qualification_ind NUMBER := FND_API.G_MISS_NUM
198: , net_amount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
199: , accum_attribute VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , continuous_price_break_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
201: , service_duration NUMBER := FND_API.G_MISS_NUM -- service project
202: , service_period VARCHAR2(3) := FND_API.G_MISS_CHAR -- service project
203:
204: );
205:

Line 202: , service_period VARCHAR2(3) := FND_API.G_MISS_CHAR -- service project

198: , net_amount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
199: , accum_attribute VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , continuous_price_break_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
201: , service_duration NUMBER := FND_API.G_MISS_NUM -- service project
202: , service_period VARCHAR2(3) := FND_API.G_MISS_CHAR -- service project
203:
204: );
205:
206: TYPE Modifiers_Tbl_Type IS TABLE OF Modifiers_Rec_Type

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

208:
209: -- Modifiers value record type
210:
211: TYPE Modifiers_Val_Rec_Type IS RECORD
212: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
213: , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
214: , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
215: , gl_class VARCHAR2(240) := FND_API.G_MISS_CHAR
216: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR

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

209: -- Modifiers value record type
210:
211: TYPE Modifiers_Val_Rec_Type IS RECORD
212: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
213: , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
214: , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
215: , gl_class VARCHAR2(240) := FND_API.G_MISS_CHAR
216: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
217: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR

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

210:
211: TYPE Modifiers_Val_Rec_Type IS RECORD
212: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
213: , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
214: , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
215: , gl_class VARCHAR2(240) := FND_API.G_MISS_CHAR
216: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
217: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
218: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 215: , gl_class VARCHAR2(240) := FND_API.G_MISS_CHAR

211: TYPE Modifiers_Val_Rec_Type IS RECORD
212: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
213: , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
214: , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
215: , gl_class VARCHAR2(240) := FND_API.G_MISS_CHAR
216: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
217: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
218: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
219: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR

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

212: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
213: , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
214: , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
215: , gl_class VARCHAR2(240) := FND_API.G_MISS_CHAR
216: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
217: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
218: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
219: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
220: , list_price_uom VARCHAR2(240) := FND_API.G_MISS_CHAR

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

213: , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
214: , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
215: , gl_class VARCHAR2(240) := FND_API.G_MISS_CHAR
216: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
217: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
218: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
219: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
220: , list_price_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
221: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR

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

214: , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
215: , gl_class VARCHAR2(240) := FND_API.G_MISS_CHAR
216: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
217: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
218: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
219: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
220: , list_price_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
221: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR

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

215: , gl_class VARCHAR2(240) := FND_API.G_MISS_CHAR
216: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
217: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
218: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
219: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
220: , list_price_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
221: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , override VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 220: , list_price_uom VARCHAR2(240) := FND_API.G_MISS_CHAR

216: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
217: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
218: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
219: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
220: , list_price_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
221: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR

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

217: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
218: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
219: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
220: , list_price_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
221: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR

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

218: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
219: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
220: , list_price_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
221: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR

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

219: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
220: , list_price_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
221: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR

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

220: , list_price_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
221: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , rebate_subtype VARCHAR2(240) := FND_API.G_MISS_CHAR

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

221: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , rebate_subtype VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR

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

222: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , rebate_subtype VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR

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

223: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , rebate_subtype VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR

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

224: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , rebate_subtype VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR

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

225: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , rebate_subtype VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR

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

226: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , rebate_subtype VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
234: );

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

227: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , rebate_subtype VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
234: );
235:

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

228: , rebate_subtype VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
234: );
235:
236: TYPE Modifiers_Val_Tbl_Type IS TABLE OF Modifiers_Val_Rec_Type

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

229: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
234: );
235:
236: TYPE Modifiers_Val_Tbl_Type IS TABLE OF Modifiers_Val_Rec_Type
237: INDEX BY BINARY_INTEGER;

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

238:
239: -- Qualifiers record type
240: /*
241: TYPE Qualifiers_Rec_Type IS RECORD
242: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
243: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
244: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
245: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
246: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

239: -- Qualifiers record type
240: /*
241: TYPE Qualifiers_Rec_Type IS RECORD
242: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
243: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
244: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
245: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
246: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
247: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

240: /*
241: TYPE Qualifiers_Rec_Type IS RECORD
242: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
243: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
244: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
245: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
246: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
247: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
248: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

241: TYPE Qualifiers_Rec_Type IS RECORD
242: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
243: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
244: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
245: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
246: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
247: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
248: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
249: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

242: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
243: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
244: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
245: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
246: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
247: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
248: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
249: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

243: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
244: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
245: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
246: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
247: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
248: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
249: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
251: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

244: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
245: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
246: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
247: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
248: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
249: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
251: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
252: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

245: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
246: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
247: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
248: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
249: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
251: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
252: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
253: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

246: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
247: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
248: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
249: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
251: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
252: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
253: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
254: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

247: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
248: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
249: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
251: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
252: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
253: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
254: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
255: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

248: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
249: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
251: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
252: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
253: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
254: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
255: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
256: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

249: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
251: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
252: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
253: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
254: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
255: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
256: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
257: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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

250: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
251: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
252: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
253: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
254: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
255: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
256: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
257: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
258: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

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

251: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
252: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
253: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
254: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
255: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
256: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
257: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
258: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
259: , created_by NUMBER := FND_API.G_MISS_NUM

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

252: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
253: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
254: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
255: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
256: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
257: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
258: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
259: , created_by NUMBER := FND_API.G_MISS_NUM
260: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM

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

253: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
254: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
255: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
256: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
257: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
258: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
259: , created_by NUMBER := FND_API.G_MISS_NUM
260: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
261: , creation_date DATE := FND_API.G_MISS_DATE

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

254: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
255: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
256: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
257: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
258: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
259: , created_by NUMBER := FND_API.G_MISS_NUM
260: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
261: , creation_date DATE := FND_API.G_MISS_DATE
262: , end_date_active DATE := FND_API.G_MISS_DATE

Line 259: , created_by NUMBER := FND_API.G_MISS_NUM

255: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
256: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
257: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
258: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
259: , created_by NUMBER := FND_API.G_MISS_NUM
260: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
261: , creation_date DATE := FND_API.G_MISS_DATE
262: , end_date_active DATE := FND_API.G_MISS_DATE
263: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 260: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM

256: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
257: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
258: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
259: , created_by NUMBER := FND_API.G_MISS_NUM
260: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
261: , creation_date DATE := FND_API.G_MISS_DATE
262: , end_date_active DATE := FND_API.G_MISS_DATE
263: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
264: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 261: , creation_date DATE := FND_API.G_MISS_DATE

257: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
258: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
259: , created_by NUMBER := FND_API.G_MISS_NUM
260: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
261: , creation_date DATE := FND_API.G_MISS_DATE
262: , end_date_active DATE := FND_API.G_MISS_DATE
263: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
264: , last_updated_by NUMBER := FND_API.G_MISS_NUM
265: , last_update_date DATE := FND_API.G_MISS_DATE

Line 262: , end_date_active DATE := FND_API.G_MISS_DATE

258: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
259: , created_by NUMBER := FND_API.G_MISS_NUM
260: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
261: , creation_date DATE := FND_API.G_MISS_DATE
262: , end_date_active DATE := FND_API.G_MISS_DATE
263: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
264: , last_updated_by NUMBER := FND_API.G_MISS_NUM
265: , last_update_date DATE := FND_API.G_MISS_DATE
266: , last_update_login NUMBER := FND_API.G_MISS_NUM

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

259: , created_by NUMBER := FND_API.G_MISS_NUM
260: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
261: , creation_date DATE := FND_API.G_MISS_DATE
262: , end_date_active DATE := FND_API.G_MISS_DATE
263: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
264: , last_updated_by NUMBER := FND_API.G_MISS_NUM
265: , last_update_date DATE := FND_API.G_MISS_DATE
266: , last_update_login NUMBER := FND_API.G_MISS_NUM
267: , list_header_id NUMBER := FND_API.G_MISS_NUM

Line 264: , last_updated_by NUMBER := FND_API.G_MISS_NUM

260: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
261: , creation_date DATE := FND_API.G_MISS_DATE
262: , end_date_active DATE := FND_API.G_MISS_DATE
263: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
264: , last_updated_by NUMBER := FND_API.G_MISS_NUM
265: , last_update_date DATE := FND_API.G_MISS_DATE
266: , last_update_login NUMBER := FND_API.G_MISS_NUM
267: , list_header_id NUMBER := FND_API.G_MISS_NUM
268: , list_line_id NUMBER := FND_API.G_MISS_NUM

Line 265: , last_update_date DATE := FND_API.G_MISS_DATE

261: , creation_date DATE := FND_API.G_MISS_DATE
262: , end_date_active DATE := FND_API.G_MISS_DATE
263: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
264: , last_updated_by NUMBER := FND_API.G_MISS_NUM
265: , last_update_date DATE := FND_API.G_MISS_DATE
266: , last_update_login NUMBER := FND_API.G_MISS_NUM
267: , list_header_id NUMBER := FND_API.G_MISS_NUM
268: , list_line_id NUMBER := FND_API.G_MISS_NUM
269: , program_application_id NUMBER := FND_API.G_MISS_NUM

Line 266: , last_update_login NUMBER := FND_API.G_MISS_NUM

262: , end_date_active DATE := FND_API.G_MISS_DATE
263: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
264: , last_updated_by NUMBER := FND_API.G_MISS_NUM
265: , last_update_date DATE := FND_API.G_MISS_DATE
266: , last_update_login NUMBER := FND_API.G_MISS_NUM
267: , list_header_id NUMBER := FND_API.G_MISS_NUM
268: , list_line_id NUMBER := FND_API.G_MISS_NUM
269: , program_application_id NUMBER := FND_API.G_MISS_NUM
270: , program_id NUMBER := FND_API.G_MISS_NUM

Line 267: , list_header_id NUMBER := FND_API.G_MISS_NUM

263: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
264: , last_updated_by NUMBER := FND_API.G_MISS_NUM
265: , last_update_date DATE := FND_API.G_MISS_DATE
266: , last_update_login NUMBER := FND_API.G_MISS_NUM
267: , list_header_id NUMBER := FND_API.G_MISS_NUM
268: , list_line_id NUMBER := FND_API.G_MISS_NUM
269: , program_application_id NUMBER := FND_API.G_MISS_NUM
270: , program_id NUMBER := FND_API.G_MISS_NUM
271: , program_update_date DATE := FND_API.G_MISS_DATE

Line 268: , list_line_id NUMBER := FND_API.G_MISS_NUM

264: , last_updated_by NUMBER := FND_API.G_MISS_NUM
265: , last_update_date DATE := FND_API.G_MISS_DATE
266: , last_update_login NUMBER := FND_API.G_MISS_NUM
267: , list_header_id NUMBER := FND_API.G_MISS_NUM
268: , list_line_id NUMBER := FND_API.G_MISS_NUM
269: , program_application_id NUMBER := FND_API.G_MISS_NUM
270: , program_id NUMBER := FND_API.G_MISS_NUM
271: , program_update_date DATE := FND_API.G_MISS_DATE
272: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 269: , program_application_id NUMBER := FND_API.G_MISS_NUM

265: , last_update_date DATE := FND_API.G_MISS_DATE
266: , last_update_login NUMBER := FND_API.G_MISS_NUM
267: , list_header_id NUMBER := FND_API.G_MISS_NUM
268: , list_line_id NUMBER := FND_API.G_MISS_NUM
269: , program_application_id NUMBER := FND_API.G_MISS_NUM
270: , program_id NUMBER := FND_API.G_MISS_NUM
271: , program_update_date DATE := FND_API.G_MISS_DATE
272: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
273: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 270: , program_id NUMBER := FND_API.G_MISS_NUM

266: , last_update_login NUMBER := FND_API.G_MISS_NUM
267: , list_header_id NUMBER := FND_API.G_MISS_NUM
268: , list_line_id NUMBER := FND_API.G_MISS_NUM
269: , program_application_id NUMBER := FND_API.G_MISS_NUM
270: , program_id NUMBER := FND_API.G_MISS_NUM
271: , program_update_date DATE := FND_API.G_MISS_DATE
272: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
273: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
274: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 271: , program_update_date DATE := FND_API.G_MISS_DATE

267: , list_header_id NUMBER := FND_API.G_MISS_NUM
268: , list_line_id NUMBER := FND_API.G_MISS_NUM
269: , program_application_id NUMBER := FND_API.G_MISS_NUM
270: , program_id NUMBER := FND_API.G_MISS_NUM
271: , program_update_date DATE := FND_API.G_MISS_DATE
272: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
273: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
274: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
275: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 272: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR

268: , list_line_id NUMBER := FND_API.G_MISS_NUM
269: , program_application_id NUMBER := FND_API.G_MISS_NUM
270: , program_id NUMBER := FND_API.G_MISS_NUM
271: , program_update_date DATE := FND_API.G_MISS_DATE
272: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
273: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
274: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
275: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
276: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR

Line 273: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR

269: , program_application_id NUMBER := FND_API.G_MISS_NUM
270: , program_id NUMBER := FND_API.G_MISS_NUM
271: , program_update_date DATE := FND_API.G_MISS_DATE
272: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
273: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
274: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
275: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
276: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
277: --, qualifier_date_format VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 274: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR

270: , program_id NUMBER := FND_API.G_MISS_NUM
271: , program_update_date DATE := FND_API.G_MISS_DATE
272: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
273: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
274: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
275: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
276: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
277: --, qualifier_date_format VARCHAR2(30) := FND_API.G_MISS_CHAR
278: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM

Line 275: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR

271: , program_update_date DATE := FND_API.G_MISS_DATE
272: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
273: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
274: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
275: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
276: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
277: --, qualifier_date_format VARCHAR2(30) := FND_API.G_MISS_CHAR
278: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
279: , qualifier_id NUMBER := FND_API.G_MISS_NUM

Line 276: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR

272: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
273: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
274: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
275: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
276: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
277: --, qualifier_date_format VARCHAR2(30) := FND_API.G_MISS_CHAR
278: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
279: , qualifier_id NUMBER := FND_API.G_MISS_NUM
280: --, qualifier_number_format VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 277: --, qualifier_date_format VARCHAR2(30) := FND_API.G_MISS_CHAR

273: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
274: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
275: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
276: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
277: --, qualifier_date_format VARCHAR2(30) := FND_API.G_MISS_CHAR
278: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
279: , qualifier_id NUMBER := FND_API.G_MISS_NUM
280: --, qualifier_number_format VARCHAR2(30) := FND_API.G_MISS_CHAR
281: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM

Line 278: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM

274: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
275: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
276: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
277: --, qualifier_date_format VARCHAR2(30) := FND_API.G_MISS_CHAR
278: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
279: , qualifier_id NUMBER := FND_API.G_MISS_NUM
280: --, qualifier_number_format VARCHAR2(30) := FND_API.G_MISS_CHAR
281: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
282: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM

Line 279: , qualifier_id NUMBER := FND_API.G_MISS_NUM

275: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
276: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
277: --, qualifier_date_format VARCHAR2(30) := FND_API.G_MISS_CHAR
278: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
279: , qualifier_id NUMBER := FND_API.G_MISS_NUM
280: --, qualifier_number_format VARCHAR2(30) := FND_API.G_MISS_CHAR
281: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
282: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
283: , request_id NUMBER := FND_API.G_MISS_NUM

Line 280: --, qualifier_number_format VARCHAR2(30) := FND_API.G_MISS_CHAR

276: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
277: --, qualifier_date_format VARCHAR2(30) := FND_API.G_MISS_CHAR
278: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
279: , qualifier_id NUMBER := FND_API.G_MISS_NUM
280: --, qualifier_number_format VARCHAR2(30) := FND_API.G_MISS_CHAR
281: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
282: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
283: , request_id NUMBER := FND_API.G_MISS_NUM
284: , start_date_active DATE := FND_API.G_MISS_DATE

Line 281: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM

277: --, qualifier_date_format VARCHAR2(30) := FND_API.G_MISS_CHAR
278: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
279: , qualifier_id NUMBER := FND_API.G_MISS_NUM
280: --, qualifier_number_format VARCHAR2(30) := FND_API.G_MISS_CHAR
281: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
282: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
283: , request_id NUMBER := FND_API.G_MISS_NUM
284: , start_date_active DATE := FND_API.G_MISS_DATE
285: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 282: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM

278: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
279: , qualifier_id NUMBER := FND_API.G_MISS_NUM
280: --, qualifier_number_format VARCHAR2(30) := FND_API.G_MISS_CHAR
281: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
282: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
283: , request_id NUMBER := FND_API.G_MISS_NUM
284: , start_date_active DATE := FND_API.G_MISS_DATE
285: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
286: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 283: , request_id NUMBER := FND_API.G_MISS_NUM

279: , qualifier_id NUMBER := FND_API.G_MISS_NUM
280: --, qualifier_number_format VARCHAR2(30) := FND_API.G_MISS_CHAR
281: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
282: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
283: , request_id NUMBER := FND_API.G_MISS_NUM
284: , start_date_active DATE := FND_API.G_MISS_DATE
285: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
286: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
287: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 284: , start_date_active DATE := FND_API.G_MISS_DATE

280: --, qualifier_number_format VARCHAR2(30) := FND_API.G_MISS_CHAR
281: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
282: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
283: , request_id NUMBER := FND_API.G_MISS_NUM
284: , start_date_active DATE := FND_API.G_MISS_DATE
285: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
286: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
287: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
288: );

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

281: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
282: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
283: , request_id NUMBER := FND_API.G_MISS_NUM
284: , start_date_active DATE := FND_API.G_MISS_DATE
285: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
286: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
287: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
288: );
289:

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

282: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
283: , request_id NUMBER := FND_API.G_MISS_NUM
284: , start_date_active DATE := FND_API.G_MISS_DATE
285: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
286: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
287: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
288: );
289:
290: TYPE Qualifiers_Tbl_Type IS TABLE OF Qualifiers_Rec_Type

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

283: , request_id NUMBER := FND_API.G_MISS_NUM
284: , start_date_active DATE := FND_API.G_MISS_DATE
285: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
286: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
287: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
288: );
289:
290: TYPE Qualifiers_Tbl_Type IS TABLE OF Qualifiers_Rec_Type
291: INDEX BY BINARY_INTEGER;

Line 297: ( created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR

293: -- Qualifiers value record type
294:
295:
296: TYPE Qualifiers_Val_Rec_Type IS RECORD
297: ( created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
298: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
299: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
301: );

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

294:
295:
296: TYPE Qualifiers_Val_Rec_Type IS RECORD
297: ( created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
298: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
299: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
301: );
302:

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

295:
296: TYPE Qualifiers_Val_Rec_Type IS RECORD
297: ( created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
298: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
299: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
301: );
302:
303: TYPE Qualifiers_Val_Tbl_Type IS TABLE OF Qualifiers_Val_Rec_Type

Line 300: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR

296: TYPE Qualifiers_Val_Rec_Type IS RECORD
297: ( created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
298: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
299: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
301: );
302:
303: TYPE Qualifiers_Val_Tbl_Type IS TABLE OF Qualifiers_Val_Rec_Type
304: INDEX BY BINARY_INTEGER;

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

308:
309: -- Pricing_Attr record type
310:
311: TYPE Pricing_Attr_Rec_Type IS RECORD
312: ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
313: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
314: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
315: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
316: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

309: -- Pricing_Attr record type
310:
311: TYPE Pricing_Attr_Rec_Type IS RECORD
312: ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
313: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
314: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
315: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
316: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
317: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

310:
311: TYPE Pricing_Attr_Rec_Type IS RECORD
312: ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
313: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
314: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
315: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
316: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
317: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
318: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

311: TYPE Pricing_Attr_Rec_Type IS RECORD
312: ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
313: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
314: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
315: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
316: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
317: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
318: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
319: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

312: ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
313: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
314: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
315: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
316: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
317: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
318: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
319: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
320: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

313: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
314: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
315: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
316: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
317: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
318: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
319: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
320: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
321: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

314: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
315: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
316: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
317: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
318: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
319: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
320: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
321: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
322: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

315: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
316: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
317: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
318: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
319: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
320: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
321: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
322: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
323: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

316: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
317: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
318: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
319: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
320: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
321: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
322: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
323: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
324: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

317: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
318: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
319: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
320: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
321: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
322: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
323: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
324: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
325: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

318: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
319: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
320: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
321: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
322: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
323: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
324: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
325: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
326: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

319: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
320: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
321: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
322: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
323: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
324: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
325: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
326: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
327: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

320: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
321: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
322: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
323: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
324: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
325: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
326: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
327: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
328: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM

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

321: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
322: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
323: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
324: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
325: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
326: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
327: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
328: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
329: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

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

322: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
323: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
324: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
325: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
326: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
327: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
328: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
329: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
330: , created_by NUMBER := FND_API.G_MISS_NUM

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

323: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
324: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
325: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
326: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
327: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
328: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
329: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
330: , created_by NUMBER := FND_API.G_MISS_NUM
331: , creation_date DATE := FND_API.G_MISS_DATE

Line 328: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM

324: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
325: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
326: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
327: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
328: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
329: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
330: , created_by NUMBER := FND_API.G_MISS_NUM
331: , creation_date DATE := FND_API.G_MISS_DATE
332: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

325: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
326: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
327: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
328: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
329: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
330: , created_by NUMBER := FND_API.G_MISS_NUM
331: , creation_date DATE := FND_API.G_MISS_DATE
332: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
333: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 330: , created_by NUMBER := FND_API.G_MISS_NUM

326: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
327: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
328: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
329: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
330: , created_by NUMBER := FND_API.G_MISS_NUM
331: , creation_date DATE := FND_API.G_MISS_DATE
332: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
333: , last_updated_by NUMBER := FND_API.G_MISS_NUM
334: , last_update_date DATE := FND_API.G_MISS_DATE

Line 331: , creation_date DATE := FND_API.G_MISS_DATE

327: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
328: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
329: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
330: , created_by NUMBER := FND_API.G_MISS_NUM
331: , creation_date DATE := FND_API.G_MISS_DATE
332: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
333: , last_updated_by NUMBER := FND_API.G_MISS_NUM
334: , last_update_date DATE := FND_API.G_MISS_DATE
335: , last_update_login NUMBER := FND_API.G_MISS_NUM

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

328: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
329: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
330: , created_by NUMBER := FND_API.G_MISS_NUM
331: , creation_date DATE := FND_API.G_MISS_DATE
332: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
333: , last_updated_by NUMBER := FND_API.G_MISS_NUM
334: , last_update_date DATE := FND_API.G_MISS_DATE
335: , last_update_login NUMBER := FND_API.G_MISS_NUM
336: , list_line_id NUMBER := FND_API.G_MISS_NUM

Line 333: , last_updated_by NUMBER := FND_API.G_MISS_NUM

329: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
330: , created_by NUMBER := FND_API.G_MISS_NUM
331: , creation_date DATE := FND_API.G_MISS_DATE
332: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
333: , last_updated_by NUMBER := FND_API.G_MISS_NUM
334: , last_update_date DATE := FND_API.G_MISS_DATE
335: , last_update_login NUMBER := FND_API.G_MISS_NUM
336: , list_line_id NUMBER := FND_API.G_MISS_NUM
337: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 334: , last_update_date DATE := FND_API.G_MISS_DATE

330: , created_by NUMBER := FND_API.G_MISS_NUM
331: , creation_date DATE := FND_API.G_MISS_DATE
332: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
333: , last_updated_by NUMBER := FND_API.G_MISS_NUM
334: , last_update_date DATE := FND_API.G_MISS_DATE
335: , last_update_login NUMBER := FND_API.G_MISS_NUM
336: , list_line_id NUMBER := FND_API.G_MISS_NUM
337: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
338: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 335: , last_update_login NUMBER := FND_API.G_MISS_NUM

331: , creation_date DATE := FND_API.G_MISS_DATE
332: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
333: , last_updated_by NUMBER := FND_API.G_MISS_NUM
334: , last_update_date DATE := FND_API.G_MISS_DATE
335: , last_update_login NUMBER := FND_API.G_MISS_NUM
336: , list_line_id NUMBER := FND_API.G_MISS_NUM
337: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
338: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
339: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM

Line 336: , list_line_id NUMBER := FND_API.G_MISS_NUM

332: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
333: , last_updated_by NUMBER := FND_API.G_MISS_NUM
334: , last_update_date DATE := FND_API.G_MISS_DATE
335: , last_update_login NUMBER := FND_API.G_MISS_NUM
336: , list_line_id NUMBER := FND_API.G_MISS_NUM
337: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
338: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
339: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
340: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR

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

333: , last_updated_by NUMBER := FND_API.G_MISS_NUM
334: , last_update_date DATE := FND_API.G_MISS_DATE
335: , last_update_login NUMBER := FND_API.G_MISS_NUM
336: , list_line_id NUMBER := FND_API.G_MISS_NUM
337: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
338: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
339: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
340: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
341: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR

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

334: , last_update_date DATE := FND_API.G_MISS_DATE
335: , last_update_login NUMBER := FND_API.G_MISS_NUM
336: , list_line_id NUMBER := FND_API.G_MISS_NUM
337: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
338: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
339: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
340: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
341: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
342: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 339: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM

335: , last_update_login NUMBER := FND_API.G_MISS_NUM
336: , list_line_id NUMBER := FND_API.G_MISS_NUM
337: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
338: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
339: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
340: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
341: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
342: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
343: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR

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

336: , list_line_id NUMBER := FND_API.G_MISS_NUM
337: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
338: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
339: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
340: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
341: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
342: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
343: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
344: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR

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

337: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
338: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
339: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
340: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
341: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
342: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
343: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
344: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
345: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR

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

338: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
339: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
340: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
341: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
342: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
343: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
344: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
345: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
346: , program_application_id NUMBER := FND_API.G_MISS_NUM

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

339: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
340: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
341: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
342: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
343: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
344: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
345: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
346: , program_application_id NUMBER := FND_API.G_MISS_NUM
347: , program_id NUMBER := FND_API.G_MISS_NUM

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

340: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
341: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
342: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
343: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
344: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
345: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
346: , program_application_id NUMBER := FND_API.G_MISS_NUM
347: , program_id NUMBER := FND_API.G_MISS_NUM
348: , program_update_date DATE := FND_API.G_MISS_DATE

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

341: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
342: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
343: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
344: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
345: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
346: , program_application_id NUMBER := FND_API.G_MISS_NUM
347: , program_id NUMBER := FND_API.G_MISS_NUM
348: , program_update_date DATE := FND_API.G_MISS_DATE
349: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 346: , program_application_id NUMBER := FND_API.G_MISS_NUM

342: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
343: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
344: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
345: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
346: , program_application_id NUMBER := FND_API.G_MISS_NUM
347: , program_id NUMBER := FND_API.G_MISS_NUM
348: , program_update_date DATE := FND_API.G_MISS_DATE
349: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
350: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 347: , program_id NUMBER := FND_API.G_MISS_NUM

343: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
344: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
345: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
346: , program_application_id NUMBER := FND_API.G_MISS_NUM
347: , program_id NUMBER := FND_API.G_MISS_NUM
348: , program_update_date DATE := FND_API.G_MISS_DATE
349: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
350: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
351: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 348: , program_update_date DATE := FND_API.G_MISS_DATE

344: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
345: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
346: , program_application_id NUMBER := FND_API.G_MISS_NUM
347: , program_id NUMBER := FND_API.G_MISS_NUM
348: , program_update_date DATE := FND_API.G_MISS_DATE
349: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
350: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
351: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
352: , list_header_id NUMBER := FND_API.G_MISS_NUM

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

345: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
346: , program_application_id NUMBER := FND_API.G_MISS_NUM
347: , program_id NUMBER := FND_API.G_MISS_NUM
348: , program_update_date DATE := FND_API.G_MISS_DATE
349: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
350: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
351: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
352: , list_header_id NUMBER := FND_API.G_MISS_NUM
353: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM

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

346: , program_application_id NUMBER := FND_API.G_MISS_NUM
347: , program_id NUMBER := FND_API.G_MISS_NUM
348: , program_update_date DATE := FND_API.G_MISS_DATE
349: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
350: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
351: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
352: , list_header_id NUMBER := FND_API.G_MISS_NUM
353: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
354: , request_id NUMBER := FND_API.G_MISS_NUM

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

347: , program_id NUMBER := FND_API.G_MISS_NUM
348: , program_update_date DATE := FND_API.G_MISS_DATE
349: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
350: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
351: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
352: , list_header_id NUMBER := FND_API.G_MISS_NUM
353: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
354: , request_id NUMBER := FND_API.G_MISS_NUM
355: , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM

Line 352: , list_header_id NUMBER := FND_API.G_MISS_NUM

348: , program_update_date DATE := FND_API.G_MISS_DATE
349: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
350: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
351: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
352: , list_header_id NUMBER := FND_API.G_MISS_NUM
353: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
354: , request_id NUMBER := FND_API.G_MISS_NUM
355: , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
356: , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM

Line 353: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM

349: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
350: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
351: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
352: , list_header_id NUMBER := FND_API.G_MISS_NUM
353: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
354: , request_id NUMBER := FND_API.G_MISS_NUM
355: , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
356: , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
357: , qualification_ind NUMBER := FND_API.G_MISS_NUM

Line 354: , request_id NUMBER := FND_API.G_MISS_NUM

350: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
351: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
352: , list_header_id NUMBER := FND_API.G_MISS_NUM
353: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
354: , request_id NUMBER := FND_API.G_MISS_NUM
355: , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
356: , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
357: , qualification_ind NUMBER := FND_API.G_MISS_NUM
358: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 355: , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM

351: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
352: , list_header_id NUMBER := FND_API.G_MISS_NUM
353: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
354: , request_id NUMBER := FND_API.G_MISS_NUM
355: , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
356: , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
357: , qualification_ind NUMBER := FND_API.G_MISS_NUM
358: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
359: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 356: , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM

352: , list_header_id NUMBER := FND_API.G_MISS_NUM
353: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
354: , request_id NUMBER := FND_API.G_MISS_NUM
355: , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
356: , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
357: , qualification_ind NUMBER := FND_API.G_MISS_NUM
358: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
359: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
360: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 357: , qualification_ind NUMBER := FND_API.G_MISS_NUM

353: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
354: , request_id NUMBER := FND_API.G_MISS_NUM
355: , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
356: , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
357: , qualification_ind NUMBER := FND_API.G_MISS_NUM
358: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
359: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
360: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
361: , MODIFIERS_index NUMBER := FND_API.G_MISS_NUM

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

354: , request_id NUMBER := FND_API.G_MISS_NUM
355: , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
356: , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
357: , qualification_ind NUMBER := FND_API.G_MISS_NUM
358: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
359: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
360: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
361: , MODIFIERS_index NUMBER := FND_API.G_MISS_NUM
362: );

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

355: , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
356: , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
357: , qualification_ind NUMBER := FND_API.G_MISS_NUM
358: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
359: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
360: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
361: , MODIFIERS_index NUMBER := FND_API.G_MISS_NUM
362: );
363:

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

356: , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
357: , qualification_ind NUMBER := FND_API.G_MISS_NUM
358: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
359: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
360: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
361: , MODIFIERS_index NUMBER := FND_API.G_MISS_NUM
362: );
363:
364: TYPE Pricing_Attr_Tbl_Type IS TABLE OF Pricing_Attr_Rec_Type

Line 361: , MODIFIERS_index NUMBER := FND_API.G_MISS_NUM

357: , qualification_ind NUMBER := FND_API.G_MISS_NUM
358: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
359: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
360: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
361: , MODIFIERS_index NUMBER := FND_API.G_MISS_NUM
362: );
363:
364: TYPE Pricing_Attr_Tbl_Type IS TABLE OF Pricing_Attr_Rec_Type
365: INDEX BY BINARY_INTEGER;

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

366:
367: -- Pricing_Attr value record type
368:
369: TYPE Pricing_Attr_Val_Rec_Type IS RECORD
370: ( accumulate VARCHAR2(240) := FND_API.G_MISS_CHAR
371: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
372: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
373: , pricing_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
374: , pricing_attr_value_from_desc VARCHAR2(240) := FND_API.G_MISS_CHAR

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

367: -- Pricing_Attr value record type
368:
369: TYPE Pricing_Attr_Val_Rec_Type IS RECORD
370: ( accumulate VARCHAR2(240) := FND_API.G_MISS_CHAR
371: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
372: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
373: , pricing_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
374: , pricing_attr_value_from_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
375: , pricing_attr_value_to_desc VARCHAR2(240) := FND_API.G_MISS_CHAR

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

368:
369: TYPE Pricing_Attr_Val_Rec_Type IS RECORD
370: ( accumulate VARCHAR2(240) := FND_API.G_MISS_CHAR
371: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
372: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
373: , pricing_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
374: , pricing_attr_value_from_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
375: , pricing_attr_value_to_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
376: , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR

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

369: TYPE Pricing_Attr_Val_Rec_Type IS RECORD
370: ( accumulate VARCHAR2(240) := FND_API.G_MISS_CHAR
371: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
372: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
373: , pricing_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
374: , pricing_attr_value_from_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
375: , pricing_attr_value_to_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
376: , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
377: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR

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

370: ( accumulate VARCHAR2(240) := FND_API.G_MISS_CHAR
371: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
372: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
373: , pricing_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
374: , pricing_attr_value_from_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
375: , pricing_attr_value_to_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
376: , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
377: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
378: , pricing_phase VARCHAR2(240) := FND_API.G_MISS_CHAR

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

371: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
372: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
373: , pricing_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
374: , pricing_attr_value_from_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
375: , pricing_attr_value_to_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
376: , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
377: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
378: , pricing_phase VARCHAR2(240) := FND_API.G_MISS_CHAR
379: );

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

372: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
373: , pricing_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
374: , pricing_attr_value_from_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
375: , pricing_attr_value_to_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
376: , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
377: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
378: , pricing_phase VARCHAR2(240) := FND_API.G_MISS_CHAR
379: );
380:

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

373: , pricing_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
374: , pricing_attr_value_from_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
375: , pricing_attr_value_to_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
376: , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
377: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
378: , pricing_phase VARCHAR2(240) := FND_API.G_MISS_CHAR
379: );
380:
381: TYPE Pricing_Attr_Val_Tbl_Type IS TABLE OF Pricing_Attr_Val_Rec_Type

Line 378: , pricing_phase VARCHAR2(240) := FND_API.G_MISS_CHAR

374: , pricing_attr_value_from_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
375: , pricing_attr_value_to_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
376: , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
377: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
378: , pricing_phase VARCHAR2(240) := FND_API.G_MISS_CHAR
379: );
380:
381: TYPE Pricing_Attr_Val_Tbl_Type IS TABLE OF Pricing_Attr_Val_Rec_Type
382: INDEX BY BINARY_INTEGER;

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

459: * @rep:displayname Process Modifier
460: */
461: PROCEDURE Process_Modifiers
462: ( p_api_version_number IN NUMBER
463: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
464: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
465: , p_commit IN VARCHAR2 := FND_API.G_FALSE
466: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
467: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

460: */
461: PROCEDURE Process_Modifiers
462: ( p_api_version_number IN NUMBER
463: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
464: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
465: , p_commit IN VARCHAR2 := FND_API.G_FALSE
466: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
467: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
468: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

461: PROCEDURE Process_Modifiers
462: ( p_api_version_number IN NUMBER
463: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
464: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
465: , p_commit IN VARCHAR2 := FND_API.G_FALSE
466: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
467: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
468: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
469: , p_MODIFIER_LIST_rec IN Modifier_List_Rec_Type :=

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

509: -- End of Comments
510:
511: PROCEDURE Lock_Modifiers
512: ( p_api_version_number IN NUMBER
513: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
514: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
515: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
516: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
517: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

510:
511: PROCEDURE Lock_Modifiers
512: ( p_api_version_number IN NUMBER
513: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
514: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
515: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
516: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
517: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
518: , p_MODIFIER_LIST_rec IN Modifier_List_Rec_Type :=

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

558: -- End of Comments
559:
560: PROCEDURE Get_Modifiers
561: ( p_api_version_number IN NUMBER
562: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
563: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
564: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
565: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
566: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

559:
560: PROCEDURE Get_Modifiers
561: ( p_api_version_number IN NUMBER
562: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
563: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
564: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
565: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
566: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
567: , p_list_header_id IN NUMBER :=

Line 568: FND_API.G_MISS_NUM

564: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
565: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
566: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
567: , p_list_header_id IN NUMBER :=
568: FND_API.G_MISS_NUM
569: , p_list_header IN VARCHAR2 :=
570: FND_API.G_MISS_CHAR
571: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type
572: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type

Line 570: FND_API.G_MISS_CHAR

566: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
567: , p_list_header_id IN NUMBER :=
568: FND_API.G_MISS_NUM
569: , p_list_header IN VARCHAR2 :=
570: FND_API.G_MISS_CHAR
571: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type
572: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
573: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Tbl_Type
574: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Val_Tbl_Type