8: -- Parameters :
9: -- IN :
10: -- p_api_version NUMBER Required
11: -- p_init_msg_list VARCHAR2 Optional
12: -- Default = FND_API.G_FALSE
13: -- p_commit VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_validation_level NUMBER Optional
16: -- Default = FND_API.G_VALID_LEVEL_FULL
10: -- p_api_version NUMBER Required
11: -- p_init_msg_list VARCHAR2 Optional
12: -- Default = FND_API.G_FALSE
13: -- p_commit VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_validation_level NUMBER Optional
16: -- Default = FND_API.G_VALID_LEVEL_FULL
17: -- p_operation_rec OPERATION_REC_TYPE Optional
18: -- Default = G_MISS_OPERATION_REC
12: -- Default = FND_API.G_FALSE
13: -- p_commit VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_validation_level NUMBER Optional
16: -- Default = FND_API.G_VALID_LEVEL_FULL
17: -- p_operation_rec OPERATION_REC_TYPE Optional
18: -- Default = G_MISS_OPERATION_REC
19: --
20: -- OUT :
35: -- Parameters :
36: -- IN :
37: -- p_api_version NUMBER Required
38: -- p_init_msg_list VARCHAR2 Optional
39: -- Default = FND_API.G_FALSE
40: -- p_commit VARCHAR2 Optional
41: -- Default = FND_API.G_FALSE
42: -- p_validation_level NUMBER Optional
43: -- Default = FND_API.G_VALID_LEVEL_FULL
37: -- p_api_version NUMBER Required
38: -- p_init_msg_list VARCHAR2 Optional
39: -- Default = FND_API.G_FALSE
40: -- p_commit VARCHAR2 Optional
41: -- Default = FND_API.G_FALSE
42: -- p_validation_level NUMBER Optional
43: -- Default = FND_API.G_VALID_LEVEL_FULL
44: -- p_operation_rec OPERATION_REC_TYPE Optional
45: -- Default = G_MISS_OPERATION_REC
39: -- Default = FND_API.G_FALSE
40: -- p_commit VARCHAR2 Optional
41: -- Default = FND_API.G_FALSE
42: -- p_validation_level NUMBER Optional
43: -- Default = FND_API.G_VALID_LEVEL_FULL
44: -- p_operation_rec OPERATION_REC_TYPE Optional
45: -- Default = G_MISS_OPERATION_REC
46: --
47: -- OUT :
62: -- Parameters :
63: -- IN :
64: -- p_api_version NUMBER Required
65: -- p_init_msg_list VARCHAR2 Optional
66: -- Default = FND_API.G_FALSE
67: -- p_commit VARCHAR2 Optional
68: -- Default = FND_API.G_FALSE
69: -- p_validation_level NUMBER Optional
70: -- Default = FND_API.G_VALID_LEVEL_FULL
64: -- p_api_version NUMBER Required
65: -- p_init_msg_list VARCHAR2 Optional
66: -- Default = FND_API.G_FALSE
67: -- p_commit VARCHAR2 Optional
68: -- Default = FND_API.G_FALSE
69: -- p_validation_level NUMBER Optional
70: -- Default = FND_API.G_VALID_LEVEL_FULL
71: -- p_operation_rec OPERATION_REC_TYPE Optional
72: -- Default = G_MISS_OPERATION_REC
66: -- Default = FND_API.G_FALSE
67: -- p_commit VARCHAR2 Optional
68: -- Default = FND_API.G_FALSE
69: -- p_validation_level NUMBER Optional
70: -- Default = FND_API.G_VALID_LEVEL_FULL
71: -- p_operation_rec OPERATION_REC_TYPE Optional
72: -- Default = G_MISS_OPERATION_REC
73: --
74: -- OUT :
89: -- Parameters :
90: -- IN :
91: -- p_api_version NUMBER Required
92: -- p_init_msg_list VARCHAR2 Optional
93: -- Default = FND_API.G_FALSE
94: -- p_commit VARCHAR2 Optional
95: -- Default = FND_API.G_FALSE
96: -- p_validation_level NUMBER Optional
97: -- Default = FND_API.G_VALID_LEVEL_FULL
91: -- p_api_version NUMBER Required
92: -- p_init_msg_list VARCHAR2 Optional
93: -- Default = FND_API.G_FALSE
94: -- p_commit VARCHAR2 Optional
95: -- Default = FND_API.G_FALSE
96: -- p_validation_level NUMBER Optional
97: -- Default = FND_API.G_VALID_LEVEL_FULL
98: -- p_operation_rec OPERATION_REC_TYPE Optional
99: -- Default = G_MISS_OPERATION_REC
93: -- Default = FND_API.G_FALSE
94: -- p_commit VARCHAR2 Optional
95: -- Default = FND_API.G_FALSE
96: -- p_validation_level NUMBER Optional
97: -- Default = FND_API.G_VALID_LEVEL_FULL
98: -- p_operation_rec OPERATION_REC_TYPE Optional
99: -- Default = G_MISS_OPERATION_REC
100: --
101: -- OUT :
116: -- Parameters :
117: -- IN :
118: -- p_api_version NUMBER Required
119: -- p_init_msg_list VARCHAR2 Optional
120: -- Default = FND_API.G_FALSE
121: -- p_commit VARCHAR2 Optional
122: -- Default = FND_API.G_FALSE
123: -- p_validation_level NUMBER Optional
124: -- Default = FND_API.G_VALID_LEVEL_FULL
118: -- p_api_version NUMBER Required
119: -- p_init_msg_list VARCHAR2 Optional
120: -- Default = FND_API.G_FALSE
121: -- p_commit VARCHAR2 Optional
122: -- Default = FND_API.G_FALSE
123: -- p_validation_level NUMBER Optional
124: -- Default = FND_API.G_VALID_LEVEL_FULL
125: -- p_delete_group VARCHAR2
126: -- p_description VARCHAR2 Default = Null
120: -- Default = FND_API.G_FALSE
121: -- p_commit VARCHAR2 Optional
122: -- Default = FND_API.G_FALSE
123: -- p_validation_level NUMBER Optional
124: -- Default = FND_API.G_VALID_LEVEL_FULL
125: -- p_delete_group VARCHAR2
126: -- p_description VARCHAR2 Default = Null
127: -- p_operation_rec OPERATION_REC_TYPE Optional
128: -- Default = G_MISS_OPERATION_REC
139: -- Notes : Full validation includes assign
140: --
141: -- End of comments
142: TYPE operation_rec_type is record(
143: operation_sequence_id number := Fnd_Api.G_Miss_Num,
144: routing_sequence_id number := Fnd_Api.G_Miss_Num,
145: assembly_item_id number := Fnd_Api.G_Miss_Num,
146: assembly_item_number varchar2(81) := Fnd_Api.G_Miss_Char,
147: organization_id number := Fnd_Api.G_Miss_Num,
140: --
141: -- End of comments
142: TYPE operation_rec_type is record(
143: operation_sequence_id number := Fnd_Api.G_Miss_Num,
144: routing_sequence_id number := Fnd_Api.G_Miss_Num,
145: assembly_item_id number := Fnd_Api.G_Miss_Num,
146: assembly_item_number varchar2(81) := Fnd_Api.G_Miss_Char,
147: organization_id number := Fnd_Api.G_Miss_Num,
148: organization_code varchar2(3) := Fnd_Api.G_Miss_Char,
141: -- End of comments
142: TYPE operation_rec_type is record(
143: operation_sequence_id number := Fnd_Api.G_Miss_Num,
144: routing_sequence_id number := Fnd_Api.G_Miss_Num,
145: assembly_item_id number := Fnd_Api.G_Miss_Num,
146: assembly_item_number varchar2(81) := Fnd_Api.G_Miss_Char,
147: organization_id number := Fnd_Api.G_Miss_Num,
148: organization_code varchar2(3) := Fnd_Api.G_Miss_Char,
149: alternate_routing_designator varchar2(10) := Fnd_Api.G_Miss_Char,
142: TYPE operation_rec_type is record(
143: operation_sequence_id number := Fnd_Api.G_Miss_Num,
144: routing_sequence_id number := Fnd_Api.G_Miss_Num,
145: assembly_item_id number := Fnd_Api.G_Miss_Num,
146: assembly_item_number varchar2(81) := Fnd_Api.G_Miss_Char,
147: organization_id number := Fnd_Api.G_Miss_Num,
148: organization_code varchar2(3) := Fnd_Api.G_Miss_Char,
149: alternate_routing_designator varchar2(10) := Fnd_Api.G_Miss_Char,
150: operation_seq_num number := Fnd_Api.G_Miss_Num,
143: operation_sequence_id number := Fnd_Api.G_Miss_Num,
144: routing_sequence_id number := Fnd_Api.G_Miss_Num,
145: assembly_item_id number := Fnd_Api.G_Miss_Num,
146: assembly_item_number varchar2(81) := Fnd_Api.G_Miss_Char,
147: organization_id number := Fnd_Api.G_Miss_Num,
148: organization_code varchar2(3) := Fnd_Api.G_Miss_Char,
149: alternate_routing_designator varchar2(10) := Fnd_Api.G_Miss_Char,
150: operation_seq_num number := Fnd_Api.G_Miss_Num,
151: new_operation_seq_num number := Fnd_Api.G_Miss_Num,
144: routing_sequence_id number := Fnd_Api.G_Miss_Num,
145: assembly_item_id number := Fnd_Api.G_Miss_Num,
146: assembly_item_number varchar2(81) := Fnd_Api.G_Miss_Char,
147: organization_id number := Fnd_Api.G_Miss_Num,
148: organization_code varchar2(3) := Fnd_Api.G_Miss_Char,
149: alternate_routing_designator varchar2(10) := Fnd_Api.G_Miss_Char,
150: operation_seq_num number := Fnd_Api.G_Miss_Num,
151: new_operation_seq_num number := Fnd_Api.G_Miss_Num,
152: standard_operation_id number := Fnd_Api.G_Miss_Num,
145: assembly_item_id number := Fnd_Api.G_Miss_Num,
146: assembly_item_number varchar2(81) := Fnd_Api.G_Miss_Char,
147: organization_id number := Fnd_Api.G_Miss_Num,
148: organization_code varchar2(3) := Fnd_Api.G_Miss_Char,
149: alternate_routing_designator varchar2(10) := Fnd_Api.G_Miss_Char,
150: operation_seq_num number := Fnd_Api.G_Miss_Num,
151: new_operation_seq_num number := Fnd_Api.G_Miss_Num,
152: standard_operation_id number := Fnd_Api.G_Miss_Num,
153: operation_code varchar2(4) := Fnd_Api.G_Miss_Char,
146: assembly_item_number varchar2(81) := Fnd_Api.G_Miss_Char,
147: organization_id number := Fnd_Api.G_Miss_Num,
148: organization_code varchar2(3) := Fnd_Api.G_Miss_Char,
149: alternate_routing_designator varchar2(10) := Fnd_Api.G_Miss_Char,
150: operation_seq_num number := Fnd_Api.G_Miss_Num,
151: new_operation_seq_num number := Fnd_Api.G_Miss_Num,
152: standard_operation_id number := Fnd_Api.G_Miss_Num,
153: operation_code varchar2(4) := Fnd_Api.G_Miss_Char,
154: department_id number := Fnd_Api.G_Miss_Num,
147: organization_id number := Fnd_Api.G_Miss_Num,
148: organization_code varchar2(3) := Fnd_Api.G_Miss_Char,
149: alternate_routing_designator varchar2(10) := Fnd_Api.G_Miss_Char,
150: operation_seq_num number := Fnd_Api.G_Miss_Num,
151: new_operation_seq_num number := Fnd_Api.G_Miss_Num,
152: standard_operation_id number := Fnd_Api.G_Miss_Num,
153: operation_code varchar2(4) := Fnd_Api.G_Miss_Char,
154: department_id number := Fnd_Api.G_Miss_Num,
155: department_code varchar2(10) := Fnd_Api.G_Miss_Char,
148: organization_code varchar2(3) := Fnd_Api.G_Miss_Char,
149: alternate_routing_designator varchar2(10) := Fnd_Api.G_Miss_Char,
150: operation_seq_num number := Fnd_Api.G_Miss_Num,
151: new_operation_seq_num number := Fnd_Api.G_Miss_Num,
152: standard_operation_id number := Fnd_Api.G_Miss_Num,
153: operation_code varchar2(4) := Fnd_Api.G_Miss_Char,
154: department_id number := Fnd_Api.G_Miss_Num,
155: department_code varchar2(10) := Fnd_Api.G_Miss_Char,
156: operation_lead_time_percent number := Fnd_Api.G_Miss_Num,
149: alternate_routing_designator varchar2(10) := Fnd_Api.G_Miss_Char,
150: operation_seq_num number := Fnd_Api.G_Miss_Num,
151: new_operation_seq_num number := Fnd_Api.G_Miss_Num,
152: standard_operation_id number := Fnd_Api.G_Miss_Num,
153: operation_code varchar2(4) := Fnd_Api.G_Miss_Char,
154: department_id number := Fnd_Api.G_Miss_Num,
155: department_code varchar2(10) := Fnd_Api.G_Miss_Char,
156: operation_lead_time_percent number := Fnd_Api.G_Miss_Num,
157: minimum_transfer_quantity number := Fnd_Api.G_Miss_Num,
150: operation_seq_num number := Fnd_Api.G_Miss_Num,
151: new_operation_seq_num number := Fnd_Api.G_Miss_Num,
152: standard_operation_id number := Fnd_Api.G_Miss_Num,
153: operation_code varchar2(4) := Fnd_Api.G_Miss_Char,
154: department_id number := Fnd_Api.G_Miss_Num,
155: department_code varchar2(10) := Fnd_Api.G_Miss_Char,
156: operation_lead_time_percent number := Fnd_Api.G_Miss_Num,
157: minimum_transfer_quantity number := Fnd_Api.G_Miss_Num,
158: count_point_type number := Fnd_Api.G_Miss_Num,
151: new_operation_seq_num number := Fnd_Api.G_Miss_Num,
152: standard_operation_id number := Fnd_Api.G_Miss_Num,
153: operation_code varchar2(4) := Fnd_Api.G_Miss_Char,
154: department_id number := Fnd_Api.G_Miss_Num,
155: department_code varchar2(10) := Fnd_Api.G_Miss_Char,
156: operation_lead_time_percent number := Fnd_Api.G_Miss_Num,
157: minimum_transfer_quantity number := Fnd_Api.G_Miss_Num,
158: count_point_type number := Fnd_Api.G_Miss_Num,
159: operation_description varchar2(240) := Fnd_Api.G_Miss_Char,
152: standard_operation_id number := Fnd_Api.G_Miss_Num,
153: operation_code varchar2(4) := Fnd_Api.G_Miss_Char,
154: department_id number := Fnd_Api.G_Miss_Num,
155: department_code varchar2(10) := Fnd_Api.G_Miss_Char,
156: operation_lead_time_percent number := Fnd_Api.G_Miss_Num,
157: minimum_transfer_quantity number := Fnd_Api.G_Miss_Num,
158: count_point_type number := Fnd_Api.G_Miss_Num,
159: operation_description varchar2(240) := Fnd_Api.G_Miss_Char,
160: effectivity_date date := Fnd_Api.G_Miss_Date,
153: operation_code varchar2(4) := Fnd_Api.G_Miss_Char,
154: department_id number := Fnd_Api.G_Miss_Num,
155: department_code varchar2(10) := Fnd_Api.G_Miss_Char,
156: operation_lead_time_percent number := Fnd_Api.G_Miss_Num,
157: minimum_transfer_quantity number := Fnd_Api.G_Miss_Num,
158: count_point_type number := Fnd_Api.G_Miss_Num,
159: operation_description varchar2(240) := Fnd_Api.G_Miss_Char,
160: effectivity_date date := Fnd_Api.G_Miss_Date,
161: new_effectivity_date date := Fnd_Api.G_Miss_Date,
154: department_id number := Fnd_Api.G_Miss_Num,
155: department_code varchar2(10) := Fnd_Api.G_Miss_Char,
156: operation_lead_time_percent number := Fnd_Api.G_Miss_Num,
157: minimum_transfer_quantity number := Fnd_Api.G_Miss_Num,
158: count_point_type number := Fnd_Api.G_Miss_Num,
159: operation_description varchar2(240) := Fnd_Api.G_Miss_Char,
160: effectivity_date date := Fnd_Api.G_Miss_Date,
161: new_effectivity_date date := Fnd_Api.G_Miss_Date,
162: disable_date date := Fnd_Api.G_Miss_Date,
155: department_code varchar2(10) := Fnd_Api.G_Miss_Char,
156: operation_lead_time_percent number := Fnd_Api.G_Miss_Num,
157: minimum_transfer_quantity number := Fnd_Api.G_Miss_Num,
158: count_point_type number := Fnd_Api.G_Miss_Num,
159: operation_description varchar2(240) := Fnd_Api.G_Miss_Char,
160: effectivity_date date := Fnd_Api.G_Miss_Date,
161: new_effectivity_date date := Fnd_Api.G_Miss_Date,
162: disable_date date := Fnd_Api.G_Miss_Date,
163: backflush_flag number := Fnd_Api.G_Miss_Num,
156: operation_lead_time_percent number := Fnd_Api.G_Miss_Num,
157: minimum_transfer_quantity number := Fnd_Api.G_Miss_Num,
158: count_point_type number := Fnd_Api.G_Miss_Num,
159: operation_description varchar2(240) := Fnd_Api.G_Miss_Char,
160: effectivity_date date := Fnd_Api.G_Miss_Date,
161: new_effectivity_date date := Fnd_Api.G_Miss_Date,
162: disable_date date := Fnd_Api.G_Miss_Date,
163: backflush_flag number := Fnd_Api.G_Miss_Num,
164: option_dependent_flag number := Fnd_Api.G_Miss_Num,
157: minimum_transfer_quantity number := Fnd_Api.G_Miss_Num,
158: count_point_type number := Fnd_Api.G_Miss_Num,
159: operation_description varchar2(240) := Fnd_Api.G_Miss_Char,
160: effectivity_date date := Fnd_Api.G_Miss_Date,
161: new_effectivity_date date := Fnd_Api.G_Miss_Date,
162: disable_date date := Fnd_Api.G_Miss_Date,
163: backflush_flag number := Fnd_Api.G_Miss_Num,
164: option_dependent_flag number := Fnd_Api.G_Miss_Num,
165: attribute_category varchar2(30) := Fnd_Api.G_Miss_Char,
158: count_point_type number := Fnd_Api.G_Miss_Num,
159: operation_description varchar2(240) := Fnd_Api.G_Miss_Char,
160: effectivity_date date := Fnd_Api.G_Miss_Date,
161: new_effectivity_date date := Fnd_Api.G_Miss_Date,
162: disable_date date := Fnd_Api.G_Miss_Date,
163: backflush_flag number := Fnd_Api.G_Miss_Num,
164: option_dependent_flag number := Fnd_Api.G_Miss_Num,
165: attribute_category varchar2(30) := Fnd_Api.G_Miss_Char,
166: attribute1 varchar2(150) := Fnd_Api.G_Miss_Char,
159: operation_description varchar2(240) := Fnd_Api.G_Miss_Char,
160: effectivity_date date := Fnd_Api.G_Miss_Date,
161: new_effectivity_date date := Fnd_Api.G_Miss_Date,
162: disable_date date := Fnd_Api.G_Miss_Date,
163: backflush_flag number := Fnd_Api.G_Miss_Num,
164: option_dependent_flag number := Fnd_Api.G_Miss_Num,
165: attribute_category varchar2(30) := Fnd_Api.G_Miss_Char,
166: attribute1 varchar2(150) := Fnd_Api.G_Miss_Char,
167: attribute2 varchar2(150) := Fnd_Api.G_Miss_Char,
160: effectivity_date date := Fnd_Api.G_Miss_Date,
161: new_effectivity_date date := Fnd_Api.G_Miss_Date,
162: disable_date date := Fnd_Api.G_Miss_Date,
163: backflush_flag number := Fnd_Api.G_Miss_Num,
164: option_dependent_flag number := Fnd_Api.G_Miss_Num,
165: attribute_category varchar2(30) := Fnd_Api.G_Miss_Char,
166: attribute1 varchar2(150) := Fnd_Api.G_Miss_Char,
167: attribute2 varchar2(150) := Fnd_Api.G_Miss_Char,
168: attribute3 varchar2(150) := Fnd_Api.G_Miss_Char,
161: new_effectivity_date date := Fnd_Api.G_Miss_Date,
162: disable_date date := Fnd_Api.G_Miss_Date,
163: backflush_flag number := Fnd_Api.G_Miss_Num,
164: option_dependent_flag number := Fnd_Api.G_Miss_Num,
165: attribute_category varchar2(30) := Fnd_Api.G_Miss_Char,
166: attribute1 varchar2(150) := Fnd_Api.G_Miss_Char,
167: attribute2 varchar2(150) := Fnd_Api.G_Miss_Char,
168: attribute3 varchar2(150) := Fnd_Api.G_Miss_Char,
169: attribute4 varchar2(150) := Fnd_Api.G_Miss_Char,
162: disable_date date := Fnd_Api.G_Miss_Date,
163: backflush_flag number := Fnd_Api.G_Miss_Num,
164: option_dependent_flag number := Fnd_Api.G_Miss_Num,
165: attribute_category varchar2(30) := Fnd_Api.G_Miss_Char,
166: attribute1 varchar2(150) := Fnd_Api.G_Miss_Char,
167: attribute2 varchar2(150) := Fnd_Api.G_Miss_Char,
168: attribute3 varchar2(150) := Fnd_Api.G_Miss_Char,
169: attribute4 varchar2(150) := Fnd_Api.G_Miss_Char,
170: attribute5 varchar2(150) := Fnd_Api.G_Miss_Char,
163: backflush_flag number := Fnd_Api.G_Miss_Num,
164: option_dependent_flag number := Fnd_Api.G_Miss_Num,
165: attribute_category varchar2(30) := Fnd_Api.G_Miss_Char,
166: attribute1 varchar2(150) := Fnd_Api.G_Miss_Char,
167: attribute2 varchar2(150) := Fnd_Api.G_Miss_Char,
168: attribute3 varchar2(150) := Fnd_Api.G_Miss_Char,
169: attribute4 varchar2(150) := Fnd_Api.G_Miss_Char,
170: attribute5 varchar2(150) := Fnd_Api.G_Miss_Char,
171: attribute6 varchar2(150) := Fnd_Api.G_Miss_Char,
164: option_dependent_flag number := Fnd_Api.G_Miss_Num,
165: attribute_category varchar2(30) := Fnd_Api.G_Miss_Char,
166: attribute1 varchar2(150) := Fnd_Api.G_Miss_Char,
167: attribute2 varchar2(150) := Fnd_Api.G_Miss_Char,
168: attribute3 varchar2(150) := Fnd_Api.G_Miss_Char,
169: attribute4 varchar2(150) := Fnd_Api.G_Miss_Char,
170: attribute5 varchar2(150) := Fnd_Api.G_Miss_Char,
171: attribute6 varchar2(150) := Fnd_Api.G_Miss_Char,
172: attribute7 varchar2(150) := Fnd_Api.G_Miss_Char,
165: attribute_category varchar2(30) := Fnd_Api.G_Miss_Char,
166: attribute1 varchar2(150) := Fnd_Api.G_Miss_Char,
167: attribute2 varchar2(150) := Fnd_Api.G_Miss_Char,
168: attribute3 varchar2(150) := Fnd_Api.G_Miss_Char,
169: attribute4 varchar2(150) := Fnd_Api.G_Miss_Char,
170: attribute5 varchar2(150) := Fnd_Api.G_Miss_Char,
171: attribute6 varchar2(150) := Fnd_Api.G_Miss_Char,
172: attribute7 varchar2(150) := Fnd_Api.G_Miss_Char,
173: attribute8 varchar2(150) := Fnd_Api.G_Miss_Char,
166: attribute1 varchar2(150) := Fnd_Api.G_Miss_Char,
167: attribute2 varchar2(150) := Fnd_Api.G_Miss_Char,
168: attribute3 varchar2(150) := Fnd_Api.G_Miss_Char,
169: attribute4 varchar2(150) := Fnd_Api.G_Miss_Char,
170: attribute5 varchar2(150) := Fnd_Api.G_Miss_Char,
171: attribute6 varchar2(150) := Fnd_Api.G_Miss_Char,
172: attribute7 varchar2(150) := Fnd_Api.G_Miss_Char,
173: attribute8 varchar2(150) := Fnd_Api.G_Miss_Char,
174: attribute9 varchar2(150) := Fnd_Api.G_Miss_Char,
167: attribute2 varchar2(150) := Fnd_Api.G_Miss_Char,
168: attribute3 varchar2(150) := Fnd_Api.G_Miss_Char,
169: attribute4 varchar2(150) := Fnd_Api.G_Miss_Char,
170: attribute5 varchar2(150) := Fnd_Api.G_Miss_Char,
171: attribute6 varchar2(150) := Fnd_Api.G_Miss_Char,
172: attribute7 varchar2(150) := Fnd_Api.G_Miss_Char,
173: attribute8 varchar2(150) := Fnd_Api.G_Miss_Char,
174: attribute9 varchar2(150) := Fnd_Api.G_Miss_Char,
175: attribute10 varchar2(150) := Fnd_Api.G_Miss_Char,
168: attribute3 varchar2(150) := Fnd_Api.G_Miss_Char,
169: attribute4 varchar2(150) := Fnd_Api.G_Miss_Char,
170: attribute5 varchar2(150) := Fnd_Api.G_Miss_Char,
171: attribute6 varchar2(150) := Fnd_Api.G_Miss_Char,
172: attribute7 varchar2(150) := Fnd_Api.G_Miss_Char,
173: attribute8 varchar2(150) := Fnd_Api.G_Miss_Char,
174: attribute9 varchar2(150) := Fnd_Api.G_Miss_Char,
175: attribute10 varchar2(150) := Fnd_Api.G_Miss_Char,
176: attribute11 varchar2(150) := Fnd_Api.G_Miss_Char,
169: attribute4 varchar2(150) := Fnd_Api.G_Miss_Char,
170: attribute5 varchar2(150) := Fnd_Api.G_Miss_Char,
171: attribute6 varchar2(150) := Fnd_Api.G_Miss_Char,
172: attribute7 varchar2(150) := Fnd_Api.G_Miss_Char,
173: attribute8 varchar2(150) := Fnd_Api.G_Miss_Char,
174: attribute9 varchar2(150) := Fnd_Api.G_Miss_Char,
175: attribute10 varchar2(150) := Fnd_Api.G_Miss_Char,
176: attribute11 varchar2(150) := Fnd_Api.G_Miss_Char,
177: attribute12 varchar2(150) := Fnd_Api.G_Miss_Char,
170: attribute5 varchar2(150) := Fnd_Api.G_Miss_Char,
171: attribute6 varchar2(150) := Fnd_Api.G_Miss_Char,
172: attribute7 varchar2(150) := Fnd_Api.G_Miss_Char,
173: attribute8 varchar2(150) := Fnd_Api.G_Miss_Char,
174: attribute9 varchar2(150) := Fnd_Api.G_Miss_Char,
175: attribute10 varchar2(150) := Fnd_Api.G_Miss_Char,
176: attribute11 varchar2(150) := Fnd_Api.G_Miss_Char,
177: attribute12 varchar2(150) := Fnd_Api.G_Miss_Char,
178: attribute13 varchar2(150) := Fnd_Api.G_Miss_Char,
171: attribute6 varchar2(150) := Fnd_Api.G_Miss_Char,
172: attribute7 varchar2(150) := Fnd_Api.G_Miss_Char,
173: attribute8 varchar2(150) := Fnd_Api.G_Miss_Char,
174: attribute9 varchar2(150) := Fnd_Api.G_Miss_Char,
175: attribute10 varchar2(150) := Fnd_Api.G_Miss_Char,
176: attribute11 varchar2(150) := Fnd_Api.G_Miss_Char,
177: attribute12 varchar2(150) := Fnd_Api.G_Miss_Char,
178: attribute13 varchar2(150) := Fnd_Api.G_Miss_Char,
179: attribute14 varchar2(150) := Fnd_Api.G_Miss_Char,
172: attribute7 varchar2(150) := Fnd_Api.G_Miss_Char,
173: attribute8 varchar2(150) := Fnd_Api.G_Miss_Char,
174: attribute9 varchar2(150) := Fnd_Api.G_Miss_Char,
175: attribute10 varchar2(150) := Fnd_Api.G_Miss_Char,
176: attribute11 varchar2(150) := Fnd_Api.G_Miss_Char,
177: attribute12 varchar2(150) := Fnd_Api.G_Miss_Char,
178: attribute13 varchar2(150) := Fnd_Api.G_Miss_Char,
179: attribute14 varchar2(150) := Fnd_Api.G_Miss_Char,
180: attribute15 varchar2(150) := Fnd_Api.G_Miss_Char,
173: attribute8 varchar2(150) := Fnd_Api.G_Miss_Char,
174: attribute9 varchar2(150) := Fnd_Api.G_Miss_Char,
175: attribute10 varchar2(150) := Fnd_Api.G_Miss_Char,
176: attribute11 varchar2(150) := Fnd_Api.G_Miss_Char,
177: attribute12 varchar2(150) := Fnd_Api.G_Miss_Char,
178: attribute13 varchar2(150) := Fnd_Api.G_Miss_Char,
179: attribute14 varchar2(150) := Fnd_Api.G_Miss_Char,
180: attribute15 varchar2(150) := Fnd_Api.G_Miss_Char,
181: operation_type number := Fnd_Api.G_Miss_Num,
174: attribute9 varchar2(150) := Fnd_Api.G_Miss_Char,
175: attribute10 varchar2(150) := Fnd_Api.G_Miss_Char,
176: attribute11 varchar2(150) := Fnd_Api.G_Miss_Char,
177: attribute12 varchar2(150) := Fnd_Api.G_Miss_Char,
178: attribute13 varchar2(150) := Fnd_Api.G_Miss_Char,
179: attribute14 varchar2(150) := Fnd_Api.G_Miss_Char,
180: attribute15 varchar2(150) := Fnd_Api.G_Miss_Char,
181: operation_type number := Fnd_Api.G_Miss_Num,
182: reference_flag number := Fnd_Api.G_Miss_Num,
175: attribute10 varchar2(150) := Fnd_Api.G_Miss_Char,
176: attribute11 varchar2(150) := Fnd_Api.G_Miss_Char,
177: attribute12 varchar2(150) := Fnd_Api.G_Miss_Char,
178: attribute13 varchar2(150) := Fnd_Api.G_Miss_Char,
179: attribute14 varchar2(150) := Fnd_Api.G_Miss_Char,
180: attribute15 varchar2(150) := Fnd_Api.G_Miss_Char,
181: operation_type number := Fnd_Api.G_Miss_Num,
182: reference_flag number := Fnd_Api.G_Miss_Num,
183: process_op_seq_id number := Fnd_Api.G_Miss_Num,
176: attribute11 varchar2(150) := Fnd_Api.G_Miss_Char,
177: attribute12 varchar2(150) := Fnd_Api.G_Miss_Char,
178: attribute13 varchar2(150) := Fnd_Api.G_Miss_Char,
179: attribute14 varchar2(150) := Fnd_Api.G_Miss_Char,
180: attribute15 varchar2(150) := Fnd_Api.G_Miss_Char,
181: operation_type number := Fnd_Api.G_Miss_Num,
182: reference_flag number := Fnd_Api.G_Miss_Num,
183: process_op_seq_id number := Fnd_Api.G_Miss_Num,
184: line_op_seq_id number := Fnd_Api.G_Miss_Num,
177: attribute12 varchar2(150) := Fnd_Api.G_Miss_Char,
178: attribute13 varchar2(150) := Fnd_Api.G_Miss_Char,
179: attribute14 varchar2(150) := Fnd_Api.G_Miss_Char,
180: attribute15 varchar2(150) := Fnd_Api.G_Miss_Char,
181: operation_type number := Fnd_Api.G_Miss_Num,
182: reference_flag number := Fnd_Api.G_Miss_Num,
183: process_op_seq_id number := Fnd_Api.G_Miss_Num,
184: line_op_seq_id number := Fnd_Api.G_Miss_Num,
185: yield number := Fnd_Api.G_Miss_Num,
178: attribute13 varchar2(150) := Fnd_Api.G_Miss_Char,
179: attribute14 varchar2(150) := Fnd_Api.G_Miss_Char,
180: attribute15 varchar2(150) := Fnd_Api.G_Miss_Char,
181: operation_type number := Fnd_Api.G_Miss_Num,
182: reference_flag number := Fnd_Api.G_Miss_Num,
183: process_op_seq_id number := Fnd_Api.G_Miss_Num,
184: line_op_seq_id number := Fnd_Api.G_Miss_Num,
185: yield number := Fnd_Api.G_Miss_Num,
186: cumulative_yield number := Fnd_Api.G_Miss_Num,
179: attribute14 varchar2(150) := Fnd_Api.G_Miss_Char,
180: attribute15 varchar2(150) := Fnd_Api.G_Miss_Char,
181: operation_type number := Fnd_Api.G_Miss_Num,
182: reference_flag number := Fnd_Api.G_Miss_Num,
183: process_op_seq_id number := Fnd_Api.G_Miss_Num,
184: line_op_seq_id number := Fnd_Api.G_Miss_Num,
185: yield number := Fnd_Api.G_Miss_Num,
186: cumulative_yield number := Fnd_Api.G_Miss_Num,
187: reverse_cumulative_yield number := Fnd_Api.G_Miss_Num,
180: attribute15 varchar2(150) := Fnd_Api.G_Miss_Char,
181: operation_type number := Fnd_Api.G_Miss_Num,
182: reference_flag number := Fnd_Api.G_Miss_Num,
183: process_op_seq_id number := Fnd_Api.G_Miss_Num,
184: line_op_seq_id number := Fnd_Api.G_Miss_Num,
185: yield number := Fnd_Api.G_Miss_Num,
186: cumulative_yield number := Fnd_Api.G_Miss_Num,
187: reverse_cumulative_yield number := Fnd_Api.G_Miss_Num,
188: labor_time_calc number := Fnd_Api.G_Miss_Num,
181: operation_type number := Fnd_Api.G_Miss_Num,
182: reference_flag number := Fnd_Api.G_Miss_Num,
183: process_op_seq_id number := Fnd_Api.G_Miss_Num,
184: line_op_seq_id number := Fnd_Api.G_Miss_Num,
185: yield number := Fnd_Api.G_Miss_Num,
186: cumulative_yield number := Fnd_Api.G_Miss_Num,
187: reverse_cumulative_yield number := Fnd_Api.G_Miss_Num,
188: labor_time_calc number := Fnd_Api.G_Miss_Num,
189: machine_time_calc number := Fnd_Api.G_Miss_Num,
182: reference_flag number := Fnd_Api.G_Miss_Num,
183: process_op_seq_id number := Fnd_Api.G_Miss_Num,
184: line_op_seq_id number := Fnd_Api.G_Miss_Num,
185: yield number := Fnd_Api.G_Miss_Num,
186: cumulative_yield number := Fnd_Api.G_Miss_Num,
187: reverse_cumulative_yield number := Fnd_Api.G_Miss_Num,
188: labor_time_calc number := Fnd_Api.G_Miss_Num,
189: machine_time_calc number := Fnd_Api.G_Miss_Num,
190: total_time_calc number := Fnd_Api.G_Miss_Num,
183: process_op_seq_id number := Fnd_Api.G_Miss_Num,
184: line_op_seq_id number := Fnd_Api.G_Miss_Num,
185: yield number := Fnd_Api.G_Miss_Num,
186: cumulative_yield number := Fnd_Api.G_Miss_Num,
187: reverse_cumulative_yield number := Fnd_Api.G_Miss_Num,
188: labor_time_calc number := Fnd_Api.G_Miss_Num,
189: machine_time_calc number := Fnd_Api.G_Miss_Num,
190: total_time_calc number := Fnd_Api.G_Miss_Num,
191: labor_time_user number := Fnd_Api.G_Miss_Num,
184: line_op_seq_id number := Fnd_Api.G_Miss_Num,
185: yield number := Fnd_Api.G_Miss_Num,
186: cumulative_yield number := Fnd_Api.G_Miss_Num,
187: reverse_cumulative_yield number := Fnd_Api.G_Miss_Num,
188: labor_time_calc number := Fnd_Api.G_Miss_Num,
189: machine_time_calc number := Fnd_Api.G_Miss_Num,
190: total_time_calc number := Fnd_Api.G_Miss_Num,
191: labor_time_user number := Fnd_Api.G_Miss_Num,
192: machine_time_user number := Fnd_Api.G_Miss_Num,
185: yield number := Fnd_Api.G_Miss_Num,
186: cumulative_yield number := Fnd_Api.G_Miss_Num,
187: reverse_cumulative_yield number := Fnd_Api.G_Miss_Num,
188: labor_time_calc number := Fnd_Api.G_Miss_Num,
189: machine_time_calc number := Fnd_Api.G_Miss_Num,
190: total_time_calc number := Fnd_Api.G_Miss_Num,
191: labor_time_user number := Fnd_Api.G_Miss_Num,
192: machine_time_user number := Fnd_Api.G_Miss_Num,
193: total_time_user number := Fnd_Api.G_Miss_Num,
186: cumulative_yield number := Fnd_Api.G_Miss_Num,
187: reverse_cumulative_yield number := Fnd_Api.G_Miss_Num,
188: labor_time_calc number := Fnd_Api.G_Miss_Num,
189: machine_time_calc number := Fnd_Api.G_Miss_Num,
190: total_time_calc number := Fnd_Api.G_Miss_Num,
191: labor_time_user number := Fnd_Api.G_Miss_Num,
192: machine_time_user number := Fnd_Api.G_Miss_Num,
193: total_time_user number := Fnd_Api.G_Miss_Num,
194: net_planning_percent number := Fnd_Api.G_Miss_Num,
187: reverse_cumulative_yield number := Fnd_Api.G_Miss_Num,
188: labor_time_calc number := Fnd_Api.G_Miss_Num,
189: machine_time_calc number := Fnd_Api.G_Miss_Num,
190: total_time_calc number := Fnd_Api.G_Miss_Num,
191: labor_time_user number := Fnd_Api.G_Miss_Num,
192: machine_time_user number := Fnd_Api.G_Miss_Num,
193: total_time_user number := Fnd_Api.G_Miss_Num,
194: net_planning_percent number := Fnd_Api.G_Miss_Num,
195: include_in_rollup number := Fnd_Api.G_Miss_Num,
188: labor_time_calc number := Fnd_Api.G_Miss_Num,
189: machine_time_calc number := Fnd_Api.G_Miss_Num,
190: total_time_calc number := Fnd_Api.G_Miss_Num,
191: labor_time_user number := Fnd_Api.G_Miss_Num,
192: machine_time_user number := Fnd_Api.G_Miss_Num,
193: total_time_user number := Fnd_Api.G_Miss_Num,
194: net_planning_percent number := Fnd_Api.G_Miss_Num,
195: include_in_rollup number := Fnd_Api.G_Miss_Num,
196: operation_yield_enabled number := Fnd_Api.G_Miss_Num
189: machine_time_calc number := Fnd_Api.G_Miss_Num,
190: total_time_calc number := Fnd_Api.G_Miss_Num,
191: labor_time_user number := Fnd_Api.G_Miss_Num,
192: machine_time_user number := Fnd_Api.G_Miss_Num,
193: total_time_user number := Fnd_Api.G_Miss_Num,
194: net_planning_percent number := Fnd_Api.G_Miss_Num,
195: include_in_rollup number := Fnd_Api.G_Miss_Num,
196: operation_yield_enabled number := Fnd_Api.G_Miss_Num
197: );
190: total_time_calc number := Fnd_Api.G_Miss_Num,
191: labor_time_user number := Fnd_Api.G_Miss_Num,
192: machine_time_user number := Fnd_Api.G_Miss_Num,
193: total_time_user number := Fnd_Api.G_Miss_Num,
194: net_planning_percent number := Fnd_Api.G_Miss_Num,
195: include_in_rollup number := Fnd_Api.G_Miss_Num,
196: operation_yield_enabled number := Fnd_Api.G_Miss_Num
197: );
198:
191: labor_time_user number := Fnd_Api.G_Miss_Num,
192: machine_time_user number := Fnd_Api.G_Miss_Num,
193: total_time_user number := Fnd_Api.G_Miss_Num,
194: net_planning_percent number := Fnd_Api.G_Miss_Num,
195: include_in_rollup number := Fnd_Api.G_Miss_Num,
196: operation_yield_enabled number := Fnd_Api.G_Miss_Num
197: );
198:
199: G_MISS_OPERATION_REC operation_rec_type;
192: machine_time_user number := Fnd_Api.G_Miss_Num,
193: total_time_user number := Fnd_Api.G_Miss_Num,
194: net_planning_percent number := Fnd_Api.G_Miss_Num,
195: include_in_rollup number := Fnd_Api.G_Miss_Num,
196: operation_yield_enabled number := Fnd_Api.G_Miss_Num
197: );
198:
199: G_MISS_OPERATION_REC operation_rec_type;
200: G_VALID_LEVEL_NO_ASSIGN constant number := 5;
200: G_VALID_LEVEL_NO_ASSIGN constant number := 5;
201:
202: PROCEDURE AssignOperation(
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205: p_commit IN VARCHAR2 := FND_API.G_FALSE,
206: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
207: x_return_status IN OUT NOCOPY VARCHAR2,
208: x_msg_count IN OUT NOCOPY NUMBER,
201:
202: PROCEDURE AssignOperation(
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205: p_commit IN VARCHAR2 := FND_API.G_FALSE,
206: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
207: x_return_status IN OUT NOCOPY VARCHAR2,
208: x_msg_count IN OUT NOCOPY NUMBER,
209: x_msg_data IN OUT NOCOPY VARCHAR2,
202: PROCEDURE AssignOperation(
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205: p_commit IN VARCHAR2 := FND_API.G_FALSE,
206: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
207: x_return_status IN OUT NOCOPY VARCHAR2,
208: x_msg_count IN OUT NOCOPY NUMBER,
209: x_msg_data IN OUT NOCOPY VARCHAR2,
210: p_operation_rec IN OPERATION_REC_TYPE := G_MISS_OPERATION_REC,
212: );
213:
214: PROCEDURE ValidateOperation(
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217: p_commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219: x_return_status IN OUT NOCOPY VARCHAR2,
220: x_msg_count IN OUT NOCOPY NUMBER,
213:
214: PROCEDURE ValidateOperation(
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217: p_commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219: x_return_status IN OUT NOCOPY VARCHAR2,
220: x_msg_count IN OUT NOCOPY NUMBER,
221: x_msg_data IN OUT NOCOPY VARCHAR2,
214: PROCEDURE ValidateOperation(
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217: p_commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219: x_return_status IN OUT NOCOPY VARCHAR2,
220: x_msg_count IN OUT NOCOPY NUMBER,
221: x_msg_data IN OUT NOCOPY VARCHAR2,
222: p_operation_rec IN OPERATION_REC_TYPE := G_MISS_OPERATION_REC,
224: );
225:
226: PROCEDURE CreateOperation(
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
229: p_commit IN VARCHAR2 := FND_API.G_FALSE,
230: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
231: x_return_status IN OUT NOCOPY VARCHAR2,
232: x_msg_count IN OUT NOCOPY NUMBER,
225:
226: PROCEDURE CreateOperation(
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
229: p_commit IN VARCHAR2 := FND_API.G_FALSE,
230: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
231: x_return_status IN OUT NOCOPY VARCHAR2,
232: x_msg_count IN OUT NOCOPY NUMBER,
233: x_msg_data IN OUT NOCOPY VARCHAR2,
226: PROCEDURE CreateOperation(
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
229: p_commit IN VARCHAR2 := FND_API.G_FALSE,
230: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
231: x_return_status IN OUT NOCOPY VARCHAR2,
232: x_msg_count IN OUT NOCOPY NUMBER,
233: x_msg_data IN OUT NOCOPY VARCHAR2,
234: p_operation_rec IN OPERATION_REC_TYPE := G_MISS_OPERATION_REC,
236: );
237:
238: PROCEDURE UpdateOperation(
239: p_api_version IN NUMBER,
240: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
241: p_commit IN VARCHAR2 := FND_API.G_FALSE,
242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
243: x_return_status IN OUT NOCOPY VARCHAR2,
244: x_msg_count IN OUT NOCOPY NUMBER,
237:
238: PROCEDURE UpdateOperation(
239: p_api_version IN NUMBER,
240: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
241: p_commit IN VARCHAR2 := FND_API.G_FALSE,
242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
243: x_return_status IN OUT NOCOPY VARCHAR2,
244: x_msg_count IN OUT NOCOPY NUMBER,
245: x_msg_data IN OUT NOCOPY VARCHAR2,
238: PROCEDURE UpdateOperation(
239: p_api_version IN NUMBER,
240: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
241: p_commit IN VARCHAR2 := FND_API.G_FALSE,
242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
243: x_return_status IN OUT NOCOPY VARCHAR2,
244: x_msg_count IN OUT NOCOPY NUMBER,
245: x_msg_data IN OUT NOCOPY VARCHAR2,
246: p_operation_rec IN OPERATION_REC_TYPE := G_MISS_OPERATION_REC,
248: );
249:
250: PROCEDURE DeleteOperation(
251: p_api_version IN NUMBER,
252: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
253: p_commit IN VARCHAR2 := FND_API.G_FALSE,
254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
255: x_return_status IN OUT NOCOPY VARCHAR2,
256: x_msg_count IN OUT NOCOPY NUMBER,
249:
250: PROCEDURE DeleteOperation(
251: p_api_version IN NUMBER,
252: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
253: p_commit IN VARCHAR2 := FND_API.G_FALSE,
254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
255: x_return_status IN OUT NOCOPY VARCHAR2,
256: x_msg_count IN OUT NOCOPY NUMBER,
257: x_msg_data IN OUT NOCOPY VARCHAR2,
250: PROCEDURE DeleteOperation(
251: p_api_version IN NUMBER,
252: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
253: p_commit IN VARCHAR2 := FND_API.G_FALSE,
254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
255: x_return_status IN OUT NOCOPY VARCHAR2,
256: x_msg_count IN OUT NOCOPY NUMBER,
257: x_msg_data IN OUT NOCOPY VARCHAR2,
258: p_delete_group IN VARCHAR2,