4: -- Modifier_List record type
5:
6: /*
7: TYPE Modifier_List_Rec_Type IS RECORD
8: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
9: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
10: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
5:
6: /*
7: TYPE Modifier_List_Rec_Type IS RECORD
8: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
9: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
10: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
6: /*
7: TYPE Modifier_List_Rec_Type IS RECORD
8: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
9: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
10: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
7: TYPE Modifier_List_Rec_Type IS RECORD
8: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
9: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
10: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
8: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
9: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
10: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
9: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
10: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
10: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
16: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
24: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
17: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
24: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
25: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
18: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
24: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
25: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , created_by NUMBER := FND_API.G_MISS_NUM
19: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
24: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
25: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , created_by NUMBER := FND_API.G_MISS_NUM
27: , creation_date DATE := FND_API.G_MISS_DATE
20: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
24: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
25: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , created_by NUMBER := FND_API.G_MISS_NUM
27: , creation_date DATE := FND_API.G_MISS_DATE
28: , currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
21: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
24: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
25: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , created_by NUMBER := FND_API.G_MISS_NUM
27: , creation_date DATE := FND_API.G_MISS_DATE
28: , currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
29: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
22: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
24: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
25: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , created_by NUMBER := FND_API.G_MISS_NUM
27: , creation_date DATE := FND_API.G_MISS_DATE
28: , currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
29: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
30: , end_date_active DATE := FND_API.G_MISS_DATE
23: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
24: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
25: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , created_by NUMBER := FND_API.G_MISS_NUM
27: , creation_date DATE := FND_API.G_MISS_DATE
28: , currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
29: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
30: , end_date_active DATE := FND_API.G_MISS_DATE
31: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
25: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , created_by NUMBER := FND_API.G_MISS_NUM
27: , creation_date DATE := FND_API.G_MISS_DATE
28: , currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
29: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
30: , end_date_active DATE := FND_API.G_MISS_DATE
31: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
25: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
26: , created_by NUMBER := FND_API.G_MISS_NUM
27: , creation_date DATE := FND_API.G_MISS_DATE
28: , currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
29: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
30: , end_date_active DATE := FND_API.G_MISS_DATE
31: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
33: , last_updated_by NUMBER := FND_API.G_MISS_NUM
26: , created_by NUMBER := FND_API.G_MISS_NUM
27: , creation_date DATE := FND_API.G_MISS_DATE
28: , currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
29: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
30: , end_date_active DATE := FND_API.G_MISS_DATE
31: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
33: , last_updated_by NUMBER := FND_API.G_MISS_NUM
34: , last_update_date DATE := FND_API.G_MISS_DATE
27: , creation_date DATE := FND_API.G_MISS_DATE
28: , currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
29: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
30: , end_date_active DATE := FND_API.G_MISS_DATE
31: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
33: , last_updated_by NUMBER := FND_API.G_MISS_NUM
34: , last_update_date DATE := FND_API.G_MISS_DATE
35: , last_update_login NUMBER := FND_API.G_MISS_NUM
28: , currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
29: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
30: , end_date_active DATE := FND_API.G_MISS_DATE
31: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
33: , last_updated_by NUMBER := FND_API.G_MISS_NUM
34: , last_update_date DATE := FND_API.G_MISS_DATE
35: , last_update_login NUMBER := FND_API.G_MISS_NUM
36: , list_header_id NUMBER := FND_API.G_MISS_NUM
29: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
30: , end_date_active DATE := FND_API.G_MISS_DATE
31: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
33: , last_updated_by NUMBER := FND_API.G_MISS_NUM
34: , last_update_date DATE := FND_API.G_MISS_DATE
35: , last_update_login NUMBER := FND_API.G_MISS_NUM
36: , list_header_id NUMBER := FND_API.G_MISS_NUM
37: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , end_date_active DATE := FND_API.G_MISS_DATE
31: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
33: , last_updated_by NUMBER := FND_API.G_MISS_NUM
34: , last_update_date DATE := FND_API.G_MISS_DATE
35: , last_update_login NUMBER := FND_API.G_MISS_NUM
36: , list_header_id NUMBER := FND_API.G_MISS_NUM
37: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
38: , program_application_id NUMBER := FND_API.G_MISS_NUM
31: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
33: , last_updated_by NUMBER := FND_API.G_MISS_NUM
34: , last_update_date DATE := FND_API.G_MISS_DATE
35: , last_update_login NUMBER := FND_API.G_MISS_NUM
36: , list_header_id NUMBER := FND_API.G_MISS_NUM
37: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
38: , program_application_id NUMBER := FND_API.G_MISS_NUM
39: , program_id NUMBER := FND_API.G_MISS_NUM
32: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
33: , last_updated_by NUMBER := FND_API.G_MISS_NUM
34: , last_update_date DATE := FND_API.G_MISS_DATE
35: , last_update_login NUMBER := FND_API.G_MISS_NUM
36: , list_header_id NUMBER := FND_API.G_MISS_NUM
37: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
38: , program_application_id NUMBER := FND_API.G_MISS_NUM
39: , program_id NUMBER := FND_API.G_MISS_NUM
40: , program_update_date DATE := FND_API.G_MISS_DATE
33: , last_updated_by NUMBER := FND_API.G_MISS_NUM
34: , last_update_date DATE := FND_API.G_MISS_DATE
35: , last_update_login NUMBER := FND_API.G_MISS_NUM
36: , list_header_id NUMBER := FND_API.G_MISS_NUM
37: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
38: , program_application_id NUMBER := FND_API.G_MISS_NUM
39: , program_id NUMBER := FND_API.G_MISS_NUM
40: , program_update_date DATE := FND_API.G_MISS_DATE
41: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
34: , last_update_date DATE := FND_API.G_MISS_DATE
35: , last_update_login NUMBER := FND_API.G_MISS_NUM
36: , list_header_id NUMBER := FND_API.G_MISS_NUM
37: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
38: , program_application_id NUMBER := FND_API.G_MISS_NUM
39: , program_id NUMBER := FND_API.G_MISS_NUM
40: , program_update_date DATE := FND_API.G_MISS_DATE
41: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
42: , request_id NUMBER := FND_API.G_MISS_NUM
35: , last_update_login NUMBER := FND_API.G_MISS_NUM
36: , list_header_id NUMBER := FND_API.G_MISS_NUM
37: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
38: , program_application_id NUMBER := FND_API.G_MISS_NUM
39: , program_id NUMBER := FND_API.G_MISS_NUM
40: , program_update_date DATE := FND_API.G_MISS_DATE
41: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
42: , request_id NUMBER := FND_API.G_MISS_NUM
43: , rounding_factor NUMBER := FND_API.G_MISS_NUM
36: , list_header_id NUMBER := FND_API.G_MISS_NUM
37: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
38: , program_application_id NUMBER := FND_API.G_MISS_NUM
39: , program_id NUMBER := FND_API.G_MISS_NUM
40: , program_update_date DATE := FND_API.G_MISS_DATE
41: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
42: , request_id NUMBER := FND_API.G_MISS_NUM
43: , rounding_factor NUMBER := FND_API.G_MISS_NUM
44: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
37: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
38: , program_application_id NUMBER := FND_API.G_MISS_NUM
39: , program_id NUMBER := FND_API.G_MISS_NUM
40: , program_update_date DATE := FND_API.G_MISS_DATE
41: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
42: , request_id NUMBER := FND_API.G_MISS_NUM
43: , rounding_factor NUMBER := FND_API.G_MISS_NUM
44: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , start_date_active DATE := FND_API.G_MISS_DATE
38: , program_application_id NUMBER := FND_API.G_MISS_NUM
39: , program_id NUMBER := FND_API.G_MISS_NUM
40: , program_update_date DATE := FND_API.G_MISS_DATE
41: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
42: , request_id NUMBER := FND_API.G_MISS_NUM
43: , rounding_factor NUMBER := FND_API.G_MISS_NUM
44: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , start_date_active DATE := FND_API.G_MISS_DATE
46: , terms_id NUMBER := FND_API.G_MISS_NUM
39: , program_id NUMBER := FND_API.G_MISS_NUM
40: , program_update_date DATE := FND_API.G_MISS_DATE
41: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
42: , request_id NUMBER := FND_API.G_MISS_NUM
43: , rounding_factor NUMBER := FND_API.G_MISS_NUM
44: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , start_date_active DATE := FND_API.G_MISS_DATE
46: , terms_id NUMBER := FND_API.G_MISS_NUM
47: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
40: , program_update_date DATE := FND_API.G_MISS_DATE
41: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
42: , request_id NUMBER := FND_API.G_MISS_NUM
43: , rounding_factor NUMBER := FND_API.G_MISS_NUM
44: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , start_date_active DATE := FND_API.G_MISS_DATE
46: , terms_id NUMBER := FND_API.G_MISS_NUM
47: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
41: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
42: , request_id NUMBER := FND_API.G_MISS_NUM
43: , rounding_factor NUMBER := FND_API.G_MISS_NUM
44: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , start_date_active DATE := FND_API.G_MISS_DATE
46: , terms_id NUMBER := FND_API.G_MISS_NUM
47: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
49: , parent_list_header_id NUMBER := FND_API.G_MISS_NUM
42: , request_id NUMBER := FND_API.G_MISS_NUM
43: , rounding_factor NUMBER := FND_API.G_MISS_NUM
44: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , start_date_active DATE := FND_API.G_MISS_DATE
46: , terms_id NUMBER := FND_API.G_MISS_NUM
47: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
49: , parent_list_header_id NUMBER := FND_API.G_MISS_NUM
50: , start_date_active_first DATE := FND_API.G_MISS_DATE
43: , rounding_factor NUMBER := FND_API.G_MISS_NUM
44: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , start_date_active DATE := FND_API.G_MISS_DATE
46: , terms_id NUMBER := FND_API.G_MISS_NUM
47: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
49: , parent_list_header_id NUMBER := FND_API.G_MISS_NUM
50: , start_date_active_first DATE := FND_API.G_MISS_DATE
51: , end_date_active_first DATE := FND_API.G_MISS_DATE
44: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , start_date_active DATE := FND_API.G_MISS_DATE
46: , terms_id NUMBER := FND_API.G_MISS_NUM
47: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
49: , parent_list_header_id NUMBER := FND_API.G_MISS_NUM
50: , start_date_active_first DATE := FND_API.G_MISS_DATE
51: , end_date_active_first DATE := FND_API.G_MISS_DATE
52: , active_date_first_type VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , start_date_active DATE := FND_API.G_MISS_DATE
46: , terms_id NUMBER := FND_API.G_MISS_NUM
47: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
49: , parent_list_header_id NUMBER := FND_API.G_MISS_NUM
50: , start_date_active_first DATE := FND_API.G_MISS_DATE
51: , end_date_active_first DATE := FND_API.G_MISS_DATE
52: , active_date_first_type VARCHAR2(30) := FND_API.G_MISS_CHAR
53: , start_date_active_second DATE := FND_API.G_MISS_DATE
46: , terms_id NUMBER := FND_API.G_MISS_NUM
47: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
49: , parent_list_header_id NUMBER := FND_API.G_MISS_NUM
50: , start_date_active_first DATE := FND_API.G_MISS_DATE
51: , end_date_active_first DATE := FND_API.G_MISS_DATE
52: , active_date_first_type VARCHAR2(30) := FND_API.G_MISS_CHAR
53: , start_date_active_second DATE := FND_API.G_MISS_DATE
54: , end_date_active_second DATE := FND_API.G_MISS_DATE
47: , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
49: , parent_list_header_id NUMBER := FND_API.G_MISS_NUM
50: , start_date_active_first DATE := FND_API.G_MISS_DATE
51: , end_date_active_first DATE := FND_API.G_MISS_DATE
52: , active_date_first_type VARCHAR2(30) := FND_API.G_MISS_CHAR
53: , start_date_active_second DATE := FND_API.G_MISS_DATE
54: , end_date_active_second DATE := FND_API.G_MISS_DATE
55: , active_date_second_type VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
49: , parent_list_header_id NUMBER := FND_API.G_MISS_NUM
50: , start_date_active_first DATE := FND_API.G_MISS_DATE
51: , end_date_active_first DATE := FND_API.G_MISS_DATE
52: , active_date_first_type VARCHAR2(30) := FND_API.G_MISS_CHAR
53: , start_date_active_second DATE := FND_API.G_MISS_DATE
54: , end_date_active_second DATE := FND_API.G_MISS_DATE
55: , active_date_second_type VARCHAR2(30) := FND_API.G_MISS_CHAR
56: , ask_for_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
49: , parent_list_header_id NUMBER := FND_API.G_MISS_NUM
50: , start_date_active_first DATE := FND_API.G_MISS_DATE
51: , end_date_active_first DATE := FND_API.G_MISS_DATE
52: , active_date_first_type VARCHAR2(30) := FND_API.G_MISS_CHAR
53: , start_date_active_second DATE := FND_API.G_MISS_DATE
54: , end_date_active_second DATE := FND_API.G_MISS_DATE
55: , active_date_second_type VARCHAR2(30) := FND_API.G_MISS_CHAR
56: , ask_for_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
57: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
50: , start_date_active_first DATE := FND_API.G_MISS_DATE
51: , end_date_active_first DATE := FND_API.G_MISS_DATE
52: , active_date_first_type VARCHAR2(30) := FND_API.G_MISS_CHAR
53: , start_date_active_second DATE := FND_API.G_MISS_DATE
54: , end_date_active_second DATE := FND_API.G_MISS_DATE
55: , active_date_second_type VARCHAR2(30) := FND_API.G_MISS_CHAR
56: , ask_for_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
57: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
51: , end_date_active_first DATE := FND_API.G_MISS_DATE
52: , active_date_first_type VARCHAR2(30) := FND_API.G_MISS_CHAR
53: , start_date_active_second DATE := FND_API.G_MISS_DATE
54: , end_date_active_second DATE := FND_API.G_MISS_DATE
55: , active_date_second_type VARCHAR2(30) := FND_API.G_MISS_CHAR
56: , ask_for_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
57: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
59: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
52: , active_date_first_type VARCHAR2(30) := FND_API.G_MISS_CHAR
53: , start_date_active_second DATE := FND_API.G_MISS_DATE
54: , end_date_active_second DATE := FND_API.G_MISS_DATE
55: , active_date_second_type VARCHAR2(30) := FND_API.G_MISS_CHAR
56: , ask_for_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
57: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
59: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
53: , start_date_active_second DATE := FND_API.G_MISS_DATE
54: , end_date_active_second DATE := FND_API.G_MISS_DATE
55: , active_date_second_type VARCHAR2(30) := FND_API.G_MISS_CHAR
56: , ask_for_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
57: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
59: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
61: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
54: , end_date_active_second DATE := FND_API.G_MISS_DATE
55: , active_date_second_type VARCHAR2(30) := FND_API.G_MISS_CHAR
56: , ask_for_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
57: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
59: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
61: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
62: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
55: , active_date_second_type VARCHAR2(30) := FND_API.G_MISS_CHAR
56: , ask_for_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
57: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
59: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
61: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
62: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
63: );
56: , ask_for_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
57: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
59: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
61: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
62: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
63: );
64:
57: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
58: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
59: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
61: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
62: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
63: );
64:
65:
58: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
59: , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
61: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
62: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
63: );
64:
65:
66: TYPE Modifier_List_Tbl_Type IS TABLE OF Modifier_List_Rec_Type
68:
69: -- Modifier_List value record type
70:
71: TYPE Modifier_List_Val_Rec_Type IS RECORD
72: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , currency VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
69: -- Modifier_List value record type
70:
71: TYPE Modifier_List_Val_Rec_Type IS RECORD
72: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , currency VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
70:
71: TYPE Modifier_List_Val_Rec_Type IS RECORD
72: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , currency VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
71: TYPE Modifier_List_Val_Rec_Type IS RECORD
72: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , currency VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
72: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , currency VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , currency VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
81: );
74: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
81: );
82:
75: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
81: );
82:
83: TYPE Modifier_List_Val_Tbl_Type IS TABLE OF Modifier_List_Val_Rec_Type
76: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
81: );
82:
83: TYPE Modifier_List_Val_Tbl_Type IS TABLE OF Modifier_List_Val_Rec_Type
84: INDEX BY BINARY_INTEGER;
85:
86: -- Modifiers record type
87:
88: TYPE Modifiers_Rec_Type IS RECORD
89: ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
90: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: -- Modifiers record type
87:
88: TYPE Modifiers_Rec_Type IS RECORD
89: ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
90: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
87:
88: TYPE Modifiers_Rec_Type IS RECORD
89: ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
90: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: TYPE Modifiers_Rec_Type IS RECORD
89: ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
90: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
90: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
103: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
103: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
104: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
103: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
104: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
98: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
103: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
104: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
106: --, base_qty NUMBER := FND_API.G_MISS_NUM
99: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
103: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
104: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
106: --, base_qty NUMBER := FND_API.G_MISS_NUM
107: --, base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
100: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
103: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
104: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
106: --, base_qty NUMBER := FND_API.G_MISS_NUM
107: --, base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
108: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
101: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
103: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
104: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
106: --, base_qty NUMBER := FND_API.G_MISS_NUM
107: --, base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
108: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
109: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
102: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
103: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
104: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
106: --, base_qty NUMBER := FND_API.G_MISS_NUM
107: --, base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
108: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
109: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
110: , created_by NUMBER := FND_API.G_MISS_NUM
103: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
104: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
106: --, base_qty NUMBER := FND_API.G_MISS_NUM
107: --, base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
108: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
109: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
110: , created_by NUMBER := FND_API.G_MISS_NUM
111: , creation_date DATE := FND_API.G_MISS_DATE
104: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
106: --, base_qty NUMBER := FND_API.G_MISS_NUM
107: --, base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
108: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
109: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
110: , created_by NUMBER := FND_API.G_MISS_NUM
111: , creation_date DATE := FND_API.G_MISS_DATE
112: , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
105: , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
106: --, base_qty NUMBER := FND_API.G_MISS_NUM
107: --, base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
108: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
109: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
110: , created_by NUMBER := FND_API.G_MISS_NUM
111: , creation_date DATE := FND_API.G_MISS_DATE
112: , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
113: , end_date_active DATE := FND_API.G_MISS_DATE
106: --, base_qty NUMBER := FND_API.G_MISS_NUM
107: --, base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
108: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
109: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
110: , created_by NUMBER := FND_API.G_MISS_NUM
111: , creation_date DATE := FND_API.G_MISS_DATE
112: , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
113: , end_date_active DATE := FND_API.G_MISS_DATE
114: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
107: --, base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
108: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
109: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
110: , created_by NUMBER := FND_API.G_MISS_NUM
111: , creation_date DATE := FND_API.G_MISS_DATE
112: , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
113: , end_date_active DATE := FND_API.G_MISS_DATE
114: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
115: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
108: , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
109: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
110: , created_by NUMBER := FND_API.G_MISS_NUM
111: , creation_date DATE := FND_API.G_MISS_DATE
112: , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
113: , end_date_active DATE := FND_API.G_MISS_DATE
114: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
115: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
116: --, gl_class_id NUMBER := FND_API.G_MISS_NUM
109: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
110: , created_by NUMBER := FND_API.G_MISS_NUM
111: , creation_date DATE := FND_API.G_MISS_DATE
112: , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
113: , end_date_active DATE := FND_API.G_MISS_DATE
114: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
115: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
116: --, gl_class_id NUMBER := FND_API.G_MISS_NUM
117: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
110: , created_by NUMBER := FND_API.G_MISS_NUM
111: , creation_date DATE := FND_API.G_MISS_DATE
112: , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
113: , end_date_active DATE := FND_API.G_MISS_DATE
114: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
115: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
116: --, gl_class_id NUMBER := FND_API.G_MISS_NUM
117: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
118: , last_updated_by NUMBER := FND_API.G_MISS_NUM
111: , creation_date DATE := FND_API.G_MISS_DATE
112: , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
113: , end_date_active DATE := FND_API.G_MISS_DATE
114: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
115: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
116: --, gl_class_id NUMBER := FND_API.G_MISS_NUM
117: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
118: , last_updated_by NUMBER := FND_API.G_MISS_NUM
119: , last_update_date DATE := FND_API.G_MISS_DATE
112: , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
113: , end_date_active DATE := FND_API.G_MISS_DATE
114: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
115: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
116: --, gl_class_id NUMBER := FND_API.G_MISS_NUM
117: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
118: , last_updated_by NUMBER := FND_API.G_MISS_NUM
119: , last_update_date DATE := FND_API.G_MISS_DATE
120: , last_update_login NUMBER := FND_API.G_MISS_NUM
113: , end_date_active DATE := FND_API.G_MISS_DATE
114: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
115: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
116: --, gl_class_id NUMBER := FND_API.G_MISS_NUM
117: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
118: , last_updated_by NUMBER := FND_API.G_MISS_NUM
119: , last_update_date DATE := FND_API.G_MISS_DATE
120: , last_update_login NUMBER := FND_API.G_MISS_NUM
121: , list_header_id NUMBER := FND_API.G_MISS_NUM
114: , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
115: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
116: --, gl_class_id NUMBER := FND_API.G_MISS_NUM
117: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
118: , last_updated_by NUMBER := FND_API.G_MISS_NUM
119: , last_update_date DATE := FND_API.G_MISS_DATE
120: , last_update_login NUMBER := FND_API.G_MISS_NUM
121: , list_header_id NUMBER := FND_API.G_MISS_NUM
122: , list_line_id NUMBER := FND_API.G_MISS_NUM
115: , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
116: --, gl_class_id NUMBER := FND_API.G_MISS_NUM
117: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
118: , last_updated_by NUMBER := FND_API.G_MISS_NUM
119: , last_update_date DATE := FND_API.G_MISS_DATE
120: , last_update_login NUMBER := FND_API.G_MISS_NUM
121: , list_header_id NUMBER := FND_API.G_MISS_NUM
122: , list_line_id NUMBER := FND_API.G_MISS_NUM
123: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
116: --, gl_class_id NUMBER := FND_API.G_MISS_NUM
117: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
118: , last_updated_by NUMBER := FND_API.G_MISS_NUM
119: , last_update_date DATE := FND_API.G_MISS_DATE
120: , last_update_login NUMBER := FND_API.G_MISS_NUM
121: , list_header_id NUMBER := FND_API.G_MISS_NUM
122: , list_line_id NUMBER := FND_API.G_MISS_NUM
123: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
124: , list_price NUMBER := FND_API.G_MISS_NUM
117: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
118: , last_updated_by NUMBER := FND_API.G_MISS_NUM
119: , last_update_date DATE := FND_API.G_MISS_DATE
120: , last_update_login NUMBER := FND_API.G_MISS_NUM
121: , list_header_id NUMBER := FND_API.G_MISS_NUM
122: , list_line_id NUMBER := FND_API.G_MISS_NUM
123: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
124: , list_price NUMBER := FND_API.G_MISS_NUM
125: --, list_price_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
118: , last_updated_by NUMBER := FND_API.G_MISS_NUM
119: , last_update_date DATE := FND_API.G_MISS_DATE
120: , last_update_login NUMBER := FND_API.G_MISS_NUM
121: , list_header_id NUMBER := FND_API.G_MISS_NUM
122: , list_line_id NUMBER := FND_API.G_MISS_NUM
123: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
124: , list_price NUMBER := FND_API.G_MISS_NUM
125: --, list_price_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
126: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
119: , last_update_date DATE := FND_API.G_MISS_DATE
120: , last_update_login NUMBER := FND_API.G_MISS_NUM
121: , list_header_id NUMBER := FND_API.G_MISS_NUM
122: , list_line_id NUMBER := FND_API.G_MISS_NUM
123: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
124: , list_price NUMBER := FND_API.G_MISS_NUM
125: --, list_price_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
126: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
127: --, new_price NUMBER := FND_API.G_MISS_NUM
120: , last_update_login NUMBER := FND_API.G_MISS_NUM
121: , list_header_id NUMBER := FND_API.G_MISS_NUM
122: , list_line_id NUMBER := FND_API.G_MISS_NUM
123: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
124: , list_price NUMBER := FND_API.G_MISS_NUM
125: --, list_price_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
126: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
127: --, new_price NUMBER := FND_API.G_MISS_NUM
128: , number_effective_periods NUMBER := FND_API.G_MISS_NUM
121: , list_header_id NUMBER := FND_API.G_MISS_NUM
122: , list_line_id NUMBER := FND_API.G_MISS_NUM
123: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
124: , list_price NUMBER := FND_API.G_MISS_NUM
125: --, list_price_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
126: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
127: --, new_price NUMBER := FND_API.G_MISS_NUM
128: , number_effective_periods NUMBER := FND_API.G_MISS_NUM
129: , operand NUMBER := FND_API.G_MISS_NUM
122: , list_line_id NUMBER := FND_API.G_MISS_NUM
123: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
124: , list_price NUMBER := FND_API.G_MISS_NUM
125: --, list_price_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
126: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
127: --, new_price NUMBER := FND_API.G_MISS_NUM
128: , number_effective_periods NUMBER := FND_API.G_MISS_NUM
129: , operand NUMBER := FND_API.G_MISS_NUM
130: , organization_id NUMBER := FND_API.G_MISS_NUM
123: , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
124: , list_price NUMBER := FND_API.G_MISS_NUM
125: --, list_price_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
126: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
127: --, new_price NUMBER := FND_API.G_MISS_NUM
128: , number_effective_periods NUMBER := FND_API.G_MISS_NUM
129: , operand NUMBER := FND_API.G_MISS_NUM
130: , organization_id NUMBER := FND_API.G_MISS_NUM
131: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
124: , list_price NUMBER := FND_API.G_MISS_NUM
125: --, list_price_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
126: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
127: --, new_price NUMBER := FND_API.G_MISS_NUM
128: , number_effective_periods NUMBER := FND_API.G_MISS_NUM
129: , operand NUMBER := FND_API.G_MISS_NUM
130: , organization_id NUMBER := FND_API.G_MISS_NUM
131: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
132: , percent_price NUMBER := FND_API.G_MISS_NUM
125: --, list_price_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
126: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
127: --, new_price NUMBER := FND_API.G_MISS_NUM
128: , number_effective_periods NUMBER := FND_API.G_MISS_NUM
129: , operand NUMBER := FND_API.G_MISS_NUM
130: , organization_id NUMBER := FND_API.G_MISS_NUM
131: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
132: , percent_price NUMBER := FND_API.G_MISS_NUM
133: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
126: , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
127: --, new_price NUMBER := FND_API.G_MISS_NUM
128: , number_effective_periods NUMBER := FND_API.G_MISS_NUM
129: , operand NUMBER := FND_API.G_MISS_NUM
130: , organization_id NUMBER := FND_API.G_MISS_NUM
131: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
132: , percent_price NUMBER := FND_API.G_MISS_NUM
133: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
134: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
127: --, new_price NUMBER := FND_API.G_MISS_NUM
128: , number_effective_periods NUMBER := FND_API.G_MISS_NUM
129: , operand NUMBER := FND_API.G_MISS_NUM
130: , organization_id NUMBER := FND_API.G_MISS_NUM
131: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
132: , percent_price NUMBER := FND_API.G_MISS_NUM
133: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
134: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
135: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
128: , number_effective_periods NUMBER := FND_API.G_MISS_NUM
129: , operand NUMBER := FND_API.G_MISS_NUM
130: , organization_id NUMBER := FND_API.G_MISS_NUM
131: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
132: , percent_price NUMBER := FND_API.G_MISS_NUM
133: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
134: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
135: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
136: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
129: , operand NUMBER := FND_API.G_MISS_NUM
130: , organization_id NUMBER := FND_API.G_MISS_NUM
131: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
132: , percent_price NUMBER := FND_API.G_MISS_NUM
133: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
134: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
135: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
136: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
137: , program_application_id NUMBER := FND_API.G_MISS_NUM
130: , organization_id NUMBER := FND_API.G_MISS_NUM
131: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
132: , percent_price NUMBER := FND_API.G_MISS_NUM
133: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
134: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
135: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
136: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
137: , program_application_id NUMBER := FND_API.G_MISS_NUM
138: , program_id NUMBER := FND_API.G_MISS_NUM
131: , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
132: , percent_price NUMBER := FND_API.G_MISS_NUM
133: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
134: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
135: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
136: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
137: , program_application_id NUMBER := FND_API.G_MISS_NUM
138: , program_id NUMBER := FND_API.G_MISS_NUM
139: , program_update_date DATE := FND_API.G_MISS_DATE
132: , percent_price NUMBER := FND_API.G_MISS_NUM
133: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
134: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
135: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
136: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
137: , program_application_id NUMBER := FND_API.G_MISS_NUM
138: , program_id NUMBER := FND_API.G_MISS_NUM
139: , program_update_date DATE := FND_API.G_MISS_DATE
140: --, rebate_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
133: , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
134: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
135: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
136: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
137: , program_application_id NUMBER := FND_API.G_MISS_NUM
138: , program_id NUMBER := FND_API.G_MISS_NUM
139: , program_update_date DATE := FND_API.G_MISS_DATE
140: --, rebate_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
134: , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
135: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
136: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
137: , program_application_id NUMBER := FND_API.G_MISS_NUM
138: , program_id NUMBER := FND_API.G_MISS_NUM
139: , program_update_date DATE := FND_API.G_MISS_DATE
140: --, rebate_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , related_item_id NUMBER := FND_API.G_MISS_NUM
135: , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
136: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
137: , program_application_id NUMBER := FND_API.G_MISS_NUM
138: , program_id NUMBER := FND_API.G_MISS_NUM
139: , program_update_date DATE := FND_API.G_MISS_DATE
140: --, rebate_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , related_item_id NUMBER := FND_API.G_MISS_NUM
143: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
136: , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
137: , program_application_id NUMBER := FND_API.G_MISS_NUM
138: , program_id NUMBER := FND_API.G_MISS_NUM
139: , program_update_date DATE := FND_API.G_MISS_DATE
140: --, rebate_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , related_item_id NUMBER := FND_API.G_MISS_NUM
143: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
144: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
137: , program_application_id NUMBER := FND_API.G_MISS_NUM
138: , program_id NUMBER := FND_API.G_MISS_NUM
139: , program_update_date DATE := FND_API.G_MISS_DATE
140: --, rebate_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , related_item_id NUMBER := FND_API.G_MISS_NUM
143: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
144: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , request_id NUMBER := FND_API.G_MISS_NUM
138: , program_id NUMBER := FND_API.G_MISS_NUM
139: , program_update_date DATE := FND_API.G_MISS_DATE
140: --, rebate_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , related_item_id NUMBER := FND_API.G_MISS_NUM
143: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
144: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , request_id NUMBER := FND_API.G_MISS_NUM
146: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
139: , program_update_date DATE := FND_API.G_MISS_DATE
140: --, rebate_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , related_item_id NUMBER := FND_API.G_MISS_NUM
143: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
144: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , request_id NUMBER := FND_API.G_MISS_NUM
146: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
147: , revision_date DATE := FND_API.G_MISS_DATE
140: --, rebate_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , related_item_id NUMBER := FND_API.G_MISS_NUM
143: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
144: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , request_id NUMBER := FND_API.G_MISS_NUM
146: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
147: , revision_date DATE := FND_API.G_MISS_DATE
148: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141: , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142: , related_item_id NUMBER := FND_API.G_MISS_NUM
143: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
144: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , request_id NUMBER := FND_API.G_MISS_NUM
146: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
147: , revision_date DATE := FND_API.G_MISS_DATE
148: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
149: , start_date_active DATE := FND_API.G_MISS_DATE
142: , related_item_id NUMBER := FND_API.G_MISS_NUM
143: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
144: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , request_id NUMBER := FND_API.G_MISS_NUM
146: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
147: , revision_date DATE := FND_API.G_MISS_DATE
148: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
149: , start_date_active DATE := FND_API.G_MISS_DATE
150: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
143: , relationship_type_id NUMBER := FND_API.G_MISS_NUM
144: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , request_id NUMBER := FND_API.G_MISS_NUM
146: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
147: , revision_date DATE := FND_API.G_MISS_DATE
148: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
149: , start_date_active DATE := FND_API.G_MISS_DATE
150: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
151: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
144: , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , request_id NUMBER := FND_API.G_MISS_NUM
146: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
147: , revision_date DATE := FND_API.G_MISS_DATE
148: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
149: , start_date_active DATE := FND_API.G_MISS_DATE
150: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
151: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
152: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
145: , request_id NUMBER := FND_API.G_MISS_NUM
146: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
147: , revision_date DATE := FND_API.G_MISS_DATE
148: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
149: , start_date_active DATE := FND_API.G_MISS_DATE
150: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
151: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
152: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
147: , revision_date DATE := FND_API.G_MISS_DATE
148: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
149: , start_date_active DATE := FND_API.G_MISS_DATE
150: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
151: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
152: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
154: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
147: , revision_date DATE := FND_API.G_MISS_DATE
148: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
149: , start_date_active DATE := FND_API.G_MISS_DATE
150: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
151: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
152: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
154: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
155: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
148: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
149: , start_date_active DATE := FND_API.G_MISS_DATE
150: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
151: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
152: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
154: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
155: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
156: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
149: , start_date_active DATE := FND_API.G_MISS_DATE
150: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
151: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
152: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
154: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
155: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
156: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
157: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
150: , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
151: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
152: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
154: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
155: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
156: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
157: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
158: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
151: , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
152: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
154: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
155: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
156: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
157: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
158: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
159: , rltd_modifier_grp_no NUMBER := FND_API.G_MISS_NUM
152: , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
154: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
155: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
156: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
157: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
158: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
159: , rltd_modifier_grp_no NUMBER := FND_API.G_MISS_NUM
160: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
153: , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
154: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
155: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
156: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
157: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
158: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
159: , rltd_modifier_grp_no NUMBER := FND_API.G_MISS_NUM
160: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
161: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
154: , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
155: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
156: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
157: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
158: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
159: , rltd_modifier_grp_no NUMBER := FND_API.G_MISS_NUM
160: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
161: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
162: , product_precedence NUMBER := FND_API.G_MISS_NUM
155: , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
156: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
157: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
158: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
159: , rltd_modifier_grp_no NUMBER := FND_API.G_MISS_NUM
160: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
161: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
162: , product_precedence NUMBER := FND_API.G_MISS_NUM
163: , expiration_period_start_date DATE := FND_API.G_MISS_DATE
156: , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
157: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
158: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
159: , rltd_modifier_grp_no NUMBER := FND_API.G_MISS_NUM
160: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
161: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
162: , product_precedence NUMBER := FND_API.G_MISS_NUM
163: , expiration_period_start_date DATE := FND_API.G_MISS_DATE
164: , number_expiration_periods NUMBER := FND_API.G_MISS_NUM
157: , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
158: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
159: , rltd_modifier_grp_no NUMBER := FND_API.G_MISS_NUM
160: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
161: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
162: , product_precedence NUMBER := FND_API.G_MISS_NUM
163: , expiration_period_start_date DATE := FND_API.G_MISS_DATE
164: , number_expiration_periods NUMBER := FND_API.G_MISS_NUM
165: , expiration_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
158: , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
159: , rltd_modifier_grp_no NUMBER := FND_API.G_MISS_NUM
160: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
161: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
162: , product_precedence NUMBER := FND_API.G_MISS_NUM
163: , expiration_period_start_date DATE := FND_API.G_MISS_DATE
164: , number_expiration_periods NUMBER := FND_API.G_MISS_NUM
165: , expiration_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
166: , expiration_date DATE := FND_API.G_MISS_DATE
159: , rltd_modifier_grp_no NUMBER := FND_API.G_MISS_NUM
160: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
161: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
162: , product_precedence NUMBER := FND_API.G_MISS_NUM
163: , expiration_period_start_date DATE := FND_API.G_MISS_DATE
164: , number_expiration_periods NUMBER := FND_API.G_MISS_NUM
165: , expiration_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
166: , expiration_date DATE := FND_API.G_MISS_DATE
167: , estim_gl_value NUMBER := FND_API.G_MISS_NUM
160: , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
161: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
162: , product_precedence NUMBER := FND_API.G_MISS_NUM
163: , expiration_period_start_date DATE := FND_API.G_MISS_DATE
164: , number_expiration_periods NUMBER := FND_API.G_MISS_NUM
165: , expiration_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
166: , expiration_date DATE := FND_API.G_MISS_DATE
167: , estim_gl_value NUMBER := FND_API.G_MISS_NUM
168: , benefit_price_list_line_id NUMBER := FND_API.G_MISS_NUM
161: , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
162: , product_precedence NUMBER := FND_API.G_MISS_NUM
163: , expiration_period_start_date DATE := FND_API.G_MISS_DATE
164: , number_expiration_periods NUMBER := FND_API.G_MISS_NUM
165: , expiration_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
166: , expiration_date DATE := FND_API.G_MISS_DATE
167: , estim_gl_value NUMBER := FND_API.G_MISS_NUM
168: , benefit_price_list_line_id NUMBER := FND_API.G_MISS_NUM
169: --, recurring_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
162: , product_precedence NUMBER := FND_API.G_MISS_NUM
163: , expiration_period_start_date DATE := FND_API.G_MISS_DATE
164: , number_expiration_periods NUMBER := FND_API.G_MISS_NUM
165: , expiration_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
166: , expiration_date DATE := FND_API.G_MISS_DATE
167: , estim_gl_value NUMBER := FND_API.G_MISS_NUM
168: , benefit_price_list_line_id NUMBER := FND_API.G_MISS_NUM
169: --, recurring_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
170: , benefit_limit NUMBER := FND_API.G_MISS_NUM
163: , expiration_period_start_date DATE := FND_API.G_MISS_DATE
164: , number_expiration_periods NUMBER := FND_API.G_MISS_NUM
165: , expiration_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
166: , expiration_date DATE := FND_API.G_MISS_DATE
167: , estim_gl_value NUMBER := FND_API.G_MISS_NUM
168: , benefit_price_list_line_id NUMBER := FND_API.G_MISS_NUM
169: --, recurring_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
170: , benefit_limit NUMBER := FND_API.G_MISS_NUM
171: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
164: , number_expiration_periods NUMBER := FND_API.G_MISS_NUM
165: , expiration_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
166: , expiration_date DATE := FND_API.G_MISS_DATE
167: , estim_gl_value NUMBER := FND_API.G_MISS_NUM
168: , benefit_price_list_line_id NUMBER := FND_API.G_MISS_NUM
169: --, recurring_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
170: , benefit_limit NUMBER := FND_API.G_MISS_NUM
171: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
172: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
165: , expiration_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
166: , expiration_date DATE := FND_API.G_MISS_DATE
167: , estim_gl_value NUMBER := FND_API.G_MISS_NUM
168: , benefit_price_list_line_id NUMBER := FND_API.G_MISS_NUM
169: --, recurring_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
170: , benefit_limit NUMBER := FND_API.G_MISS_NUM
171: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
172: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
173: , benefit_qty NUMBER := FND_API.G_MISS_NUM
166: , expiration_date DATE := FND_API.G_MISS_DATE
167: , estim_gl_value NUMBER := FND_API.G_MISS_NUM
168: , benefit_price_list_line_id NUMBER := FND_API.G_MISS_NUM
169: --, recurring_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
170: , benefit_limit NUMBER := FND_API.G_MISS_NUM
171: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
172: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
173: , benefit_qty NUMBER := FND_API.G_MISS_NUM
174: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
167: , estim_gl_value NUMBER := FND_API.G_MISS_NUM
168: , benefit_price_list_line_id NUMBER := FND_API.G_MISS_NUM
169: --, recurring_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
170: , benefit_limit NUMBER := FND_API.G_MISS_NUM
171: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
172: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
173: , benefit_qty NUMBER := FND_API.G_MISS_NUM
174: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
175: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
168: , benefit_price_list_line_id NUMBER := FND_API.G_MISS_NUM
169: --, recurring_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
170: , benefit_limit NUMBER := FND_API.G_MISS_NUM
171: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
172: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
173: , benefit_qty NUMBER := FND_API.G_MISS_NUM
174: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
175: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
176: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
169: --, recurring_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
170: , benefit_limit NUMBER := FND_API.G_MISS_NUM
171: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
172: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
173: , benefit_qty NUMBER := FND_API.G_MISS_NUM
174: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
175: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
176: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
177: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
170: , benefit_limit NUMBER := FND_API.G_MISS_NUM
171: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
172: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
173: , benefit_qty NUMBER := FND_API.G_MISS_NUM
174: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
175: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
176: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
177: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
178: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
171: , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
172: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
173: , benefit_qty NUMBER := FND_API.G_MISS_NUM
174: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
175: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
176: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
177: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
178: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
179: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
172: , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
173: , benefit_qty NUMBER := FND_API.G_MISS_NUM
174: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
175: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
176: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
177: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
178: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
179: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
180: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
173: , benefit_qty NUMBER := FND_API.G_MISS_NUM
174: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
175: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
176: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
177: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
178: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
179: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
180: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
181: );
174: , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
175: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
176: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
177: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
178: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
179: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
180: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
181: );
182:
175: , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
176: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
177: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
178: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
179: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
180: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
181: );
182:
183: TYPE Modifiers_Tbl_Type IS TABLE OF Modifiers_Rec_Type
176: , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
177: , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
178: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
179: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
180: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
181: );
182:
183: TYPE Modifiers_Tbl_Type IS TABLE OF Modifiers_Rec_Type
184: INDEX BY BINARY_INTEGER;
185:
186: -- Modifiers value record type
187:
188: TYPE Modifiers_Val_Rec_Type IS RECORD
189: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
190: , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
191: , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
192: , gl_class VARCHAR2(240) := FND_API.G_MISS_CHAR
193: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
186: -- Modifiers value record type
187:
188: TYPE Modifiers_Val_Rec_Type IS RECORD
189: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
190: , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
191: , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
192: , gl_class VARCHAR2(240) := FND_API.G_MISS_CHAR
193: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
194: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
187:
188: TYPE Modifiers_Val_Rec_Type IS RECORD
189: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
190: , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
191: , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
192: , gl_class VARCHAR2(240) := FND_API.G_MISS_CHAR
193: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
194: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
195: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
188: TYPE Modifiers_Val_Rec_Type IS RECORD
189: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
190: , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
191: , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
192: , gl_class VARCHAR2(240) := FND_API.G_MISS_CHAR
193: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
194: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
195: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
189: ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
190: , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
191: , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
192: , gl_class VARCHAR2(240) := FND_API.G_MISS_CHAR
193: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
194: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
195: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , list_price_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
190: , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
191: , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
192: , gl_class VARCHAR2(240) := FND_API.G_MISS_CHAR
193: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
194: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
195: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , list_price_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
191: , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
192: , gl_class VARCHAR2(240) := FND_API.G_MISS_CHAR
193: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
194: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
195: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , list_price_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
192: , gl_class VARCHAR2(240) := FND_API.G_MISS_CHAR
193: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
194: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
195: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , list_price_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
193: , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
194: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
195: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , list_price_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
194: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
195: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , list_price_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
195: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , list_price_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
196: , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , list_price_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
197: , list_price_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , rebate_subtype VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , rebate_subtype VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , rebate_subtype VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , override VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , rebate_subtype VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , rebate_subtype VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , rebate_subtype VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , rebate_subtype VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
211: );
204: , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , rebate_subtype VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
211: );
212:
205: , rebate_subtype VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
211: );
212:
213: TYPE Modifiers_Val_Tbl_Type IS TABLE OF Modifiers_Val_Rec_Type
206: , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
211: );
212:
213: TYPE Modifiers_Val_Tbl_Type IS TABLE OF Modifiers_Val_Rec_Type
214: INDEX BY BINARY_INTEGER;
214: INDEX BY BINARY_INTEGER;
215:
216: -- Qualifiers record type
217: TYPE Qualifiers_Rec_Type IS RECORD
218: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
219: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
220: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
221: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
215:
216: -- Qualifiers record type
217: TYPE Qualifiers_Rec_Type IS RECORD
218: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
219: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
220: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
221: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
216: -- Qualifiers record type
217: TYPE Qualifiers_Rec_Type IS RECORD
218: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
219: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
220: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
221: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
217: TYPE Qualifiers_Rec_Type IS RECORD
218: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
219: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
220: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
221: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
218: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
219: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
220: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
221: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
219: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
220: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
221: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
220: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
221: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
221: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
222: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
223: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
224: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
225: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
226: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
226: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
227: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
234: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
227: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
228: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
234: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
235: , created_by NUMBER := FND_API.G_MISS_NUM
228: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
229: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
234: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
235: , created_by NUMBER := FND_API.G_MISS_NUM
236: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
229: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
230: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
234: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
235: , created_by NUMBER := FND_API.G_MISS_NUM
236: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
237: , creation_date DATE := FND_API.G_MISS_DATE
230: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
231: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
234: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
235: , created_by NUMBER := FND_API.G_MISS_NUM
236: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
237: , creation_date DATE := FND_API.G_MISS_DATE
238: , end_date_active DATE := FND_API.G_MISS_DATE
231: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
234: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
235: , created_by NUMBER := FND_API.G_MISS_NUM
236: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
237: , creation_date DATE := FND_API.G_MISS_DATE
238: , end_date_active DATE := FND_API.G_MISS_DATE
239: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
232: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
234: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
235: , created_by NUMBER := FND_API.G_MISS_NUM
236: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
237: , creation_date DATE := FND_API.G_MISS_DATE
238: , end_date_active DATE := FND_API.G_MISS_DATE
239: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
240: , last_updated_by NUMBER := FND_API.G_MISS_NUM
233: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
234: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
235: , created_by NUMBER := FND_API.G_MISS_NUM
236: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
237: , creation_date DATE := FND_API.G_MISS_DATE
238: , end_date_active DATE := FND_API.G_MISS_DATE
239: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
240: , last_updated_by NUMBER := FND_API.G_MISS_NUM
241: , last_update_date DATE := FND_API.G_MISS_DATE
234: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
235: , created_by NUMBER := FND_API.G_MISS_NUM
236: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
237: , creation_date DATE := FND_API.G_MISS_DATE
238: , end_date_active DATE := FND_API.G_MISS_DATE
239: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
240: , last_updated_by NUMBER := FND_API.G_MISS_NUM
241: , last_update_date DATE := FND_API.G_MISS_DATE
242: , last_update_login NUMBER := FND_API.G_MISS_NUM
235: , created_by NUMBER := FND_API.G_MISS_NUM
236: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
237: , creation_date DATE := FND_API.G_MISS_DATE
238: , end_date_active DATE := FND_API.G_MISS_DATE
239: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
240: , last_updated_by NUMBER := FND_API.G_MISS_NUM
241: , last_update_date DATE := FND_API.G_MISS_DATE
242: , last_update_login NUMBER := FND_API.G_MISS_NUM
243: , list_header_id NUMBER := FND_API.G_MISS_NUM
236: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
237: , creation_date DATE := FND_API.G_MISS_DATE
238: , end_date_active DATE := FND_API.G_MISS_DATE
239: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
240: , last_updated_by NUMBER := FND_API.G_MISS_NUM
241: , last_update_date DATE := FND_API.G_MISS_DATE
242: , last_update_login NUMBER := FND_API.G_MISS_NUM
243: , list_header_id NUMBER := FND_API.G_MISS_NUM
244: , list_line_id NUMBER := FND_API.G_MISS_NUM
237: , creation_date DATE := FND_API.G_MISS_DATE
238: , end_date_active DATE := FND_API.G_MISS_DATE
239: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
240: , last_updated_by NUMBER := FND_API.G_MISS_NUM
241: , last_update_date DATE := FND_API.G_MISS_DATE
242: , last_update_login NUMBER := FND_API.G_MISS_NUM
243: , list_header_id NUMBER := FND_API.G_MISS_NUM
244: , list_line_id NUMBER := FND_API.G_MISS_NUM
245: , program_application_id NUMBER := FND_API.G_MISS_NUM
238: , end_date_active DATE := FND_API.G_MISS_DATE
239: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
240: , last_updated_by NUMBER := FND_API.G_MISS_NUM
241: , last_update_date DATE := FND_API.G_MISS_DATE
242: , last_update_login NUMBER := FND_API.G_MISS_NUM
243: , list_header_id NUMBER := FND_API.G_MISS_NUM
244: , list_line_id NUMBER := FND_API.G_MISS_NUM
245: , program_application_id NUMBER := FND_API.G_MISS_NUM
246: , program_id NUMBER := FND_API.G_MISS_NUM
239: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
240: , last_updated_by NUMBER := FND_API.G_MISS_NUM
241: , last_update_date DATE := FND_API.G_MISS_DATE
242: , last_update_login NUMBER := FND_API.G_MISS_NUM
243: , list_header_id NUMBER := FND_API.G_MISS_NUM
244: , list_line_id NUMBER := FND_API.G_MISS_NUM
245: , program_application_id NUMBER := FND_API.G_MISS_NUM
246: , program_id NUMBER := FND_API.G_MISS_NUM
247: , program_update_date DATE := FND_API.G_MISS_DATE
240: , last_updated_by NUMBER := FND_API.G_MISS_NUM
241: , last_update_date DATE := FND_API.G_MISS_DATE
242: , last_update_login NUMBER := FND_API.G_MISS_NUM
243: , list_header_id NUMBER := FND_API.G_MISS_NUM
244: , list_line_id NUMBER := FND_API.G_MISS_NUM
245: , program_application_id NUMBER := FND_API.G_MISS_NUM
246: , program_id NUMBER := FND_API.G_MISS_NUM
247: , program_update_date DATE := FND_API.G_MISS_DATE
248: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
241: , last_update_date DATE := FND_API.G_MISS_DATE
242: , last_update_login NUMBER := FND_API.G_MISS_NUM
243: , list_header_id NUMBER := FND_API.G_MISS_NUM
244: , list_line_id NUMBER := FND_API.G_MISS_NUM
245: , program_application_id NUMBER := FND_API.G_MISS_NUM
246: , program_id NUMBER := FND_API.G_MISS_NUM
247: , program_update_date DATE := FND_API.G_MISS_DATE
248: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
249: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
242: , last_update_login NUMBER := FND_API.G_MISS_NUM
243: , list_header_id NUMBER := FND_API.G_MISS_NUM
244: , list_line_id NUMBER := FND_API.G_MISS_NUM
245: , program_application_id NUMBER := FND_API.G_MISS_NUM
246: , program_id NUMBER := FND_API.G_MISS_NUM
247: , program_update_date DATE := FND_API.G_MISS_DATE
248: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
249: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
243: , list_header_id NUMBER := FND_API.G_MISS_NUM
244: , list_line_id NUMBER := FND_API.G_MISS_NUM
245: , program_application_id NUMBER := FND_API.G_MISS_NUM
246: , program_id NUMBER := FND_API.G_MISS_NUM
247: , program_update_date DATE := FND_API.G_MISS_DATE
248: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
249: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
251: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
244: , list_line_id NUMBER := FND_API.G_MISS_NUM
245: , program_application_id NUMBER := FND_API.G_MISS_NUM
246: , program_id NUMBER := FND_API.G_MISS_NUM
247: , program_update_date DATE := FND_API.G_MISS_DATE
248: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
249: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
251: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
252: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
245: , program_application_id NUMBER := FND_API.G_MISS_NUM
246: , program_id NUMBER := FND_API.G_MISS_NUM
247: , program_update_date DATE := FND_API.G_MISS_DATE
248: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
249: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
251: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
252: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
253: --, qualifier_date_format VARCHAR2(30) := FND_API.G_MISS_CHAR
246: , program_id NUMBER := FND_API.G_MISS_NUM
247: , program_update_date DATE := FND_API.G_MISS_DATE
248: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
249: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
251: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
252: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
253: --, qualifier_date_format VARCHAR2(30) := FND_API.G_MISS_CHAR
254: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
247: , program_update_date DATE := FND_API.G_MISS_DATE
248: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
249: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
251: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
252: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
253: --, qualifier_date_format VARCHAR2(30) := FND_API.G_MISS_CHAR
254: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
255: , qualifier_id NUMBER := FND_API.G_MISS_NUM
248: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
249: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
251: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
252: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
253: --, qualifier_date_format VARCHAR2(30) := FND_API.G_MISS_CHAR
254: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
255: , qualifier_id NUMBER := FND_API.G_MISS_NUM
256: --, qualifier_number_format VARCHAR2(30) := FND_API.G_MISS_CHAR
249: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
250: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
251: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
252: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
253: --, qualifier_date_format VARCHAR2(30) := FND_API.G_MISS_CHAR
254: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
255: , qualifier_id NUMBER := FND_API.G_MISS_NUM
256: --, qualifier_number_format VARCHAR2(30) := FND_API.G_MISS_CHAR
257: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
250: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
251: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
252: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
253: --, qualifier_date_format VARCHAR2(30) := FND_API.G_MISS_CHAR
254: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
255: , qualifier_id NUMBER := FND_API.G_MISS_NUM
256: --, qualifier_number_format VARCHAR2(30) := FND_API.G_MISS_CHAR
257: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
258: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
251: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
252: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
253: --, qualifier_date_format VARCHAR2(30) := FND_API.G_MISS_CHAR
254: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
255: , qualifier_id NUMBER := FND_API.G_MISS_NUM
256: --, qualifier_number_format VARCHAR2(30) := FND_API.G_MISS_CHAR
257: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
258: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
259: , request_id NUMBER := FND_API.G_MISS_NUM
252: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
253: --, qualifier_date_format VARCHAR2(30) := FND_API.G_MISS_CHAR
254: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
255: , qualifier_id NUMBER := FND_API.G_MISS_NUM
256: --, qualifier_number_format VARCHAR2(30) := FND_API.G_MISS_CHAR
257: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
258: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
259: , request_id NUMBER := FND_API.G_MISS_NUM
260: , start_date_active DATE := FND_API.G_MISS_DATE
253: --, qualifier_date_format VARCHAR2(30) := FND_API.G_MISS_CHAR
254: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
255: , qualifier_id NUMBER := FND_API.G_MISS_NUM
256: --, qualifier_number_format VARCHAR2(30) := FND_API.G_MISS_CHAR
257: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
258: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
259: , request_id NUMBER := FND_API.G_MISS_NUM
260: , start_date_active DATE := FND_API.G_MISS_DATE
261: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
254: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
255: , qualifier_id NUMBER := FND_API.G_MISS_NUM
256: --, qualifier_number_format VARCHAR2(30) := FND_API.G_MISS_CHAR
257: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
258: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
259: , request_id NUMBER := FND_API.G_MISS_NUM
260: , start_date_active DATE := FND_API.G_MISS_DATE
261: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
262: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
255: , qualifier_id NUMBER := FND_API.G_MISS_NUM
256: --, qualifier_number_format VARCHAR2(30) := FND_API.G_MISS_CHAR
257: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
258: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
259: , request_id NUMBER := FND_API.G_MISS_NUM
260: , start_date_active DATE := FND_API.G_MISS_DATE
261: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
262: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
263: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
256: --, qualifier_number_format VARCHAR2(30) := FND_API.G_MISS_CHAR
257: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
258: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
259: , request_id NUMBER := FND_API.G_MISS_NUM
260: , start_date_active DATE := FND_API.G_MISS_DATE
261: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
262: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
263: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
264: );
257: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
258: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
259: , request_id NUMBER := FND_API.G_MISS_NUM
260: , start_date_active DATE := FND_API.G_MISS_DATE
261: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
262: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
263: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
264: );
265:
258: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
259: , request_id NUMBER := FND_API.G_MISS_NUM
260: , start_date_active DATE := FND_API.G_MISS_DATE
261: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
262: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
263: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
264: );
265:
266: TYPE Qualifiers_Tbl_Type IS TABLE OF Qualifiers_Rec_Type
259: , request_id NUMBER := FND_API.G_MISS_NUM
260: , start_date_active DATE := FND_API.G_MISS_DATE
261: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
262: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
263: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
264: );
265:
266: TYPE Qualifiers_Tbl_Type IS TABLE OF Qualifiers_Rec_Type
267: INDEX BY BINARY_INTEGER;
269: -- Qualifiers value record type
270:
271:
272: TYPE Qualifiers_Val_Rec_Type IS RECORD
273: ( created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
274: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
275: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
276: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
277: );
270:
271:
272: TYPE Qualifiers_Val_Rec_Type IS RECORD
273: ( created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
274: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
275: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
276: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
277: );
278:
271:
272: TYPE Qualifiers_Val_Rec_Type IS RECORD
273: ( created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
274: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
275: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
276: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
277: );
278:
279: TYPE Qualifiers_Val_Tbl_Type IS TABLE OF Qualifiers_Val_Rec_Type
272: TYPE Qualifiers_Val_Rec_Type IS RECORD
273: ( created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
274: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
275: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
276: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
277: );
278:
279: TYPE Qualifiers_Val_Tbl_Type IS TABLE OF Qualifiers_Val_Rec_Type
280: INDEX BY BINARY_INTEGER;
282:
283: -- Pricing_Attr record type
284:
285: TYPE Pricing_Attr_Rec_Type IS RECORD
286: ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
287: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
288: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
289: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
290: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
283: -- Pricing_Attr record type
284:
285: TYPE Pricing_Attr_Rec_Type IS RECORD
286: ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
287: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
288: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
289: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
290: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
291: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
284:
285: TYPE Pricing_Attr_Rec_Type IS RECORD
286: ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
287: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
288: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
289: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
290: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
291: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
292: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
285: TYPE Pricing_Attr_Rec_Type IS RECORD
286: ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
287: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
288: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
289: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
290: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
291: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
292: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
293: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
286: ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
287: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
288: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
289: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
290: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
291: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
292: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
293: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
294: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
287: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
288: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
289: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
290: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
291: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
292: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
293: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
294: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
295: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
288: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
289: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
290: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
291: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
292: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
293: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
294: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
295: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
296: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
289: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
290: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
291: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
292: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
293: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
294: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
295: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
296: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
297: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
290: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
291: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
292: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
293: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
294: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
295: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
296: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
297: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
298: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
291: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
292: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
293: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
294: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
295: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
296: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
297: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
298: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
299: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
292: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
293: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
294: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
295: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
296: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
297: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
298: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
299: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
293: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
294: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
295: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
296: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
297: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
298: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
299: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
301: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
294: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
295: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
296: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
297: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
298: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
299: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
301: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
302: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
295: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
296: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
297: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
298: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
299: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
301: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
302: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
303: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
296: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
297: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
298: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
299: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
301: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
302: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
303: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
304: , created_by NUMBER := FND_API.G_MISS_NUM
297: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
298: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
299: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
301: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
302: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
303: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
304: , created_by NUMBER := FND_API.G_MISS_NUM
305: , creation_date DATE := FND_API.G_MISS_DATE
298: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
299: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
301: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
302: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
303: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
304: , created_by NUMBER := FND_API.G_MISS_NUM
305: , creation_date DATE := FND_API.G_MISS_DATE
306: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
299: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
301: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
302: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
303: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
304: , created_by NUMBER := FND_API.G_MISS_NUM
305: , creation_date DATE := FND_API.G_MISS_DATE
306: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
307: , last_updated_by NUMBER := FND_API.G_MISS_NUM
300: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
301: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
302: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
303: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
304: , created_by NUMBER := FND_API.G_MISS_NUM
305: , creation_date DATE := FND_API.G_MISS_DATE
306: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
307: , last_updated_by NUMBER := FND_API.G_MISS_NUM
308: , last_update_date DATE := FND_API.G_MISS_DATE
301: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
302: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
303: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
304: , created_by NUMBER := FND_API.G_MISS_NUM
305: , creation_date DATE := FND_API.G_MISS_DATE
306: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
307: , last_updated_by NUMBER := FND_API.G_MISS_NUM
308: , last_update_date DATE := FND_API.G_MISS_DATE
309: , last_update_login NUMBER := FND_API.G_MISS_NUM
302: , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
303: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
304: , created_by NUMBER := FND_API.G_MISS_NUM
305: , creation_date DATE := FND_API.G_MISS_DATE
306: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
307: , last_updated_by NUMBER := FND_API.G_MISS_NUM
308: , last_update_date DATE := FND_API.G_MISS_DATE
309: , last_update_login NUMBER := FND_API.G_MISS_NUM
310: , list_line_id NUMBER := FND_API.G_MISS_NUM
303: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
304: , created_by NUMBER := FND_API.G_MISS_NUM
305: , creation_date DATE := FND_API.G_MISS_DATE
306: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
307: , last_updated_by NUMBER := FND_API.G_MISS_NUM
308: , last_update_date DATE := FND_API.G_MISS_DATE
309: , last_update_login NUMBER := FND_API.G_MISS_NUM
310: , list_line_id NUMBER := FND_API.G_MISS_NUM
311: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
304: , created_by NUMBER := FND_API.G_MISS_NUM
305: , creation_date DATE := FND_API.G_MISS_DATE
306: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
307: , last_updated_by NUMBER := FND_API.G_MISS_NUM
308: , last_update_date DATE := FND_API.G_MISS_DATE
309: , last_update_login NUMBER := FND_API.G_MISS_NUM
310: , list_line_id NUMBER := FND_API.G_MISS_NUM
311: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
312: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
305: , creation_date DATE := FND_API.G_MISS_DATE
306: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
307: , last_updated_by NUMBER := FND_API.G_MISS_NUM
308: , last_update_date DATE := FND_API.G_MISS_DATE
309: , last_update_login NUMBER := FND_API.G_MISS_NUM
310: , list_line_id NUMBER := FND_API.G_MISS_NUM
311: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
312: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
313: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
306: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
307: , last_updated_by NUMBER := FND_API.G_MISS_NUM
308: , last_update_date DATE := FND_API.G_MISS_DATE
309: , last_update_login NUMBER := FND_API.G_MISS_NUM
310: , list_line_id NUMBER := FND_API.G_MISS_NUM
311: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
312: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
313: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
314: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
307: , last_updated_by NUMBER := FND_API.G_MISS_NUM
308: , last_update_date DATE := FND_API.G_MISS_DATE
309: , last_update_login NUMBER := FND_API.G_MISS_NUM
310: , list_line_id NUMBER := FND_API.G_MISS_NUM
311: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
312: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
313: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
314: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
315: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
308: , last_update_date DATE := FND_API.G_MISS_DATE
309: , last_update_login NUMBER := FND_API.G_MISS_NUM
310: , list_line_id NUMBER := FND_API.G_MISS_NUM
311: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
312: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
313: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
314: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
315: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
316: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
309: , last_update_login NUMBER := FND_API.G_MISS_NUM
310: , list_line_id NUMBER := FND_API.G_MISS_NUM
311: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
312: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
313: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
314: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
315: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
316: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
317: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
310: , list_line_id NUMBER := FND_API.G_MISS_NUM
311: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
312: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
313: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
314: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
315: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
316: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
317: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
318: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
311: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
312: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
313: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
314: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
315: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
316: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
317: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
318: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
319: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
312: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
313: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
314: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
315: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
316: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
317: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
318: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
319: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
320: , program_application_id NUMBER := FND_API.G_MISS_NUM
313: , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
314: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
315: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
316: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
317: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
318: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
319: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
320: , program_application_id NUMBER := FND_API.G_MISS_NUM
321: , program_id NUMBER := FND_API.G_MISS_NUM
314: , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
315: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
316: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
317: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
318: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
319: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
320: , program_application_id NUMBER := FND_API.G_MISS_NUM
321: , program_id NUMBER := FND_API.G_MISS_NUM
322: , program_update_date DATE := FND_API.G_MISS_DATE
315: , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
316: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
317: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
318: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
319: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
320: , program_application_id NUMBER := FND_API.G_MISS_NUM
321: , program_id NUMBER := FND_API.G_MISS_NUM
322: , program_update_date DATE := FND_API.G_MISS_DATE
323: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
316: , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
317: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
318: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
319: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
320: , program_application_id NUMBER := FND_API.G_MISS_NUM
321: , program_id NUMBER := FND_API.G_MISS_NUM
322: , program_update_date DATE := FND_API.G_MISS_DATE
323: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
324: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
317: , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
318: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
319: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
320: , program_application_id NUMBER := FND_API.G_MISS_NUM
321: , program_id NUMBER := FND_API.G_MISS_NUM
322: , program_update_date DATE := FND_API.G_MISS_DATE
323: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
324: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
325: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
318: , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
319: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
320: , program_application_id NUMBER := FND_API.G_MISS_NUM
321: , program_id NUMBER := FND_API.G_MISS_NUM
322: , program_update_date DATE := FND_API.G_MISS_DATE
323: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
324: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
325: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
326: , request_id NUMBER := FND_API.G_MISS_NUM
319: , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
320: , program_application_id NUMBER := FND_API.G_MISS_NUM
321: , program_id NUMBER := FND_API.G_MISS_NUM
322: , program_update_date DATE := FND_API.G_MISS_DATE
323: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
324: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
325: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
326: , request_id NUMBER := FND_API.G_MISS_NUM
327: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
320: , program_application_id NUMBER := FND_API.G_MISS_NUM
321: , program_id NUMBER := FND_API.G_MISS_NUM
322: , program_update_date DATE := FND_API.G_MISS_DATE
323: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
324: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
325: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
326: , request_id NUMBER := FND_API.G_MISS_NUM
327: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
328: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
321: , program_id NUMBER := FND_API.G_MISS_NUM
322: , program_update_date DATE := FND_API.G_MISS_DATE
323: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
324: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
325: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
326: , request_id NUMBER := FND_API.G_MISS_NUM
327: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
328: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
329: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
322: , program_update_date DATE := FND_API.G_MISS_DATE
323: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
324: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
325: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
326: , request_id NUMBER := FND_API.G_MISS_NUM
327: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
328: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
329: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
330: , MODIFIERS_index NUMBER := FND_API.G_MISS_NUM
323: , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
324: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
325: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
326: , request_id NUMBER := FND_API.G_MISS_NUM
327: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
328: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
329: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
330: , MODIFIERS_index NUMBER := FND_API.G_MISS_NUM
331: );
324: , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
325: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
326: , request_id NUMBER := FND_API.G_MISS_NUM
327: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
328: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
329: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
330: , MODIFIERS_index NUMBER := FND_API.G_MISS_NUM
331: );
332:
325: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
326: , request_id NUMBER := FND_API.G_MISS_NUM
327: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
328: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
329: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
330: , MODIFIERS_index NUMBER := FND_API.G_MISS_NUM
331: );
332:
333: TYPE Pricing_Attr_Tbl_Type IS TABLE OF Pricing_Attr_Rec_Type
326: , request_id NUMBER := FND_API.G_MISS_NUM
327: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
328: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
329: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
330: , MODIFIERS_index NUMBER := FND_API.G_MISS_NUM
331: );
332:
333: TYPE Pricing_Attr_Tbl_Type IS TABLE OF Pricing_Attr_Rec_Type
334: INDEX BY BINARY_INTEGER;
335:
336: -- Pricing_Attr value record type
337:
338: TYPE Pricing_Attr_Val_Rec_Type IS RECORD
339: ( accumulate VARCHAR2(240) := FND_API.G_MISS_CHAR
340: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
341: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
342: , pricing_attribute VARCHAR2(240) := FND_API.G_MISS_CHAR
343: , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
336: -- Pricing_Attr value record type
337:
338: TYPE Pricing_Attr_Val_Rec_Type IS RECORD
339: ( accumulate VARCHAR2(240) := FND_API.G_MISS_CHAR
340: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
341: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
342: , pricing_attribute VARCHAR2(240) := FND_API.G_MISS_CHAR
343: , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
344: );
337:
338: TYPE Pricing_Attr_Val_Rec_Type IS RECORD
339: ( accumulate VARCHAR2(240) := FND_API.G_MISS_CHAR
340: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
341: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
342: , pricing_attribute VARCHAR2(240) := FND_API.G_MISS_CHAR
343: , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
344: );
345:
338: TYPE Pricing_Attr_Val_Rec_Type IS RECORD
339: ( accumulate VARCHAR2(240) := FND_API.G_MISS_CHAR
340: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
341: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
342: , pricing_attribute VARCHAR2(240) := FND_API.G_MISS_CHAR
343: , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
344: );
345:
346: TYPE Pricing_Attr_Val_Tbl_Type IS TABLE OF Pricing_Attr_Val_Rec_Type
339: ( accumulate VARCHAR2(240) := FND_API.G_MISS_CHAR
340: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
341: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
342: , pricing_attribute VARCHAR2(240) := FND_API.G_MISS_CHAR
343: , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
344: );
345:
346: TYPE Pricing_Attr_Val_Tbl_Type IS TABLE OF Pricing_Attr_Val_Rec_Type
347: INDEX BY BINARY_INTEGER;
383: -- End of Comments
384:
385: PROCEDURE Process_Modifiers
386: ( p_api_version_number IN NUMBER
387: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
388: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
389: , p_commit IN VARCHAR2 := FND_API.G_FALSE
390: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
391: QP_GLOBALS.G_MISS_CONTROL_REC
384:
385: PROCEDURE Process_Modifiers
386: ( p_api_version_number IN NUMBER
387: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
388: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
389: , p_commit IN VARCHAR2 := FND_API.G_FALSE
390: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
391: QP_GLOBALS.G_MISS_CONTROL_REC
392: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
385: PROCEDURE Process_Modifiers
386: ( p_api_version_number IN NUMBER
387: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
388: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
389: , p_commit IN VARCHAR2 := FND_API.G_FALSE
390: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
391: QP_GLOBALS.G_MISS_CONTROL_REC
392: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
393: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
435: -- End of Comments
436:
437: PROCEDURE Lock_Modifiers
438: ( p_api_version_number IN NUMBER
439: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
440: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
441: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
442: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
443: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
436:
437: PROCEDURE Lock_Modifiers
438: ( p_api_version_number IN NUMBER
439: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
440: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
441: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
442: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
443: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
444: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type :=
484: -- End of Comments
485:
486: PROCEDURE Get_Modifiers
487: ( p_api_version_number IN NUMBER
488: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
489: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
490: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
491: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
492: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
485:
486: PROCEDURE Get_Modifiers
487: ( p_api_version_number IN NUMBER
488: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
489: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
490: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
491: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
492: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
493: , p_list_header_id IN NUMBER :=
490: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
491: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
492: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
493: , p_list_header_id IN NUMBER :=
494: FND_API.G_MISS_NUM
495: , p_list_header IN VARCHAR2 :=
496: FND_API.G_MISS_CHAR
497: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
498: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
492: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
493: , p_list_header_id IN NUMBER :=
494: FND_API.G_MISS_NUM
495: , p_list_header IN VARCHAR2 :=
496: FND_API.G_MISS_CHAR
497: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
498: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
499: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
500: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type