APPS.EAM_SKILL_INSTANCE dependencies on WIP_OP_RESOURCE_INSTANCES

Line 70: INSERT INTO WIP_OP_RESOURCE_INSTANCES

66: x_duplicate := is_duplicate_instance(p_wip_entity_id, p_operation_seq_num,
67: p_resource_seq_num, l_org_id, p_instance_id);
68:
69: if (NOT x_duplicate) then
70: INSERT INTO WIP_OP_RESOURCE_INSTANCES
71: (
72: WIP_ENTITY_ID,
73: OPERATION_SEQ_NUM,
74: RESOURCE_SEQ_NUM,

Line 121: from WIP_OP_RESOURCE_INSTANCES

117: p_instance_id in number) return boolean is
118: l_num NUMBER;
119: begin
120: select count(*) into l_num
121: from WIP_OP_RESOURCE_INSTANCES
122: where wip_entity_id = p_wip_entity_id and
123: operation_seq_num = p_operation_seq_num and
124: resource_seq_num = p_resource_seq_num and
125: instance_id = p_instance_id;

Line 152: from WIP_OP_RESOURCE_INSTANCES

148:
149: begin
150:
151: select count(*) into l_instance_num
152: from WIP_OP_RESOURCE_INSTANCES
153: where wip_entity_id = p_wip_entity_id and
154: operation_seq_num = p_operation_seq_num and
155: resource_seq_num = p_resource_seq_num;
156:

Line 204: delete from wip_op_resource_instances

200: p_resource_seq_num in number,
201: p_instance_id in number) is
202: begin
203:
204: delete from wip_op_resource_instances
205: where wip_entity_id = p_wip_entity_id and
206: operation_seq_num = p_operation_seq_num and
207: resource_seq_num = p_resource_seq_num and
208: instance_id = p_instance_id;