APPS.EAM_REQUIREMENTS_PKG dependencies on WIP_REQUIREMENT_OPERATIONS

Line 104: FROM WIP_REQUIREMENT_OPERATIONS

100: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
101:
102: CURSOR C IS
103: SELECT rowid
104: FROM WIP_REQUIREMENT_OPERATIONS
105: WHERE inventory_item_id = X_inventory_item_id
106: AND organization_id = X_organization_id
107: AND wip_entity_id = X_wip_entity_id
108: AND operation_seq_num = X_operation_seq_num;

Line 474: FROM WIP_REQUIREMENT_OPERATIONS

470: X_attribute15 IN VARCHAR2,
471: X_auto_request_material IN VARCHAR2) IS
472: CURSOR C IS
473: SELECT *
474: FROM WIP_REQUIREMENT_OPERATIONS
475: WHERE rowid = X_row_id
476: FOR UPDATE of Wip_Entity_Id NOWAIT;
477: Recinfo C%ROWTYPE;
478: BEGIN

Line 617: FROM WIP_REQUIREMENT_OPERATIONS

613:
614:
615: SELECT wip_entity_id, organization_id, operation_seq_num, inventory_item_id
616: INTO l_wip_entity_id, l_org_id, l_operation_seq_num, l_inventory_item_id
617: FROM WIP_REQUIREMENT_OPERATIONS
618: WHERE rowid = X_row_id;
619:
620: l_eam_mat_req_rec.header_id := l_wip_entity_id;
621: l_eam_mat_req_rec.batch_id := 1;

Line 854: DELETE FROM WIP_REQUIREMENT_OPERATIONS

850:
851:
852: /* Commented out for implementing the WO API */
853: /*
854: DELETE FROM WIP_REQUIREMENT_OPERATIONS
855: WHERE wip_entity_id = p_wip_entity_id
856: and organization_id = p_organization_id
857: and inventory_item_id = p_inventory_item_id
858: and operation_seq_num = p_operation_seq_num; */