DBA Data[Home] [Help]

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: );

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: );
202:

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: );
202:
203: TYPE Modifiers_Tbl_Type IS TABLE OF Modifiers_Rec_Type

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: );
202:
203: TYPE Modifiers_Tbl_Type IS TABLE OF Modifiers_Rec_Type
204: INDEX BY BINARY_INTEGER;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 256: , created_by NUMBER := FND_API.G_MISS_NUM

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

Line 257: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM

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

Line 258: , creation_date DATE := FND_API.G_MISS_DATE

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

Line 259: , end_date_active DATE := FND_API.G_MISS_DATE

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

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

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

Line 261: , last_updated_by NUMBER := FND_API.G_MISS_NUM

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

Line 262: , last_update_date DATE := FND_API.G_MISS_DATE

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

Line 263: , last_update_login NUMBER := FND_API.G_MISS_NUM

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

Line 264: , list_header_id NUMBER := FND_API.G_MISS_NUM

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

Line 265: , list_line_id NUMBER := FND_API.G_MISS_NUM

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

Line 266: , program_application_id NUMBER := FND_API.G_MISS_NUM

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

Line 267: , program_id NUMBER := FND_API.G_MISS_NUM

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

Line 268: , program_update_date DATE := FND_API.G_MISS_DATE

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 275: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM

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

Line 276: , qualifier_id NUMBER := FND_API.G_MISS_NUM

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

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

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

Line 278: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM

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

Line 279: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM

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

Line 280: , request_id NUMBER := FND_API.G_MISS_NUM

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

Line 281: , start_date_active DATE := FND_API.G_MISS_DATE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 325: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM

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

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

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

Line 327: , created_by NUMBER := FND_API.G_MISS_NUM

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

Line 328: , creation_date DATE := FND_API.G_MISS_DATE

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

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

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

Line 330: , last_updated_by NUMBER := FND_API.G_MISS_NUM

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

Line 331: , last_update_date DATE := FND_API.G_MISS_DATE

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

Line 332: , last_update_login NUMBER := FND_API.G_MISS_NUM

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

Line 333: , list_line_id NUMBER := FND_API.G_MISS_NUM

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

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

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

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

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

Line 336: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 343: , program_application_id NUMBER := FND_API.G_MISS_NUM

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

Line 344: , program_id NUMBER := FND_API.G_MISS_NUM

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

Line 345: , program_update_date DATE := FND_API.G_MISS_DATE

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

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

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

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

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

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

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

Line 349: , list_header_id NUMBER := FND_API.G_MISS_NUM

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

Line 350: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM

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

Line 351: , request_id NUMBER := FND_API.G_MISS_NUM

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

Line 352: , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM

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

Line 353: , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM

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

Line 354: , qualification_ind NUMBER := FND_API.G_MISS_NUM

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

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

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

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

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

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

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

Line 358: , MODIFIERS_index NUMBER := FND_API.G_MISS_NUM

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 565: FND_API.G_MISS_NUM

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

Line 567: FND_API.G_MISS_CHAR

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