DBA Data[Home] [Help]

APPS.BOM_OPRESOURCE_PVT dependencies on FND_API

Line 12: -- Default = FND_API.G_FALSE

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

Line 14: -- Default = FND_API.G_FALSE

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

Line 16: -- Default = FND_API.G_VALID_LEVEL_FULL

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)

Line 38: -- Default = FND_API.G_FALSE

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

Line 40: -- Default = FND_API.G_FALSE

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

Line 42: -- Default = FND_API.G_VALID_LEVEL_FULL

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)

Line 64: -- Default = FND_API.G_FALSE

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

Line 66: -- Default = FND_API.G_FALSE

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

Line 68: -- Default = FND_API.G_VALID_LEVEL_FULL

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)

Line 91: -- Default = FND_API.G_FALSE

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

Line 93: -- Default = FND_API.G_FALSE

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

Line 95: -- Default = FND_API.G_VALID_LEVEL_FULL

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)

Line 118: -- Default = FND_API.G_FALSE

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

Line 120: -- Default = FND_API.G_FALSE

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

Line 122: -- Default = FND_API.G_VALID_LEVEL_FULL

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)

Line 138: operation_sequence_id NUMBER := Fnd_Api.G_Miss_Num,

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,

Line 139: routing_sequence_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,

Line 140: assembly_item_id NUMBER := Fnd_Api.G_Miss_Num,

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,

Line 141: assembly_item_number VARCHAR2(81) := 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,

Line 142: organization_id 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,

Line 143: organization_code VARCHAR2(3) := Fnd_Api.G_Miss_Char,

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,

Line 144: alternate_routing_designator VARCHAR2(10) := Fnd_Api.G_Miss_Char,

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,

Line 145: operation_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,

Line 146: effectivity_date DATE := Fnd_Api.G_Miss_Date,

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,

Line 147: resource_seq_num 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,
151: activity_id NUMBER := Fnd_Api.G_Miss_Num,

Line 148: new_resource_seq_num 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,

Line 149: resource_id NUMBER := Fnd_Api.G_Miss_Num,

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,

Line 150: resource_code VARCHAR2(10) := Fnd_Api.G_Miss_Char,

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,

Line 151: activity_id 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,

Line 152: activity VARCHAR2(10) := Fnd_Api.G_Miss_Char,

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,

Line 153: standard_rate_flag 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,

Line 154: assigned_units 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,

Line 155: usage_rate_or_amount 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,

Line 156: usage_rate_or_amount_inverse 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,

Line 157: basis_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,

Line 158: schedule_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,
162: attribute1 VARCHAR2(150) := Fnd_Api.G_Miss_Char,

Line 159: resource_offset_percent 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,
163: attribute2 VARCHAR2(150) := Fnd_Api.G_Miss_Char,

Line 160: autocharge_type 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,
164: attribute3 VARCHAR2(150) := Fnd_Api.G_Miss_Char,

Line 161: attribute_category VARCHAR2(30) := 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,

Line 162: attribute1 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,

Line 163: attribute2 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,

Line 164: attribute3 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,

Line 165: attribute4 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,

Line 166: attribute5 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,

Line 167: attribute6 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,

Line 168: attribute7 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,

Line 169: attribute8 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,

Line 170: attribute9 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,

Line 171: attribute10 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,

Line 172: attribute11 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,

Line 173: attribute12 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,

Line 174: attribute13 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,
178: schedule_seq_num Number := Fnd_Api.G_Miss_Num

Line 175: attribute14 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
179: );

Line 176: attribute15 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: );
180:

Line 177: Principle_flag Number := Fnd_Api.G_Miss_Num,

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;

Line 178: schedule_seq_num Number := Fnd_Api.G_Miss_Num

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;

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

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,

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

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,

Line 189: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

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

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,

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

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,

Line 200: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

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

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,

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

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,

Line 211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

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

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,

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

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,

Line 222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

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

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,

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

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,

Line 233: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,