APPS.EAM_SUB_RESOURCE_UTILITY_PVT dependencies on WIP_SUB_OPERATION_RESOURCES

Line 139: FROM WIP_SUB_OPERATION_RESOURCES

135: -- , l_eam_sub_res_rec.request_id
136: -- , l_eam_sub_res_rec.program_application_id
137: -- , l_eam_sub_res_rec.program_id
138: -- , l_eam_sub_res_rec.program_update_date
139: FROM WIP_SUB_OPERATION_RESOURCES
140: WHERE wip_entity_id = p_wip_entity_id
141: AND organization_id = p_organization_id
142: AND operation_seq_num = p_operation_seq_num
143: AND resource_seq_num = p_resource_seq_num;

Line 166: * wip_sub_operation_resources table.

162: * Parameters IN : Sub Resource column record
163: * Parameters OUT NOCOPY: Message Token Table
164: * Return Status
165: * Purpose : Procedure will perfrom an insert into the
166: * wip_sub_operation_resources table.
167: *********************************************************************/
168:
169: PROCEDURE Insert_Row
170: ( p_eam_sub_res_rec IN EAM_PROCESS_WO_PUB.eam_sub_res_rec_type

Line 187: INSERT INTO WIP_SUB_OPERATION_RESOURCES

183: return;
184: end if;
185:
186:
187: INSERT INTO WIP_SUB_OPERATION_RESOURCES
188: ( wip_entity_id
189: , organization_id
190: , operation_seq_num
191: , resource_seq_num

Line 306: * wip_sub_operation_resources table.

302: * Parameters IN : Sub Resource column record
303: * Parameters OUT NOCOPY: Message Token Table
304: * Return Status
305: * Purpose : Procedure will perfrom an Update on the
306: * wip_sub_operation_resources table.
307: *********************************************************************/
308:
309: PROCEDURE Update_Row
310: ( p_eam_sub_res_rec IN EAM_PROCESS_WO_PUB.eam_sub_res_rec_type

Line 326: UPDATE WIP_SUB_OPERATION_RESOURCES

322: fnd_message.set_name('EAM','EAM_WO_SUBR_DT_ERR');
323: return;
324: end if;
325:
326: UPDATE WIP_SUB_OPERATION_RESOURCES
327: SET resource_id = p_eam_sub_res_rec.resource_id
328: , uom_code = p_eam_sub_res_rec.uom_code
329: , basis_type = p_eam_sub_res_rec.basis_type
330: , usage_rate_or_amount = p_eam_sub_res_rec.usage_rate_or_amount

Line 381: * wip_sub_operation_resources table.

377: * Parameters IN : Sub Resource column record
378: * Parameters OUT NOCOPY: Message Token Table
379: * Return Status
380: * Purpose : Procedure will perfrom an Update on the
381: * wip_sub_operation_resources table.
382: *********************************************************************/
383:
384: PROCEDURE Delete_Row
385: ( p_eam_sub_res_rec IN EAM_PROCESS_WO_PUB.eam_sub_res_rec_type

Line 407: DELETE FROM WIP_SUB_OPERATION_RESOURCES

403: );
404:
405: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Deleting Sub resources') ; END IF;
406:
407: DELETE FROM WIP_SUB_OPERATION_RESOURCES
408: WHERE wip_entity_id = p_eam_sub_res_rec.wip_entity_id
409: AND organization_id = p_eam_sub_res_rec.organization_id
410: AND operation_seq_num = p_eam_sub_res_rec.operation_seq_num
411: AND resource_seq_num = p_eam_sub_res_rec.resource_seq_num;