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_resource_rec RESOURCE_REC_TYPE Required
18: -- Default = G_MISS_RESOURCE_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_resource_rec RESOURCE_REC_TYPE Required
18: -- Default = G_MISS_RESOURCE_REC
19: -- OUT :
20: -- x_return_status VARCHAR2(1)
34: -- Parameters :
35: -- IN :
36: -- p_api_version NUMBER Required
37: -- p_init_msg_list VARCHAR2 Optional
38: -- Default = FND_API.G_FALSE
39: -- p_commit VARCHAR2 Optional
40: -- Default = FND_API.G_FALSE
41: -- p_validation_level NUMBER Optional
42: -- Default = FND_API.G_VALID_LEVEL_FULL
36: -- p_api_version NUMBER Required
37: -- p_init_msg_list VARCHAR2 Optional
38: -- Default = FND_API.G_FALSE
39: -- p_commit VARCHAR2 Optional
40: -- Default = FND_API.G_FALSE
41: -- p_validation_level NUMBER Optional
42: -- Default = FND_API.G_VALID_LEVEL_FULL
43: -- p_resource_rec RESOURCE_REC_TYPE Required
44: -- Default = G_MISS_RESOURCE_REC
38: -- Default = FND_API.G_FALSE
39: -- p_commit VARCHAR2 Optional
40: -- Default = FND_API.G_FALSE
41: -- p_validation_level NUMBER Optional
42: -- Default = FND_API.G_VALID_LEVEL_FULL
43: -- p_resource_rec RESOURCE_REC_TYPE Required
44: -- Default = G_MISS_RESOURCE_REC
45: -- OUT :
46: -- x_return_status VARCHAR2(1)
60: -- Parameters :
61: -- IN :
62: -- p_api_version NUMBER Required
63: -- p_init_msg_list VARCHAR2 Optional
64: -- Default = FND_API.G_FALSE
65: -- p_commit VARCHAR2 Optional
66: -- Default = FND_API.G_FALSE
67: -- p_validation_level NUMBER Optional
68: -- Default = FND_API.G_VALID_LEVEL_FULL
62: -- p_api_version NUMBER Required
63: -- p_init_msg_list VARCHAR2 Optional
64: -- Default = FND_API.G_FALSE
65: -- p_commit VARCHAR2 Optional
66: -- Default = FND_API.G_FALSE
67: -- p_validation_level NUMBER Optional
68: -- Default = FND_API.G_VALID_LEVEL_FULL
69: -- p_resource_rec RESOURCE_REC_TYPE Required
70: -- Default = G_MISS_RESOURCE_REC
64: -- Default = FND_API.G_FALSE
65: -- p_commit VARCHAR2 Optional
66: -- Default = FND_API.G_FALSE
67: -- p_validation_level NUMBER Optional
68: -- Default = FND_API.G_VALID_LEVEL_FULL
69: -- p_resource_rec RESOURCE_REC_TYPE Required
70: -- Default = G_MISS_RESOURCE_REC
71: -- OUT :
72: -- x_return_status VARCHAR2(1)
87: -- Parameters :
88: -- IN :
89: -- p_api_version NUMBER Required
90: -- p_init_msg_list VARCHAR2 Optional
91: -- Default = FND_API.G_FALSE
92: -- p_commit VARCHAR2 Optional
93: -- Default = FND_API.G_FALSE
94: -- p_validation_level NUMBER Optional
95: -- Default = FND_API.G_VALID_LEVEL_FULL
89: -- p_api_version NUMBER Required
90: -- p_init_msg_list VARCHAR2 Optional
91: -- Default = FND_API.G_FALSE
92: -- p_commit VARCHAR2 Optional
93: -- Default = FND_API.G_FALSE
94: -- p_validation_level NUMBER Optional
95: -- Default = FND_API.G_VALID_LEVEL_FULL
96: -- p_resource_rec RESOURCE_REC_TYPE Required
97: -- Default = G_MISS_RESOURCE_REC
91: -- Default = FND_API.G_FALSE
92: -- p_commit VARCHAR2 Optional
93: -- Default = FND_API.G_FALSE
94: -- p_validation_level NUMBER Optional
95: -- Default = FND_API.G_VALID_LEVEL_FULL
96: -- p_resource_rec RESOURCE_REC_TYPE Required
97: -- Default = G_MISS_RESOURCE_REC
98: -- OUT :
99: -- x_return_status VARCHAR2(1)
114: -- Parameters :
115: -- IN :
116: -- p_api_version NUMBER Required
117: -- p_init_msg_list VARCHAR2 Optional
118: -- Default = FND_API.G_FALSE
119: -- p_commit VARCHAR2 Optional
120: -- Default = FND_API.G_FALSE
121: -- p_validation_level NUMBER Optional
122: -- Default = FND_API.G_VALID_LEVEL_FULL
116: -- p_api_version NUMBER Required
117: -- p_init_msg_list VARCHAR2 Optional
118: -- Default = FND_API.G_FALSE
119: -- p_commit VARCHAR2 Optional
120: -- Default = FND_API.G_FALSE
121: -- p_validation_level NUMBER Optional
122: -- Default = FND_API.G_VALID_LEVEL_FULL
123: -- p_resource_rec RESOURCE_REC_TYPE Required
124: -- Default = G_MISS_RESOURCE_REC
118: -- Default = FND_API.G_FALSE
119: -- p_commit VARCHAR2 Optional
120: -- Default = FND_API.G_FALSE
121: -- p_validation_level NUMBER Optional
122: -- Default = FND_API.G_VALID_LEVEL_FULL
123: -- p_resource_rec RESOURCE_REC_TYPE Required
124: -- Default = G_MISS_RESOURCE_REC
125: -- OUT :
126: -- x_return_status VARCHAR2(1)
134: -- Notes : Full Validation includes AssignResource
135: --
136: -- End of comments
137: TYPE resource_rec_type is record(
138: operation_sequence_id NUMBER := Fnd_Api.G_Miss_Num,
139: routing_sequence_id NUMBER := Fnd_Api.G_Miss_Num,
140: assembly_item_id NUMBER := Fnd_Api.G_Miss_Num,
141: assembly_item_number VARCHAR2(81) := Fnd_Api.G_Miss_Char,
142: organization_id NUMBER := Fnd_Api.G_Miss_Num,
135: --
136: -- End of comments
137: TYPE resource_rec_type is record(
138: operation_sequence_id NUMBER := Fnd_Api.G_Miss_Num,
139: routing_sequence_id NUMBER := Fnd_Api.G_Miss_Num,
140: assembly_item_id NUMBER := Fnd_Api.G_Miss_Num,
141: assembly_item_number VARCHAR2(81) := Fnd_Api.G_Miss_Char,
142: organization_id NUMBER := Fnd_Api.G_Miss_Num,
143: organization_code VARCHAR2(3) := Fnd_Api.G_Miss_Char,
136: -- End of comments
137: TYPE resource_rec_type is record(
138: operation_sequence_id NUMBER := Fnd_Api.G_Miss_Num,
139: routing_sequence_id NUMBER := Fnd_Api.G_Miss_Num,
140: assembly_item_id NUMBER := Fnd_Api.G_Miss_Num,
141: assembly_item_number VARCHAR2(81) := Fnd_Api.G_Miss_Char,
142: organization_id NUMBER := Fnd_Api.G_Miss_Num,
143: organization_code VARCHAR2(3) := Fnd_Api.G_Miss_Char,
144: alternate_routing_designator VARCHAR2(10) := Fnd_Api.G_Miss_Char,
137: TYPE resource_rec_type is record(
138: operation_sequence_id NUMBER := Fnd_Api.G_Miss_Num,
139: routing_sequence_id NUMBER := Fnd_Api.G_Miss_Num,
140: assembly_item_id NUMBER := Fnd_Api.G_Miss_Num,
141: assembly_item_number VARCHAR2(81) := Fnd_Api.G_Miss_Char,
142: organization_id NUMBER := Fnd_Api.G_Miss_Num,
143: organization_code VARCHAR2(3) := Fnd_Api.G_Miss_Char,
144: alternate_routing_designator VARCHAR2(10) := Fnd_Api.G_Miss_Char,
145: operation_seq_num NUMBER := Fnd_Api.G_Miss_Num,
138: operation_sequence_id NUMBER := Fnd_Api.G_Miss_Num,
139: routing_sequence_id NUMBER := Fnd_Api.G_Miss_Num,
140: assembly_item_id NUMBER := Fnd_Api.G_Miss_Num,
141: assembly_item_number VARCHAR2(81) := Fnd_Api.G_Miss_Char,
142: organization_id NUMBER := Fnd_Api.G_Miss_Num,
143: organization_code VARCHAR2(3) := Fnd_Api.G_Miss_Char,
144: alternate_routing_designator VARCHAR2(10) := Fnd_Api.G_Miss_Char,
145: operation_seq_num NUMBER := Fnd_Api.G_Miss_Num,
146: effectivity_date DATE := Fnd_Api.G_Miss_Date,
139: routing_sequence_id NUMBER := Fnd_Api.G_Miss_Num,
140: assembly_item_id NUMBER := Fnd_Api.G_Miss_Num,
141: assembly_item_number VARCHAR2(81) := Fnd_Api.G_Miss_Char,
142: organization_id NUMBER := Fnd_Api.G_Miss_Num,
143: organization_code VARCHAR2(3) := Fnd_Api.G_Miss_Char,
144: alternate_routing_designator VARCHAR2(10) := Fnd_Api.G_Miss_Char,
145: operation_seq_num NUMBER := Fnd_Api.G_Miss_Num,
146: effectivity_date DATE := Fnd_Api.G_Miss_Date,
147: resource_seq_num NUMBER := Fnd_Api.G_Miss_Num,
140: assembly_item_id NUMBER := Fnd_Api.G_Miss_Num,
141: assembly_item_number VARCHAR2(81) := Fnd_Api.G_Miss_Char,
142: organization_id NUMBER := Fnd_Api.G_Miss_Num,
143: organization_code VARCHAR2(3) := Fnd_Api.G_Miss_Char,
144: alternate_routing_designator VARCHAR2(10) := Fnd_Api.G_Miss_Char,
145: operation_seq_num NUMBER := Fnd_Api.G_Miss_Num,
146: effectivity_date DATE := Fnd_Api.G_Miss_Date,
147: resource_seq_num NUMBER := Fnd_Api.G_Miss_Num,
148: new_resource_seq_num NUMBER := Fnd_Api.G_Miss_Num,
141: assembly_item_number VARCHAR2(81) := Fnd_Api.G_Miss_Char,
142: organization_id NUMBER := Fnd_Api.G_Miss_Num,
143: organization_code VARCHAR2(3) := Fnd_Api.G_Miss_Char,
144: alternate_routing_designator VARCHAR2(10) := Fnd_Api.G_Miss_Char,
145: operation_seq_num NUMBER := Fnd_Api.G_Miss_Num,
146: effectivity_date DATE := Fnd_Api.G_Miss_Date,
147: resource_seq_num NUMBER := Fnd_Api.G_Miss_Num,
148: new_resource_seq_num NUMBER := Fnd_Api.G_Miss_Num,
149: resource_id NUMBER := Fnd_Api.G_Miss_Num,
142: organization_id NUMBER := Fnd_Api.G_Miss_Num,
143: organization_code VARCHAR2(3) := Fnd_Api.G_Miss_Char,
144: alternate_routing_designator VARCHAR2(10) := Fnd_Api.G_Miss_Char,
145: operation_seq_num NUMBER := Fnd_Api.G_Miss_Num,
146: effectivity_date DATE := Fnd_Api.G_Miss_Date,
147: resource_seq_num NUMBER := Fnd_Api.G_Miss_Num,
148: new_resource_seq_num NUMBER := Fnd_Api.G_Miss_Num,
149: resource_id NUMBER := Fnd_Api.G_Miss_Num,
150: resource_code VARCHAR2(10) := Fnd_Api.G_Miss_Char,
143: organization_code VARCHAR2(3) := Fnd_Api.G_Miss_Char,
144: alternate_routing_designator VARCHAR2(10) := Fnd_Api.G_Miss_Char,
145: operation_seq_num NUMBER := Fnd_Api.G_Miss_Num,
146: effectivity_date DATE := Fnd_Api.G_Miss_Date,
147: resource_seq_num NUMBER := Fnd_Api.G_Miss_Num,
148: new_resource_seq_num NUMBER := Fnd_Api.G_Miss_Num,
149: resource_id NUMBER := Fnd_Api.G_Miss_Num,
150: resource_code VARCHAR2(10) := Fnd_Api.G_Miss_Char,
151: activity_id NUMBER := Fnd_Api.G_Miss_Num,
144: alternate_routing_designator VARCHAR2(10) := Fnd_Api.G_Miss_Char,
145: operation_seq_num NUMBER := Fnd_Api.G_Miss_Num,
146: effectivity_date DATE := Fnd_Api.G_Miss_Date,
147: resource_seq_num NUMBER := Fnd_Api.G_Miss_Num,
148: new_resource_seq_num NUMBER := Fnd_Api.G_Miss_Num,
149: resource_id NUMBER := Fnd_Api.G_Miss_Num,
150: resource_code VARCHAR2(10) := Fnd_Api.G_Miss_Char,
151: activity_id NUMBER := Fnd_Api.G_Miss_Num,
152: activity VARCHAR2(10) := Fnd_Api.G_Miss_Char,
145: operation_seq_num NUMBER := Fnd_Api.G_Miss_Num,
146: effectivity_date DATE := Fnd_Api.G_Miss_Date,
147: resource_seq_num NUMBER := Fnd_Api.G_Miss_Num,
148: new_resource_seq_num NUMBER := Fnd_Api.G_Miss_Num,
149: resource_id NUMBER := Fnd_Api.G_Miss_Num,
150: resource_code VARCHAR2(10) := Fnd_Api.G_Miss_Char,
151: activity_id NUMBER := Fnd_Api.G_Miss_Num,
152: activity VARCHAR2(10) := Fnd_Api.G_Miss_Char,
153: standard_rate_flag NUMBER := Fnd_Api.G_Miss_Num,
146: effectivity_date DATE := Fnd_Api.G_Miss_Date,
147: resource_seq_num NUMBER := Fnd_Api.G_Miss_Num,
148: new_resource_seq_num NUMBER := Fnd_Api.G_Miss_Num,
149: resource_id NUMBER := Fnd_Api.G_Miss_Num,
150: resource_code VARCHAR2(10) := Fnd_Api.G_Miss_Char,
151: activity_id NUMBER := Fnd_Api.G_Miss_Num,
152: activity VARCHAR2(10) := Fnd_Api.G_Miss_Char,
153: standard_rate_flag NUMBER := Fnd_Api.G_Miss_Num,
154: assigned_units NUMBER := Fnd_Api.G_Miss_Num,
147: resource_seq_num NUMBER := Fnd_Api.G_Miss_Num,
148: new_resource_seq_num NUMBER := Fnd_Api.G_Miss_Num,
149: resource_id NUMBER := Fnd_Api.G_Miss_Num,
150: resource_code VARCHAR2(10) := Fnd_Api.G_Miss_Char,
151: activity_id NUMBER := Fnd_Api.G_Miss_Num,
152: activity VARCHAR2(10) := Fnd_Api.G_Miss_Char,
153: standard_rate_flag NUMBER := Fnd_Api.G_Miss_Num,
154: assigned_units NUMBER := Fnd_Api.G_Miss_Num,
155: usage_rate_or_amount NUMBER := Fnd_Api.G_Miss_Num,
148: new_resource_seq_num NUMBER := Fnd_Api.G_Miss_Num,
149: resource_id NUMBER := Fnd_Api.G_Miss_Num,
150: resource_code VARCHAR2(10) := Fnd_Api.G_Miss_Char,
151: activity_id NUMBER := Fnd_Api.G_Miss_Num,
152: activity VARCHAR2(10) := Fnd_Api.G_Miss_Char,
153: standard_rate_flag NUMBER := Fnd_Api.G_Miss_Num,
154: assigned_units NUMBER := Fnd_Api.G_Miss_Num,
155: usage_rate_or_amount NUMBER := Fnd_Api.G_Miss_Num,
156: usage_rate_or_amount_inverse NUMBER := Fnd_Api.G_Miss_Num,
149: resource_id NUMBER := Fnd_Api.G_Miss_Num,
150: resource_code VARCHAR2(10) := Fnd_Api.G_Miss_Char,
151: activity_id NUMBER := Fnd_Api.G_Miss_Num,
152: activity VARCHAR2(10) := Fnd_Api.G_Miss_Char,
153: standard_rate_flag NUMBER := Fnd_Api.G_Miss_Num,
154: assigned_units NUMBER := Fnd_Api.G_Miss_Num,
155: usage_rate_or_amount NUMBER := Fnd_Api.G_Miss_Num,
156: usage_rate_or_amount_inverse NUMBER := Fnd_Api.G_Miss_Num,
157: basis_type NUMBER := Fnd_Api.G_Miss_Num,
150: resource_code VARCHAR2(10) := Fnd_Api.G_Miss_Char,
151: activity_id NUMBER := Fnd_Api.G_Miss_Num,
152: activity VARCHAR2(10) := Fnd_Api.G_Miss_Char,
153: standard_rate_flag NUMBER := Fnd_Api.G_Miss_Num,
154: assigned_units NUMBER := Fnd_Api.G_Miss_Num,
155: usage_rate_or_amount NUMBER := Fnd_Api.G_Miss_Num,
156: usage_rate_or_amount_inverse NUMBER := Fnd_Api.G_Miss_Num,
157: basis_type NUMBER := Fnd_Api.G_Miss_Num,
158: schedule_flag NUMBER := Fnd_Api.G_Miss_Num,
151: activity_id NUMBER := Fnd_Api.G_Miss_Num,
152: activity VARCHAR2(10) := Fnd_Api.G_Miss_Char,
153: standard_rate_flag NUMBER := Fnd_Api.G_Miss_Num,
154: assigned_units NUMBER := Fnd_Api.G_Miss_Num,
155: usage_rate_or_amount NUMBER := Fnd_Api.G_Miss_Num,
156: usage_rate_or_amount_inverse NUMBER := Fnd_Api.G_Miss_Num,
157: basis_type NUMBER := Fnd_Api.G_Miss_Num,
158: schedule_flag NUMBER := Fnd_Api.G_Miss_Num,
159: resource_offset_percent NUMBER := Fnd_Api.G_Miss_Num,
152: activity VARCHAR2(10) := Fnd_Api.G_Miss_Char,
153: standard_rate_flag NUMBER := Fnd_Api.G_Miss_Num,
154: assigned_units NUMBER := Fnd_Api.G_Miss_Num,
155: usage_rate_or_amount NUMBER := Fnd_Api.G_Miss_Num,
156: usage_rate_or_amount_inverse NUMBER := Fnd_Api.G_Miss_Num,
157: basis_type NUMBER := Fnd_Api.G_Miss_Num,
158: schedule_flag NUMBER := Fnd_Api.G_Miss_Num,
159: resource_offset_percent NUMBER := Fnd_Api.G_Miss_Num,
160: autocharge_type NUMBER := Fnd_Api.G_Miss_Num,
153: standard_rate_flag NUMBER := Fnd_Api.G_Miss_Num,
154: assigned_units NUMBER := Fnd_Api.G_Miss_Num,
155: usage_rate_or_amount NUMBER := Fnd_Api.G_Miss_Num,
156: usage_rate_or_amount_inverse NUMBER := Fnd_Api.G_Miss_Num,
157: basis_type NUMBER := Fnd_Api.G_Miss_Num,
158: schedule_flag NUMBER := Fnd_Api.G_Miss_Num,
159: resource_offset_percent NUMBER := Fnd_Api.G_Miss_Num,
160: autocharge_type NUMBER := Fnd_Api.G_Miss_Num,
161: attribute_category VARCHAR2(30) := Fnd_Api.G_Miss_Char,
154: assigned_units NUMBER := Fnd_Api.G_Miss_Num,
155: usage_rate_or_amount NUMBER := Fnd_Api.G_Miss_Num,
156: usage_rate_or_amount_inverse NUMBER := Fnd_Api.G_Miss_Num,
157: basis_type NUMBER := Fnd_Api.G_Miss_Num,
158: schedule_flag NUMBER := Fnd_Api.G_Miss_Num,
159: resource_offset_percent NUMBER := Fnd_Api.G_Miss_Num,
160: autocharge_type NUMBER := Fnd_Api.G_Miss_Num,
161: attribute_category VARCHAR2(30) := Fnd_Api.G_Miss_Char,
162: attribute1 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
155: usage_rate_or_amount NUMBER := Fnd_Api.G_Miss_Num,
156: usage_rate_or_amount_inverse NUMBER := Fnd_Api.G_Miss_Num,
157: basis_type NUMBER := Fnd_Api.G_Miss_Num,
158: schedule_flag NUMBER := Fnd_Api.G_Miss_Num,
159: resource_offset_percent NUMBER := Fnd_Api.G_Miss_Num,
160: autocharge_type NUMBER := Fnd_Api.G_Miss_Num,
161: attribute_category VARCHAR2(30) := Fnd_Api.G_Miss_Char,
162: attribute1 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
163: attribute2 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
156: usage_rate_or_amount_inverse NUMBER := Fnd_Api.G_Miss_Num,
157: basis_type NUMBER := Fnd_Api.G_Miss_Num,
158: schedule_flag NUMBER := Fnd_Api.G_Miss_Num,
159: resource_offset_percent NUMBER := Fnd_Api.G_Miss_Num,
160: autocharge_type NUMBER := Fnd_Api.G_Miss_Num,
161: attribute_category VARCHAR2(30) := Fnd_Api.G_Miss_Char,
162: attribute1 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
163: attribute2 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
164: attribute3 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
157: basis_type NUMBER := Fnd_Api.G_Miss_Num,
158: schedule_flag NUMBER := Fnd_Api.G_Miss_Num,
159: resource_offset_percent NUMBER := Fnd_Api.G_Miss_Num,
160: autocharge_type NUMBER := Fnd_Api.G_Miss_Num,
161: attribute_category VARCHAR2(30) := Fnd_Api.G_Miss_Char,
162: attribute1 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
163: attribute2 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
164: attribute3 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
165: attribute4 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
158: schedule_flag NUMBER := Fnd_Api.G_Miss_Num,
159: resource_offset_percent NUMBER := Fnd_Api.G_Miss_Num,
160: autocharge_type NUMBER := Fnd_Api.G_Miss_Num,
161: attribute_category VARCHAR2(30) := Fnd_Api.G_Miss_Char,
162: attribute1 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
163: attribute2 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
164: attribute3 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
165: attribute4 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
166: attribute5 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
159: resource_offset_percent NUMBER := Fnd_Api.G_Miss_Num,
160: autocharge_type NUMBER := Fnd_Api.G_Miss_Num,
161: attribute_category VARCHAR2(30) := Fnd_Api.G_Miss_Char,
162: attribute1 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
163: attribute2 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
164: attribute3 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
165: attribute4 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
166: attribute5 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
167: attribute6 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
160: autocharge_type NUMBER := Fnd_Api.G_Miss_Num,
161: attribute_category VARCHAR2(30) := Fnd_Api.G_Miss_Char,
162: attribute1 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
163: attribute2 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
164: attribute3 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
165: attribute4 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
166: attribute5 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
167: attribute6 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
168: attribute7 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
161: attribute_category VARCHAR2(30) := Fnd_Api.G_Miss_Char,
162: attribute1 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
163: attribute2 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
164: attribute3 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
165: attribute4 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
166: attribute5 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
167: attribute6 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
168: attribute7 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
169: attribute8 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
162: attribute1 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
163: attribute2 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
164: attribute3 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
165: attribute4 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
166: attribute5 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
167: attribute6 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
168: attribute7 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
169: attribute8 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
170: attribute9 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
163: attribute2 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
164: attribute3 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
165: attribute4 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
166: attribute5 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
167: attribute6 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
168: attribute7 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
169: attribute8 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
170: attribute9 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
171: attribute10 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
164: attribute3 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
165: attribute4 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
166: attribute5 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
167: attribute6 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
168: attribute7 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
169: attribute8 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
170: attribute9 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
171: attribute10 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
172: attribute11 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
165: attribute4 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
166: attribute5 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
167: attribute6 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
168: attribute7 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
169: attribute8 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
170: attribute9 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
171: attribute10 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
172: attribute11 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
173: attribute12 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
166: attribute5 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
167: attribute6 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
168: attribute7 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
169: attribute8 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
170: attribute9 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
171: attribute10 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
172: attribute11 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
173: attribute12 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
174: attribute13 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
167: attribute6 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
168: attribute7 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
169: attribute8 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
170: attribute9 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
171: attribute10 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
172: attribute11 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
173: attribute12 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
174: attribute13 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
175: attribute14 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
168: attribute7 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
169: attribute8 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
170: attribute9 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
171: attribute10 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
172: attribute11 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
173: attribute12 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
174: attribute13 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
175: attribute14 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
176: attribute15 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
169: attribute8 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
170: attribute9 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
171: attribute10 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
172: attribute11 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
173: attribute12 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
174: attribute13 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
175: attribute14 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
176: attribute15 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
177: Principle_flag Number := Fnd_Api.G_Miss_Num,
170: attribute9 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
171: attribute10 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
172: attribute11 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
173: attribute12 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
174: attribute13 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
175: attribute14 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
176: attribute15 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
177: Principle_flag Number := Fnd_Api.G_Miss_Num,
178: schedule_seq_num Number := Fnd_Api.G_Miss_Num
171: attribute10 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
172: attribute11 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
173: attribute12 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
174: attribute13 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
175: attribute14 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
176: attribute15 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
177: Principle_flag Number := Fnd_Api.G_Miss_Num,
178: schedule_seq_num Number := Fnd_Api.G_Miss_Num
179: );
172: attribute11 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
173: attribute12 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
174: attribute13 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
175: attribute14 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
176: attribute15 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
177: Principle_flag Number := Fnd_Api.G_Miss_Num,
178: schedule_seq_num Number := Fnd_Api.G_Miss_Num
179: );
180:
173: attribute12 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
174: attribute13 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
175: attribute14 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
176: attribute15 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
177: Principle_flag Number := Fnd_Api.G_Miss_Num,
178: schedule_seq_num Number := Fnd_Api.G_Miss_Num
179: );
180:
181: G_MISS_RESOURCE_REC RESOURCE_REC_TYPE;
174: attribute13 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
175: attribute14 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
176: attribute15 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
177: Principle_flag Number := Fnd_Api.G_Miss_Num,
178: schedule_seq_num Number := Fnd_Api.G_Miss_Num
179: );
180:
181: G_MISS_RESOURCE_REC RESOURCE_REC_TYPE;
182: G_VALID_LEVEL_NO_ASSIGN constant number := 5;
183: G_round_off_val number :=NVL(FND_PROFILE.VALUE('BOM:ROUND_OFF_VALUE'),6); /* Bug 7322996 */
184:
185: PROCEDURE AssignResource(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188: p_commit IN VARCHAR2 := FND_API.G_FALSE,
189: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
190: x_return_status IN OUT NOCOPY VARCHAR2,
191: x_msg_count IN OUT NOCOPY NUMBER,
184:
185: PROCEDURE AssignResource(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188: p_commit IN VARCHAR2 := FND_API.G_FALSE,
189: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
190: x_return_status IN OUT NOCOPY VARCHAR2,
191: x_msg_count IN OUT NOCOPY NUMBER,
192: x_msg_data IN OUT NOCOPY VARCHAR2,
185: PROCEDURE AssignResource(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188: p_commit IN VARCHAR2 := FND_API.G_FALSE,
189: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
190: x_return_status IN OUT NOCOPY VARCHAR2,
191: x_msg_count IN OUT NOCOPY NUMBER,
192: x_msg_data IN OUT NOCOPY VARCHAR2,
193: p_resource_rec IN RESOURCE_REC_TYPE := G_MISS_RESOURCE_REC,
194: x_resource_rec IN OUT NOCOPY RESOURCE_REC_TYPE
195: );
196: PROCEDURE ValidateResource(
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
199: p_commit IN VARCHAR2 := FND_API.G_FALSE,
200: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
201: x_return_status IN OUT NOCOPY VARCHAR2,
202: x_msg_count IN OUT NOCOPY NUMBER,
195: );
196: PROCEDURE ValidateResource(
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
199: p_commit IN VARCHAR2 := FND_API.G_FALSE,
200: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
201: x_return_status IN OUT NOCOPY VARCHAR2,
202: x_msg_count IN OUT NOCOPY NUMBER,
203: x_msg_data IN OUT NOCOPY VARCHAR2,
196: PROCEDURE ValidateResource(
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
199: p_commit IN VARCHAR2 := FND_API.G_FALSE,
200: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
201: x_return_status IN OUT NOCOPY VARCHAR2,
202: x_msg_count IN OUT NOCOPY NUMBER,
203: x_msg_data IN OUT NOCOPY VARCHAR2,
204: p_resource_rec IN RESOURCE_REC_TYPE := G_MISS_RESOURCE_REC,
205: x_resource_rec IN OUT NOCOPY RESOURCE_REC_TYPE
206: );
207: PROCEDURE CreateResource(
208: p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE,
211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212: x_return_status IN OUT NOCOPY VARCHAR2,
213: x_msg_count IN OUT NOCOPY NUMBER,
206: );
207: PROCEDURE CreateResource(
208: p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE,
211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212: x_return_status IN OUT NOCOPY VARCHAR2,
213: x_msg_count IN OUT NOCOPY NUMBER,
214: x_msg_data IN OUT NOCOPY VARCHAR2,
207: PROCEDURE CreateResource(
208: p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE,
211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212: x_return_status IN OUT NOCOPY VARCHAR2,
213: x_msg_count IN OUT NOCOPY NUMBER,
214: x_msg_data IN OUT NOCOPY VARCHAR2,
215: p_resource_rec IN RESOURCE_REC_TYPE := G_MISS_RESOURCE_REC,
216: x_resource_rec IN OUT NOCOPY RESOURCE_REC_TYPE
217: );
218: PROCEDURE UpdateResource(
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
221: p_commit IN VARCHAR2 := FND_API.G_FALSE,
222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
223: x_return_status IN OUT NOCOPY VARCHAR2,
224: x_msg_count IN OUT NOCOPY NUMBER,
217: );
218: PROCEDURE UpdateResource(
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
221: p_commit IN VARCHAR2 := FND_API.G_FALSE,
222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
223: x_return_status IN OUT NOCOPY VARCHAR2,
224: x_msg_count IN OUT NOCOPY NUMBER,
225: x_msg_data IN OUT NOCOPY VARCHAR2,
218: PROCEDURE UpdateResource(
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
221: p_commit IN VARCHAR2 := FND_API.G_FALSE,
222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
223: x_return_status IN OUT NOCOPY VARCHAR2,
224: x_msg_count IN OUT NOCOPY NUMBER,
225: x_msg_data IN OUT NOCOPY VARCHAR2,
226: p_resource_rec IN RESOURCE_REC_TYPE := G_MISS_RESOURCE_REC,
227: x_resource_rec IN OUT NOCOPY RESOURCE_REC_TYPE
228: );
229: PROCEDURE DeleteResource(
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232: p_commit IN VARCHAR2 := FND_API.G_FALSE,
233: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
234: x_return_status IN OUT NOCOPY VARCHAR2,
235: x_msg_count IN OUT NOCOPY NUMBER,
228: );
229: PROCEDURE DeleteResource(
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232: p_commit IN VARCHAR2 := FND_API.G_FALSE,
233: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
234: x_return_status IN OUT NOCOPY VARCHAR2,
235: x_msg_count IN OUT NOCOPY NUMBER,
236: x_msg_data IN OUT NOCOPY VARCHAR2,
229: PROCEDURE DeleteResource(
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232: p_commit IN VARCHAR2 := FND_API.G_FALSE,
233: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
234: x_return_status IN OUT NOCOPY VARCHAR2,
235: x_msg_count IN OUT NOCOPY NUMBER,
236: x_msg_data IN OUT NOCOPY VARCHAR2,
237: p_resource_rec IN RESOURCE_REC_TYPE := G_MISS_RESOURCE_REC,