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