APPS.EAM_OP_NETWORK_UTILITY_PVT dependencies on WIP_OPERATION_NETWORKS

Line 94: FROM wip_operation_networks won

90: , l_eam_op_network_rec.attribute12
91: , l_eam_op_network_rec.attribute13
92: , l_eam_op_network_rec.attribute14
93: , l_eam_op_network_rec.attribute15
94: FROM wip_operation_networks won
95: WHERE won.wip_entity_id = p_wip_entity_id
96: AND won.organization_id = p_organization_id
97: AND won.prior_operation = p_prior_operation
98: AND won.next_operation = p_next_operation;

Line 121: * wip_operation_networks table.

117: * Parameters IN : Operation Networks column record
118: * Parameters OUT NOCOPY: Message Token Table
119: * Return Status
120: * Purpose : Procedure will perfrom an insert into the
121: * wip_operation_networks table.
122: *********************************************************************/
123:
124: PROCEDURE Insert_Row
125: ( p_eam_op_network_rec IN EAM_PROCESS_WO_PUB.eam_op_network_rec_type

Line 134: INSERT INTO WIP_OPERATION_NETWORKS

130: BEGIN
131:
132: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Operation Networks rec for ' || p_eam_op_network_rec.prior_operation); END IF;
133:
134: INSERT INTO WIP_OPERATION_NETWORKS
135: ( wip_entity_id
136: , organization_id
137: , prior_operation
138: , next_operation

Line 212: * wip_operation_networks table.

208: * Parameters IN : Operation Networks column record
209: * Parameters OUT NOCOPY: Message Token Table
210: * Return Status
211: * Purpose : Procedure will perfrom an Update on the
212: * wip_operation_networks table.
213: *********************************************************************/
214:
215: PROCEDURE Update_Row
216: ( p_eam_op_network_rec IN EAM_PROCESS_WO_PUB.eam_op_network_rec_type

Line 225: UPDATE WIP_OPERATION_NETWORKS

221: BEGIN
222:
223: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Operation Networks '|| p_eam_op_network_rec.prior_operation); END IF;
224:
225: UPDATE WIP_OPERATION_NETWORKS
226: SET prior_operation = p_eam_op_network_rec.prior_operation
227: , next_operation = p_eam_op_network_rec.next_operation
228: , attribute_category = p_eam_op_network_rec.attribute_category
229: , attribute1 = p_eam_op_network_rec.attribute1

Line 263: * wip_operation_networks table.

259: * Parameters IN : Operation Networks column record
260: * Parameters OUT NOCOPY: Message Token Table
261: * Return Status
262: * Purpose : Procedure will perfrom an Delete on the
263: * wip_operation_networks table.
264: *********************************************************************/
265:
266: PROCEDURE Delete_Row
267: ( p_eam_op_network_rec IN EAM_PROCESS_WO_PUB.eam_op_network_rec_type

Line 276: DELETE FROM WIP_OPERATION_NETWORKS

272: BEGIN
273:
274: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Operation Networks '|| p_eam_op_network_rec.prior_operation); END IF;
275:
276: DELETE FROM WIP_OPERATION_NETWORKS
277: WHERE organization_id = p_eam_op_network_rec.organization_id
278: AND wip_entity_id = p_eam_op_network_rec.wip_entity_id
279: AND prior_operation = p_eam_op_network_rec.prior_operation
280: AND next_operation = p_eam_op_network_rec.next_operation;