APPS.EAM_OP_UTILITY_PVT dependencies on WIP_OPERATIONS

Line 113: FROM wip_operations wo

109: , l_eam_op_rec.attribute13
110: , l_eam_op_rec.attribute14
111: , l_eam_op_rec.attribute15
112: , l_eam_op_rec.long_description
113: FROM wip_operations wo
114: WHERE wo.wip_entity_id = p_wip_entity_id
115: AND wo.organization_id = p_organization_id
116: AND wo.operation_seq_num = p_operation_seq_num;
117:

Line 139: * wip_operations table.

135: * Parameters IN : EAM OP column record
136: * Parameters OUT NOCOPY: Message Token Table
137: * Return Status
138: * Purpose : Procedure will perfrom an insert into the
139: * wip_operations table.
140: *********************************************************************/
141:
142: PROCEDURE Insert_Row
143: ( p_eam_op_rec IN EAM_PROCESS_WO_PUB.eam_op_rec_type

Line 162: INSERT INTO WIP_OPERATIONS

158: fnd_message.set_name('EAM','EAM_WO_OP_DT_ERR');
159: return;
160: end if;
161:
162: INSERT INTO WIP_OPERATIONS
163: ( wip_entity_id
164: , operation_seq_num
165: , organization_id
166: , operation_sequence_id

Line 294: from wip_operations

290: AND rownum <=1;
291:
292: IF l_count <> 0 THEN
293: select min(operation_seq_num) into l_min_op_seq_num
294: from wip_operations
295: where organization_id = p_eam_op_rec.organization_id
296: and wip_entity_id = p_eam_op_rec.wip_entity_id ;
297:
298: IF (l_min_op_seq_num is not null) THEN

Line 300: from wip_operations

296: and wip_entity_id = p_eam_op_rec.wip_entity_id ;
297:
298: IF (l_min_op_seq_num is not null) THEN
299: select department_id into l_department_id
300: from wip_operations
301: where organization_id = p_eam_op_rec.organization_id
302: and wip_entity_id = p_eam_op_rec.wip_entity_id
303: and operation_seq_num = l_min_op_seq_num;
304: END IF;

Line 324: from wip_operations

320: AND rownum <=1;
321:
322: IF l_count <> 0 THEN
323: select min(operation_seq_num) into l_min_op_seq_num
324: from wip_operations
325: where organization_id = p_eam_op_rec.organization_id
326: and wip_entity_id = p_eam_op_rec.wip_entity_id ;
327:
328:

Line 371: * wip_operations table.

367: * Parameters IN : EAM OP column record
368: * Parameters OUT NOCOPY: Message Token Table
369: * Return Status
370: * Purpose : Procedure will perfrom an Update on the
371: * wip_operations table.
372: *********************************************************************/
373:
374: PROCEDURE Update_Row
375: ( p_eam_op_rec IN EAM_PROCESS_WO_PUB.eam_op_rec_type

Line 394: from wip_operations

390: return;
391: end if;
392:
393: select department_id into l_old_dept_id
394: from wip_operations
395: WHERE organization_id = p_eam_op_rec.organization_id
396: AND wip_entity_id = p_eam_op_rec.wip_entity_id
397: AND operation_seq_num = p_eam_op_rec.operation_seq_num;
398:

Line 400: UPDATE WIP_OPERATIONS

396: AND wip_entity_id = p_eam_op_rec.wip_entity_id
397: AND operation_seq_num = p_eam_op_rec.operation_seq_num;
398:
399:
400: UPDATE WIP_OPERATIONS
401: SET operation_sequence_id = p_eam_op_rec.operation_sequence_id
402: , standard_operation_id = p_eam_op_rec.standard_operation_id
403: , department_id = p_eam_op_rec.department_id
404: , description = p_eam_op_rec.description

Line 474: DELETE FROM WIP_OPERATIONS

470: BEGIN
471:
472: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Operation: '|| p_eam_op_rec.operation_seq_num); END IF;
473:
474: DELETE FROM WIP_OPERATIONS
475: WHERE wip_entity_id = p_eam_op_rec.wip_entity_id
476: AND organization_id = p_eam_op_rec.organization_id
477: AND operation_seq_num = p_eam_op_rec.operation_seq_num;
478:

Line 503: * writes to the wip_operations.

499: * Parameters OUT NOCOPY: Messgae Token Table
500: * Return Status
501: * Purpose : This is the only procedure that the user will have
502: * access to when he/she needs to perform any kind of
503: * writes to the wip_operations.
504: *********************************************************************/
505:
506: PROCEDURE Perform_Writes
507: ( p_eam_op_rec IN EAM_PROCESS_WO_PUB.eam_op_rec_type

Line 562: from wip_operations

558: IF p_wip_entity_id is not null
559: THEN
560: select count(*)
561: into l_count
562: from wip_operations
563: where wip_entity_id = p_wip_entity_id
564: and organization_id = p_organization_id
565: AND rownum <=1;
566: