APPS.EAM_RES_USAGE_UTILITY_PVT dependencies on WIP_OPERATION_RESOURCE_USAGE

Line 32: * wip_operation_resource_usage table.

28: * Parameters IN :
29: * Parameters OUT NOCOPY: Message Token Table
30: * Return Status
31: * Purpose : Procedure will perfrom an insert into the
32: * wip_operation_resource_usage table.
33: *********************************************************************/
34:
35: PROCEDURE Add_Usage
36: ( p_eam_res_usage_rec IN EAM_PROCESS_WO_PUB.eam_res_usage_rec_type

Line 53: INSERT INTO WIP_OPERATION_RESOURCE_USAGE

49: return;
50: end if;
51:
52:
53: INSERT INTO WIP_OPERATION_RESOURCE_USAGE
54: ( wip_entity_id
55: , operation_seq_num
56: , resource_seq_num
57: , organization_id

Line 115: * wip_operation_resource_usage table.

111: * Parameters IN :
112: * Parameters OUT NOCOPY: Message Token Table
113: * Return Status
114: * Purpose : Procedure will perfrom an Delete on the
115: * wip_operation_resource_usage table.
116: *********************************************************************/
117:
118: PROCEDURE Delete_Usage
119: ( p_wip_entity_id IN NUMBER

Line 131: DELETE FROM WIP_OPERATION_RESOURCE_USAGE

127: BEGIN
128:
129: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Resource Usage: '|| p_resource_seq_num); END IF;
130:
131: DELETE FROM WIP_OPERATION_RESOURCE_USAGE
132: WHERE wip_entity_id = p_wip_entity_id
133: AND organization_id = p_organization_id
134: AND operation_seq_num = p_operation_seq_num
135: AND resource_seq_num = p_resource_seq_num;